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

Cart () Loading...

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

    $

Microsoft Access 2007 Level 3 - Advanced Topics

GK# 8656

Course Overview

TOP

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.

What You'll Learn

TOP
  • 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

Outline

TOP
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

Prerequisites

TOP

Working intermediate knowledge of Microsoft Access 2007

Who Should Attend

TOP

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.
Enroll