Microsoft Access 2016 (Level 3)

Audience Profile

This course is for the individual whose job responsibilities include working with heavily related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance.  This course will also assist students preparing for the Microsoft Office Specialist exam for Microsoft Access 2016.

At Course Completion

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

• Write basic SQL statements
• Write advanced queries to analyze and summarize data
• Create and revise Microsoft Access 2016 macros
• Import, export and link objects
• Maintain databases using Microsoft Access 2016 tools

Prerequisites

To ensure your success, knowledge of basic and intermediate features of Access tables, relationships, and queries, forms, and reports is required.  Students should attend Microsoft Access 2016 Level 1 and Microsoft Access 2016 Level 2, or possess equivalent knowledge prior to attending this class.