Advanced Microsoft® Access: Business Integration, Automation and Security

2 days

Experienced and Intermediate-Level Database and Microsoft Excel and Access Users, General Managers, Database Managers, Database Developers and Programmers.
This course requires the following prerequisites:

  • User Knowledge of Microsoft Windows
  • Intermediate Knowledge of Microsoft Access

In previous training, you were introduced to various features of Microsoft Office Access focusing on local database management. However, effective database management calls for mastering the advanced administrative and collaborative features of Access. In this course, you will exchange data with other applications, automate business processes by using macros and VBA code, and secure databases.

You will also receive real-world examples and strategies on how to use XML effectively for your business processes, along with numerous practical examples of Macro and VBA code examples for your Microsoft Access forms and reports.


Section 1: Advanced File Tasks

  • Using Windows Explorer within Access
  • Database Management
  • Saving Your Files
  • Exporting Files
  • Linking Files

Section 2: Working with Tables

  • Customizing Tables
  • Formatting Tables
  • Controlling Table Data Entry
  • Managing Table Data Entry

Section 3: Working with Forms

  • Basic Form Controls
  • Advanced Form Controls
  • Formatting Your Form
  • Formatting Controls
  • Using Themes

Section 4: Working with Reports

  • Organizing Report Data
  • Formatting Reports
  • Common Report Tasks

Section 5: Working with Queries

  • Basic Queries
  • Doing More with Queries
  • Creating Advanced Queries
  • Creating Management (Action) Queries
Skills Taught: 
  • Integrate Access into your business using XML, and by sharing Access data with other applications.
  • Create and revise Microsoft Office Access 2010 macros.
  • Use Macros and VBA to automate business processes.
  • Create and modify database switchboards, and set database startup options.
  • Protect and Secure Access databases.