Microsoft Access 2016 Advanced Training Course

If you have already have experience working with Access 2016 and now need to learn advanced skills, this is the right course for you.

During this Microsoft Access 2016 course, you will learn to create and manage a fundamental Access database.

You will learn how to:

• Customize a form layout to improve usability and efficiency of data entry.
• Share data across applications
• Use macros to improve user interface design
• Use VBA to enhance tasks
• Organize data into appropriate tables to ensure data dependency and minimize redundancy
• Lock down and prepare a database for distribution to multiple users
• Create and modify a database switchboard and set the startup options

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

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

• Create a Macro in Microsoft Access 2016
• Restrict Records Using a Condition
• Validate Data Using a Macro
• Automate Data Entry Using a Macro

• Getting Started with VBA
• Enhance Access Using VBA

• Manage a Database
• Determine Object Dependency
• Document 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

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