Home > Microsoft Office Training > Microsoft Access 2000 - 2003 Level 3 - Advanced Topics

Microsoft Access 2000 - 2003 Level 3
Advanced Topics

Course ID: D1N3
Duration: 1 day

Prerequisites

Access 2000 - 2003 Level 2 - Advanced Database Design

Course Objectives

After completing the course, participants will be able to:

  • Understand macro concepts, create, run, and test Access macros
  • Create and use switchboard forms
  • Set Access defaults, apply Startup options, and create and attach command bars
  • Acquire information about running administrative functions in Access
  • Establish and maintain security in a database
  • Replicate a database

Course Content

Macros
Macro Concepts ; Creating Macros ; Creating Macro Groups ; Opening Macros ; Running Macros ; Testing Macros ; Attaching a Macro ; Macro Conditions

SwitchBoard
Switchboard Overview ; Creating Switchboards ; Editing a Switchboard Form

Customizing Access
Setting Access Defaults ; Startup Options ; Customizing Command Bars

Administrative Functions
Compacting Databases ; Documenting a Database ; Splitting Databases

Database Security
Securing Databases ; Securing Share-Level Databases ; Securing Multi-User Databases

Replicating
Replicating Databases

More Information

For more information, contact us by phone or send us an e-mail.

Toll Free: (866) 926-5671

Halifax • Montreal • Ottawa • Toronto • Winnipeg
Regina • Saskatoon • Calgary • Edmonton • Vancouver