Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:


Microsoft Access 2007 Level 3 - Advanced Topics

GK# 8656

Course Overview


In this one-day course, you will learn about Microsoft Access 2007 advanced topics, including macros, and switchboard forms, administrative functions, and how to customize your Access databases. You will set Access defaults, apply Startup administrative functions, and establish and maintain security in a database.


  • Delivery Format:
  • Date:
  • Location:
  • Access Period:


What You'll Learn

  • 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


Viewing outline for:

Classroom Live Outline

1. Macros

  • Macro Concepts
  • Creating a Macro
  • Creating a Macro Group
  • Opening a Macro
  • Running a Macro
  • Attaching a Macro
  • Macro Conditions

2. Switchboard

  • Switchboards Overview
  • Creating Switchboards
  • Editing a Switchboard Form

3. Customizing Access

  • Setting Access Defaults
  • Customizing the Navigation Pane

4. Administrative Functions

  • Compacting a Database
  • Backing Up a Database
  • Splitting a Database
  • Documenting a Database

5. Database Security

  • Securing a Database
  • Securing a Share-Level Database
  • Access Trust Center



Working intermediate knowledge of Microsoft Access 2007

Who Should Attend


Those with an intermediate working knowledge of Microsoft Access 2007 who want to explore advanced database topics

Course Delivery

This course is available in the following formats:

Classroom Live

Receive face-to-face instruction at one of our training center locations.

Duration: 1 day

Request this course in a different delivery format.