Instructorctclc admin
TypeOnsite Course
1 Days
Methods of Delivery
Buy NowBook Now

This advanced course assumes you have completed Access 2019 Level 1, or you have equivalent skills in using Access. You will benefit most from this course if you want to be an advanced user of Access 2019.

This course provides the concepts and skills for the advanced use of Microsoft Access: How to create advanced queries, forms, and reports, how to create macros, and how to manage your databases.

Which Access series is right for me?

Our Relational Database Design and Relational Database Management courses are meant for students who want to build Access databases from the ground up. The first course is two days and includes in-depth, hands-on exercises that teach effective relational database development. Any student who completes these courses will be able to create and maintain a database for a small business or other organization.

Level 1 and Level 2, on the other hand, are intended for students who will be working with existing databases rather than building them from scratch. In other words, these courses are best suited to database end users rather than database designers/managers.

Course Outline

Course Objectives

Module 1: Advanced queries

  • Grouping and summarizing
  • Updating, deleting, and relationships
  • Indexing for performance


Module 2: Advanced forms

  • Subforms
  • Advanced control types
  • Specialized form types

Module 3: Advanced Reporting

  • Subreports
  • Advanced grouping
  • Advanced formatting

Module 4: Macros

  • Creating basic macros
  • Using variables
  • Troubleshooting macros

Module 5: Database management

  • Compact and repair
  • Restoring a database
  • Other maintenance tasks