Home > Microsoft Office Training > Microsoft Access 2007 Level 3 - Advanced Topics

Microsoft Access 2007 Level 3
Advanced Topics

Course ID: D173
Duration: 1 day

Prerequisites

Microsoft Access 2007 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 customize the Navigation Pane
  • Acquire information about running administrative functions in Access
  • Establish and maintain security in a database

Course Content

Macros
Macro Concepts ; Creating a Macro ; Creating a Macro Group ; Opening a Macro ; Running a Macro ; Attaching a Macro ; Macro Conditions

Switchboard
Switchboards Overview ; Creating Switchboards ; Editing a Switchboard Form

Customizing Access
Setting Access Defaults ; Customizing the Navigation Pane

Administrative Functions
Compacting a Database ; Backing Up a Database ; Splitting a Database ; Documenting a Database

Database Security
Securing a Database ; Securing a Share-Level Database ; Access Trust Center

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