Microsoft Access 2016 Level 3

You’ve covered many of the basic functions of Microsoft® Office Access® 2016, 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 multi-user access, and more. Knowledge of these features separate database professionals from the casual database users or occasional designers. Today’s training, added to that which you’ve gained from the Microsoft® Office Access® 2016: Part 1 and Microsoft® Office Access® 2016: Part 2 courses, rounds out your Access education and provides you with marketable job skills.

• N/A

• N/A

• Microsoft Access 2016 Level 1
• Microsoft Access 2016 Level 2

Module 1: Implementing Advanced Form Design

• Add Controls to Forms
• Enhance Navigation and Organization of Forms
• Apply Conditional Formatting

Module 2: Sharing Data Across Applications

• Import Data into Access
• Export Access Data
• Link Tables to External Data Sources
• Create a Mail Merge

Module 3: Using Macros to Improve User Interface Design

• Create a Macro
• Restrict Records Using a Condition
• Validate Data Using a Macro
• Automate Data Entry Using a Macro

Module 4: Using VBA

• Getting Started with VBA
• Enhance Access Using VBA

Module 5: Using Advanced Database Management

• Manage a Database
• Determine Object Dependency
• Document a Database

Module 6: Distributing and Securing a Database

• Splitting a Database for Multiple User Access
• Implement Security
• Convert an Access Database to an ACCDE File
• Package a Database with a Digital Signature

Module 7: Managing Switchboards

• Create a Database Switchboard
• Modify a Database Switchboard
• Set Startup Options