Microsoft Access – Part 3 (MA6235)

You've covered many of the basic functions of Microsoft Access, and now you're ready to learn 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.

This course is the third part of a three-course series that covers the skills needed to perform basic database design and development in Microsoft Access.

Microsoft Access for Microsoft 365: Part 3 (this course): Focuses on managing the database and supporting complex database designs, including import and export of data; using action queries to manage data; creating complex forms and reports; macros and Visual Basic for Applications (VBA); and tools and strategies to manage, distribute, and secure a database.

This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Access Expert (Office 365 and Office 2019): Exam MO-500 certification.

A preferential rate (-15%) applies to the regular cost for non-profit organizations, as well as the government sector. In addition, you can benefit from additional advantages through a corporate agreement when you need to train several people or teams in your company. Contact us for details.

Public class

1 day / 7 hours

Private class

Virtual classroom
Minimum no. of participants: 6
1 day / 7 hours
Price on request
English or Serbian
Training plan: 

Module 1: Importing and Exporting Table Data

  • Import and Link Data
  • Export Data
  • Create a Mail Merge

Module 2: Using Queries to Manage Data

  • Create Action Queries
  • Create Unmatched and Duplicate Queries

Module 3: Creating Complex Reports and Forms

  • Create Subreports
  • Create a Navigation Form
  • Show Details in Subforms and Popup Forms

Module 4: Creating Access Macros

  • Create a Standalone Macro to Automate Repetitive Tasks
  • Create a Macro to Program a User Interface Component
  • Filter Records by Using a Condition
  • Create a Data Macro

Module 5: Using VBA to Extend Database Capabilities

  • Introduction to VBA
  • Use VBA with Form Controls

Module 6: Managing a Database

  • Back Up a Database
  • Manage Performance Issues
  • Document a Database

Module 7: Distributing and Securing a Database

  • Split a Database for Multiple-User Access
  • Implement Security
  • Convert an Access Database to an ACCDE File
  • Package a Database with a Digital Signature
  • Course material accessible in electronic format
  • Certificate of attendance (on request)

To ensure your success in this course, you should have experience working with Access for Office 365, including a working knowledge of database design and creation, form design and creation, report design and creation, and a working knowledge of database querying and the various table relationships.


Contact us for more information on pricing::

Office: 1-888-718-9732
E-mail: info@eccentrix.ca

130, King Street West, Suite 1800
Toronto, Ontario M5X 1E3