Microsoft Access Intermediate (2024)


R1,500.00R2,173.63 (Excl. VAT)


This course enables individuals to create more sophisticated databases, design complex forms and reports, optimize queries, automate tasks with macros, and collaborate effectively. The training’s purpose is to enhance participants’ proficiency in Access and empower them to manage data more efficiently in a variety of professional settings.

What you will learn in this course

Lesson 1: Database Design and Table Relationships

  • Review of Database Basics
  • Intermediate Table Design
  • Establishing Table Relationships
  • Enforcing Referential Integrity

Lesson 2: Intermediate Query Design

  • Creating Queries with Multiple Tables
  • Joining Tables with INNER and OUTER Joins
  • Calculated Fields and Expressions
  • Parameter Queries and Query Criteria


Lesson 3: Form Design and Customization

  • Advanced Form Design Techniques
  • Sub-forms and Tab Controls
  • Form Navigation and Layout
  • Data Validation and Input Masks


Lesson 4: Report Creation and Customization

  • Building Complex Reports
  • Grouping and Sorting Data
  • Calculated Controls in Reports
  • Advanced Printing and Export Options


Lesson 5: Data Validation and Integrity

  • Data Validation Rules
  • Input Masks and Validation Text
  • Table Validation Rules
  • Using Validation in Forms and Reports


Lesson 6: Query Optimization and Performance

  • Indexing and Query Performance
  • Query Optimization Techniques
  • Query Tuning

Lesson 7: Macros and Automation

  • Creating Data Macros
  • Macro Design and Debugging
  • Automating Tasks with Macros
  • Event-Driven Macros


Lesson 8: Importing and Exporting Data

  • Importing Data from External Sources
  • Exporting Data to Various Formats
  • Using Import and Export Specifications
  • Automating Data Transfer


Lesson 9: Collaboration and Integration

  • Integrating with Other Office Applications
  • Collaborative Features with SharePoint
  • Web Database Publishing
  • Multi-User Database Management


Lesson 10: Advanced Tips and Tricks

  • Keyboard Shortcuts and Productivity Tips
  • Troubleshooting Common Issues
  • Database Backup and Recovery
  • Best Practices in Access Development

Troubleshooting Performance Issues

Who should attend?


Business Professionals who need to create and manage databases for tracking and reporting. Office Administrators and Data Entry Specialists responsible for maintaining databases. Small Business Owners looking to organize and analyse their business data. Students and Learners interested in acquiring database management skills. Anyone seeking a foundational understanding of Microsoft Access


Select Per Person or A Group of people Programme *
Please include:


Choose Intake & Study Mode

Related Courses

Select Per Person or A Group of people Programme *
Please include:
    Your Cart
    Your cart is emptyReturn to Shop
    Your skills provider of choice since 1957 providing purposeful development journeys through its unique mix of people, solutions and passion so that individuals, teams and organisations are empowered to make a difference.