CATALOG ‣
Menu
Microsoft Surface on ipad stock photo
COURSE CATALOG

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

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
COURSE CATALOG
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.