Loading...

Course Description

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.

Related Courses

Other Courses

Attend and You Will Learn / Expected Outcome

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

Instructors

Loading...

Enroll Now - Select a section to enroll in

Section Title
Access Level 3
Type
In-Class
Days
Th, F
Time
9:00AM to 4:30PM
Dates
Mar 05, 2020 to Mar 06, 2020
Schedule and Location
Contact Hours
12.0
Location
Delivery Options
Course Fee(s)
Standard Registration Fee non-credit $545.00
Instructors
Section Title
Access Level 3
Type
In-Class
Days
T, W
Time
9:00AM to 4:30PM
Dates
Jul 28, 2020 to Jul 29, 2020
Schedule and Location
Contact Hours
12.0
Location
Delivery Options
Course Fee(s)
Standard Registration Fee non-credit $545.00
Instructors