Access 2013 Advanced

Access iconCourse Length

Full day

Course Description

This course is for the individual, whose job responsibilities include the need to use Access features such as database management, advanced form design, encrypting a database, preparing a database for multi-user access, and more.

Course Topics

Learn Advanced Form Design

  • Add controls to forms
  • Create Subforms
  • Organize information with Tab pages
  • Enhance Navigation forms
  • Apply Conditional formatting

Use Data Validation

  • Field Validation
  • Form and record validation

Use 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
  • Convert a macro to VBA

Use Advanced Database Management

  • Link tables to external data sources
  • Manage a database
  • Determine Object Dependency
  • Document a database
  • Analyze the performance of a database

Securing a Database

  • Split a database for multiple user access
  • Implement security
  • Set passwords
  • Convert an Access database to an ACCDE file

Manage Switchboards

  • Create a database switchboard
  • Modify a database switchboard
  • Set Startup options

What Participants Receive

Each participant receives a guide containing step-by-step instructions.