Microsoft Access Advanced (2016, 2019, 365)

Formats: 4-hour virtual course  |  1-day instructor-led onsite

This course teaches advanced Access® features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multiple-user access, and more. Knowledge of these features separate database professionals from the casual database users or occasional designers.

Learning Objectives »

  • Share data across applications
  • Use action, unmatched, and duplicate queries
  • Create complex reports and forms
  • Use macros to improve user interface design
  • Use VBA to extend database capabilities
  • Backup, compact, repair, perform analysis, check object dependencies, and document

Course Agenda »

Importing and Exporting Table Data

  1. Import and Link Data
  2. Export Data
  3. Create a Mail Merge

Using Queries to Manage Data

  1. Create Action Queries
  2. Create Unmatched and Duplicate Queries

Creating Complex Reports and Forms

  1. Create Sub-reports
  2. Create a Navigation Form
  3. Show Details in Sub-forms and Popup Forms

Creating Access Macros

  1. Create a Standalone Macro to Automate Re-petitive Tasks
  2. Create a Macro to Program a User Interface Component
  3. Restrict Records by Using a Condition
  4. Create a Data Macro

Managing a Database

  1. Back Up a Database
  2. Manage Performance Issues
  3. Document a Database

Using VBA to Extend Database Capabilities

  1. Getting Started with VBA
  2. Using VBA with Form Controls

Distributing and Securing a Database

  1. Split a Database for Multiple-User Access
  2. Implement Security
  3. Convert an Access Database to an ACCDE File
  4. Package a Database with a Digital Signature