This course is designed to teach students intermediate level skills in Microsoft Access 2019. In this course, students will learn to design tables for improved accuracy in data entry, review the various options to share data with other applications, learn about action queries, and review various advanced query techniques. Students will also learn how to automate processes with Macros, advanced form techniques, and advanced report techniques. This course prepares students for the Access 2019 Advanced course.

After completing this online training course, students will be able to:

  • Designing Tables for Better Data Entry
  • Sharing Data with Other Applications
  • Working with Action Queries
  • Advanced Query Techniques
  • Automating Processes with Macros
  • Advanced Form Techniques
  • Advanced Report Techniques

Students who’ve attended Access 2019 Beginner and want to learn more about Access.

The recommended prerequisite for this course is Access 2019 Beginner or equivalent experience.

01. Designing Tables for Better Data Entry
02. Sharing Data with Other Applications
03. Working with Action Queries
04. Advanced Query Techniques
05. Automating Processes with Macros
06. Advanced Form Techniques
07. Advanced Report Techniques