Access Level 3
CTU-ACCESS10L3-C

 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.

Prerequisites

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



Sections

  Access Level 3
CTU-ACCESS10L3-C - 012
   
 
  2015 - TTS - Jan - Apr 2015   Status:  Available
 
In-Class:   Mon, Wed 9:00AM - 4:30PM
20 Apr 2015 to 22 Apr 2015
Class Schedule: 2 Sessions
Contact Hours: 12.0
Course Fee(s):
Registration Fee non-credit    $449.00
Gov't & Non-Profit Registration Fee non-credit    $349.00
Potential Discount(s):
  1.20 CEUs
Location:   On Campus
 
  Access Level 3
CTU-ACCESS10L3-C - 013
   
 
  2015 - TTS - May - Jun 2015   Status:  Available
 
In-Class:   Mon, Tue 9:00AM - 4:30PM
29 Jun 2015 to 30 Jun 2015
Class Schedule: 2 Sessions
Contact Hours: 12.0
Course Fee(s):
Registration Fee non-credit    $449.00
Gov't & Non-Profit Registration Fee non-credit    $349.00
Potential Discount(s):
  1.20 CEUs
Location:   On Campus
 
  Access Level 3
CTU-ACCESS10L3-C - 014
   
 
  2016 - TTS - Jul - Aug 2015   Status:  Available
 
In-Class:   Tue, Wed 9:00AM - 4:30PM
11 Aug 2015 to 12 Aug 2015
Class Schedule: 2 Sessions
Contact Hours: 12.0
Course Fee(s):
Registration Fee non-credit    $449.00
Gov't & Non-Profit Registration Fee non-credit    $349.00
Potential Discount(s):
  1.20 CEUs
Location:   On Campus