Course Outline

MS Access 2007

This is a typical 1 day course split up into 5-10 minute lessons so you can follow the outline in sequence or jump to the topic you want to learn about. Typically, a course outline will contain on average 35 Bite Size lessons. Remember to practice your new found skills. This will help to reinforce the learning and retain your skills.

Getting Started
Lesson not Started  Access Environment
Lesson not Started  Getting Help

What's new in Access 2007
Lesson not Started  The Office Button
Lesson not Started  The Ribbon
Lesson not Started  Quick Access Toolbar
Lesson not Started  The Status Bar
Lesson not Started  Saving Files
Lesson not Started  Document Window
Lesson not Started  Creating Lookup List
Lesson not Started  Reporting Layout View
Lesson not Started  Sorting & Filtering
Lesson not Started  Grouping Report Data

Databases
Lesson not Started  Databases Explained
Lesson not Started  Planning & Designing Databases
Lesson not Started  Creating a new Database
Lesson not Started  Opening & Closing Database
Lesson not Started  Navigating around Database Objects
Lesson not Started  Saving Databases
Lesson not Started  Opening Templates

Tables
Lesson not Started  Datasheet & Design Views
Lesson not Started  Creating Tables using Design Views
Lesson not Started  Creating Tables by Entering Data
Lesson not Started  Resizing Columns
Lesson not Started  Adding new Records,Fields to an Existing Table
Lesson not Started  Saving Tables

Fields and Records
Lesson not Started  Fields & Records Explained
Lesson not Started  Editing Records
Lesson not Started  Field Properties
Lesson not Started  Finding Records
Lesson not Started  Sorting Records
Lesson not Started  Filtering Records

Queries
Lesson not Started  Queries Explained
Lesson not Started  Creating Queries using the Wizard
Lesson not Started  Creating Queries using Design View
Lesson not Started  Using Query Criteria
Lesson not Started  Using Multiple Query Criteria
Lesson not Started  Saving Queries

Forms
Lesson not Started  Forms Explained
Lesson not Started  Forms & Design View
Lesson not Started  Creating Forms using the Wizard
Lesson not Started  Creating Forms using Design View
Lesson not Started  Creating Forms Automatically
Lesson not Started  Adding new Records to a Form
Lesson not Started  Saving Forms

Reports
Lesson not Started  Creating Reports using the Wizard
Lesson not Started  Creating Reports using Design View
Lesson not Started  Creating Reports Automatically
Lesson not Started  Print Preview
Lesson not Started  Printing Reports
Lesson not Started  Saving Reports