View all courses

Previous training and experience using Microsoft® Office Access® will give participants basic database management skills, such as creating tables, designing forms and reports, and building queries. In this course participants will expand their knowledge of relational database design; promote quality input from users; improve database efficiency and promote data integrity; and implement advanced features in tables, queries, forms and reports. Extending your knowledge of Access will result in a robust, functional database for your users.

This 1-day instructor-led course is the second part of a three-course series that covers the skills needed to perform database design and development in Access 2019/2021. Part 2 focuses on optimization of an Access database, including optimizing performance and normalizing data; data validation; usability; and advanced queries, forms and reports. Note: this material will benefit users of any current Office version. The classroom environment setup is based on Office 2019. This course also covers Microsoft Office Specialist Program exam objectives to help learners prepare for the Access Expert (Office 363 and Office 2019): Exam MO-500 certification.

Additional considerations:
Microsoft® Office Access® 2019/2021 Part 1 focuses on the design and construction of an Access database—viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms and reports.

Microsoft® Office Access® 2019/2021 Part 3 focuses on managing the database and supporting complex database designs, including import and export of data; using action queries to manage data; creating complex forms and reports; macros and Visual Basic for Applications (VBA); and tools and strategies to manage, distribute and secure a database.

Target Audience
This course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases and developing tables, queries, forms and reports in Microsoft Office Access 2019/2021.

What You'll Learn

  • Provide input validation features to promote the entry of quality data into a database
  • Organize a database for efficiency and performance, and to maintain data integrity
  • Improve the usability of Access tables
  • Create advanced queries to join and summarize data
  • Use advanced formatting and controls to improve form presentation
  • Use advanced formatting and calculated fields to improve reports

*Request Detailed Syllabus

Register for this course
View all courses
  • Course Number M91046
  • Course Length 1 day
  • Course Fee $295.00
  • Delivery Format vILT (Instructor Led; Virtual LIVE Online; Remote Training)
  • Course Topic Data Management and Analytics
  • Vendor Microsoft
  • Technology Access

Register for course: M91046

"*" indicates required fields

This field is for validation purposes and should be left unchanged.