Blog
Catalog
Menu
Microsoft Surface on ipad stock photo
a stack of orange and white books with text overlay of different training topics related to the professional workforce.
Browse hundreds of training topics to elevate team performance.
a laptop and phone with course training text on the screen.

Learn about PTR’s interactive course workbook for different learning styles.

Professional African-American woman training instructor smiling with overlay text.

PTR instructors are experts at delivering engaging, professional training.

Microsoft Access for Office 365 Advanced Training Course

Formats ⟩  Live Virtual: 4 hrs./1 Day  |  In-Person: 6 hrs./1 Day

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 separates database professionals from casual database users or occasional designers.

Course Prerequisite: Microsoft Access for Office 365 Intermediate

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 Repetitive 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
Microsoft Surface on ipad stock photo

Microsoft Access for Office 365 Advanced Training Course

Formats ⟩  Live Virtual: 4 hrs./1 Day  |  In-Person: 6 hrs./1 Day

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 separates database professionals from casual database users or occasional designers.

Course Prerequisite: Microsoft Access for Office 365 Intermediate

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 Repetitive 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
PTR Training uses 'cookies' to improve your website experience. View our Privacy Policy for details. By continuing, you agree to accept and adhere to our Terms of Use.