Course Description

Learn the many facets of Microsoft Access 2019, from basic functions like database objects, querying a database and creating reports to advanced reporting techniques, macros and database design.

This course prepares students for the Microsoft Access 2019 national certification exam.

Course Outline

Lesson 1: Database Basics

Lesson 2: Maintaining a Database and Creating Reports

Lesson 3: Advanced Reporting

Lesson 4: Advanced Form Techniques and Macros

Lesson 5: Administering Access and Using SQL

Lesson 6: Database Design

Learner Outcomes

Upon successful completion of this course, students will be able to:

  • Create a Microsoft Access database.
  • Create a report from a database.
  • Create queries in a database.
  • Maintain a database by using action queries, formatting a datasheet and sorting records.
  • Create reports and forms.
  • Perform advanced report and form techniques.
  • Create and modify macros in a database.
  • Demonstrate the use of SQL language.
  • Design a database.


Students must have a copy of Microsoft Office 365 in order to complete coursework.

Students have 12 months to complete this self-paced online course.

System Requirements:

Internet Connectivity Requirements:
  • Cable and DSL internet connections recommended for best experience.
Hardware Requirements:
  • CPU: 1 GHz or higher
  • RAM: 2 GB or higher
  • Resolution: 1280 x 720 or higher
  • Speakers / Headphones
  • Microphone (Webinar / Live Online sessions)
Operating System Requirements:
  • Microsoft Windows 7 or 10 (Home, Pro)
  • Mac OSX 10 or higher.
  • Latest Chrome OS
  • Latest Linux Distributions

NOTE: While our courses can be viewed on Android and iPhone devices, we do not recommend using these devices for our courses. The size of these devices do not provide a good learning environment for students taking online or live online-based courses.

Web Browser Requirements:
  • Latest Google Chrome recommended for best experience.
  • Latest Mozilla Firefox
  • Latest Microsoft Edge
  • Latest Apple Safari
Basic Software Requirements:
  • Office suite software (Microsoft Office, OpenOffice or LibreOffice)
  • PDF reader program (Adobe Reader, FoxIt)
  • Courses may require other software as denoted in above course outline.
Enroll Now - Select a section to enroll in
Section Title
Microsoft Office 365: Access 2019 (Online)
Sep 07, 2021 to Jun 30, 2023
Contact Hours
Delivery Options
Course Fee(s)
Course Fee non-credit $470.00