In this advanced Access 2016 course, you will learn to turn your Access databases into user-friendly applications and expand your knowledge of Microsoft Access to create clever solutions to common problems.

Performance Objectives: Upon completion of this course, you should be able to:

• Create custom menus and screens that restrict what users can see and do.
• Use Visual Basic for Applications to write reusable code, work with variables, and use Access objects.
• Understand Linked Databases and the value in separating tables from the queries, forms, and reports of the application.
• Combine advanced parameter queries with controls.
• Use domain functions to find related data and present results in forms and reports.
• Use forms to get the right data for reports.
• Automate interactions between Access and other Microsoft Office products. For example, create a button on a form to automatically email a report.
• Work with unbound versus bound forms using ADO and DAO to build lists and edit data based on user input.

Recommended Prerequisite: We recommend you complete Access 2016 Level 1 and Access 2016 Level 2 or have equivalent experience before registering for this course.

Intended Audience: All audiences with experience using Access.