Advanced Microsoft Access 2016 - Code Chiefs

Advanced Microsoft Access 2016

Regular price £29.00 Sale

Unlimited Access

6 Units, 37 Activities and Labs

Certificate of Completion

Level 3 Equivilent Content

5+ Hours of Content

Course Description

Learn about how to exploit advanced features in Microsoft Access with our Advanced Microsoft Access 2016 course which builds upon our MS Access for Beginners course. Skills, you will learn include:

Implementing Advanced Form Design

Using Data Validation

Using Macros to Improve User Interface Design

Using Advanced Database Management

Distributing and Securing a Database

Managing Switchboards


Our Advanced Microsoft Access 2016 course is fully compatible with any kind of device which is able to run Microsoft Access 2016. Whether you are using Windows computer, Mac, or Linux, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.

Who is it for?

This Advanced Microsoft Access 2016 course is ideal for those students who want to build on the Introduction to MS Access 2016 course, want to further develop thier skills or take their MS Access knowledge to the next level.

Career path

After completing this Microsoft Access 2016 course you will be able to build up accurate knowledge and skills with real confidence to up skill in your career.


Implementing Advanced Form Design

  • Types of Controls
  • Command Buttons
  • Quick Start Fields
  • Calendar/Datepicker Control
  • Form Layouts
  • Quick Styles
  • Tab Order
  • The Anchoring Tool
  • Move Form Controls
  • Add Form Controls
  • Remove Form Controls
  • Modify Data Sources
  • Set Form Control Properties
  • Manage Labels
  • Subforms
  • Tab Pages
  • Navigation Control and Navigation Forms
  • Setting Navigation Options
  • Creating a Navigation Form
  • Using a Navigation Form
  • Insert Headers And Footers
  • Insert Images
  • Auto-Order Forms
  • Sort Records
  • Apply Themes
  • Insert Backgrounds
  • Change Margins

Conditional Formatting​​​​​​​​​​​​​​

  • Summary
  • Review Questions

Using Data Validation

  • Field Properties
  • Input Masks
  • The Input Mask Wizard
  • Input Mask Characters
  • Lookup Lists
  • Expression Builder
  • Form Validation
  • Control Wizards
  • The Combo Box Control
  • The List Box Control
  • The Option Group Control
  • Record Validation
  • Summary
  • Review Questions

Using Macros to Improve User Interface Design

  • Macros
  • The Macro Builder Window
  • Macro Actions
  • Types of Macro Actions
  • Action Arguments
  • Object Events
  • Macros in Access Web Apps
  • Macro Conditions
  • The Where Condition
  • Event Properties for Data Validation
  • Macro Actions for Data Validation
  • Embedded Macros
  • Event Properties for Automating Data Entry
  • Macro Actions for Automating Data Entry
  • Macros and VBA
  • Summary
  • Review Questions

Using Advanced Database Management

  • External Data Sources
  • The Linked Table Manager
  • Exclusive Mode
  • Database Access Modes
  • Database Backup
  • The Compact and Repair Database Option
  • Object Dependency
  • The Database Documenter
  • Performance Analyzer
  • Summary
  • Review Questions

Distributing and Securing a Database

  • Splitting a Database
  • Merging a Database
  • Security Strategies in Access 2016
  • The Message Bar
  • The Trust Center Dialog Box
  • Trusted Locations
  • Password Protection Guidelines
  • The ACCDE File Format
  • User Templates
  • Saving Databases as Templates
  • Digital Signatures
  • Digital Certificates
  • The Package and Sign Feature
  • Summary
  • Review Questions

Managing Switchboards

  • Switchboards
  • Switchboard Manager
  • Switchboard Modification
  • Database Startup Options
  • Summary
  • Review Questions

Extra Materials

  • Appendices
  • 11 Practical Labs
  • Keyboard Shortcut Quick Reference Sheet
  • Glossary


Courses featured on

Liquid error: Could not find asset snippets/eu-cookie-banner-app.liquid