Microsoft 365 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.

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.

Public class

Duration:

1 day / 7 hours

Private class

Virtual classroom

Minimum no. of participants: 6

1 day / 7 hours

Price on request

English or French

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

Exclusives:

Course material accessible in electronic format
Certificate of attendance (on request)

View the complete list of exclusives offered for your course

Prerequisites:

To ensure your success in this course, you should have experience working with Access, 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.

Follow-on trainings:

Microsoft 365 Outlook: Part 1 (MO55193)

Microsoft 365 Outlook: Part 2 (MO55194)

Audiences:

Office User

Contact us for more information on pricing::

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

130, King Street West, Suite 1800
Toronto, Ontario M5X 1E3
www.eccentrix.ca