Access 2016 Advanced - Full Day Class Personalize our class outlines. We'll create a class just for you.

Printable Version  |  See Other Class Topics  |  See All Class Outlines


Upon successful completion of this course, students will be able 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

Course Content

Lesson 1: Implementing Advanced Form Design

  1. Add Controls to Forms
  2. Enhance Navigation and Organization of Forms
  3. Apply Conditional Formatting

Lesson 2: Sharing Data Across Applications  

  1. Import Data into Access
  2. Export Access Data
  3. Link Tables to External Data Sources
  4. Create a Mail Merge

Lesson 3: Using Macros to Improve User Interface Design

  1. Create a Macro 
  2. Restrict Records Using a Condition
  3. Validate Data Using a Macro
  4. Automate Data Entry Using a Macro

Lesson 4: Using VBA

  1. Getting Started with VBA
  2. Enhance Access Using VBA

Lesson 5: Using Advanced Database Management

  1. Manage a Database
  2. Determine Object Dependency
  3. Document a Database

Lesson 6: Distributing and Securing a Database

  1. Splitting 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

Lesson 7: Managing Switchboards

  1. Create a Database Switchboard
  2. Modify a Database Switchboard
  3. Set Startup Options

Appendix A: Microsoft Office Access 2016 Exam 77-730
Appendix B: Microsoft Office Access 2016 Common Keyboard Shortcuts 

If you would like to customize this course, please call us at (888) 572-1200.

Have a Question?

Give us a call at (888) 572-1200 or contact us for fast attention.

Get in touch!