Access Level 3

 Email this information to yourself or a friend

 Remind me of this course at a later date

Official Program Description

Access Level 3

jump to schedules and register

You've covered many of the basic functions of Microsoft® Office Access® 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.

Who Should Attend

This course is for the individual whose job responsibilities include working with heavily related tables, writing macros to automate common tasks, performing general database maintenance, and creating advanced queries, forms, and report.


To ensure your success, knowledge of the basic and intermediate features ofMicrosoft® Office Access® Level 1 and Microsoft® Office Access® Level 2 is recommended.

Attend and You Will Learn

Implementing Advanced Form Design

  • Adding controls to forms
  • Creating subforms
  • Organizing information with tab pages
  • Enhancing navigation of forms
  • Applying conditional formatting

Using Data Validation

  • Using field and record validation
  • Using form validation

Using Macros to Improve User Interface Design

  • Creating a macro
  • Restricting records using a condition
  • Validating data using a macro
  • Automating data entry using a macro
  • Converting a macro to VBA

Using Advanced Database Management

  • Linking tables to external data sources
  • Managing a database
  • Determining object dependency
  • Documenting a database
  • Analyzing the performance of a database

Distributing and Securing a Database

  • Splitting a database for multiple user access
  • Implementing security
  • Setting passwords
  • Converting an Access database to an ACCDE file
  • Packaging a database with a digital signature

Managing Switchboards

  • Creating a database switchboard
  • Modifying a database switchboard


  Access Level 3
CTU-ACCESS10L3-C - 016
  2016 - TTS - Sep - Dec 2015   Status:  Available
In-Class:   Mon, Tue 9:00AM - 4:30PM
23 Nov 2015 to 24 Nov 2015
Class Schedule: 2 Sessions
Contact Hours: 12.0
Course Fee(s):
Gov't & Non-Profit Registration Fee non-credit    $349.00
Registration Fee non-credit    $449.00
Potential Discount(s):
  1.20 CEUs
Location:   On Campus