Migrating to Access 2007 (90 Minutes)

Overview

This 90-minute ExecuTrain Express course is designed for current Access users who are migrating to Access 2007. Class participants will learn how to take advantage of new tools and interface elements to speed up database creation and editing tasks. For example, creating new forms and reports becomes considerably easier in Access 2007 with two new WYSIWYG (“What You See Is What You Get”) design tools. Students should take this class, which focuses specifically on Access’s new features, after taking the Migrating to Office 2007 course.

Prerequisites

• Familiarity with a previous release of Microsoft Access, such as Access 2000 or Access 2003
• Successful completion of the Migrating to Office 2007 course

Objectives

• Utilize new interface elements to save time.
• Use new table and field features, and work with new data types.
• Create forms and reports using new interactive editors.

Outline

Exploring the Basics

• What’s New in Access 2007
• Creating a New Database
• Creating a Blank Database
• Creating a Database from a Template
• Upgrading an Existing Database
• Reviewing the New Access Interface

Working with Tables and Fields

• Creating a New Table
• Creating a Table in Datasheet View
• Creating a Table Using Table Templates
• Adding Fields to a Table
• Adding a Field in Datasheet View
• Adding a Field Using a Template
• Adding an Existing Field
• Modifying a Table
• Creating a Totals Row
• Using an Alternating Background Color
• Understanding the New Data Types
• Memo Data Type
• Date/Time Data Type




Working with Forms and Reports

• Creating Forms
• Working with Forms
• Understanding Control Layouts
• Adding Fields to a Form
• Formatting a Form
• Creating Reports
• Creating a Simple Report
• Grouping and Sorting Reports