Microsoft Office Access 2007 Brief

Linda O'Leary offered her expertise at Arizona State University for several years as an academic advisor. She also presented and developed materials for major corporations, such as Motorola, Intel, Honeywell, and AT&T, as well as various community colleges in the Phoenix area.

Introduction to Microsoft Office 2007Office Access 2007 Overview of Microsoft Office Access 2007Lab 1: Creating a DatabaseDesigning a New Database
Creating and Naming the Database File
Using Datasheet View
Using Design View
Entering and Editing Data
Changing Column Width
Deleting Records
Creating a Second Table
Previewing and Printing a Table
Closing and Opening a Table and Database
Exiting Access
Focus on CareersLab 2: Modifying and Filtering a Table and Creating a Form
Navigating a Large Table
Customizing and Inserting Fields
Hiding and Redisplaying Fields
Creating a Lookup Field
Finding and Replacing Data
Sorting Records
Formatting the Datasheet
Filtering a Table
Creating and Using Forms
Organizing the Navigation Pane
Previewing and Printing a Form
Identifying Object Dependencies
Setting Database and Object Properties
Focus on CareersLab 3: Querying Tables and Creating Reports
Refining the Database Design
Defining and Modifying Relationships
Creating a Filter
Querying a Database
Displaying a Totals Row
Creating Reports
Preparing Records for Printing
Compacting and Backing Up the Database
Focus on CareersWorking Together 1: Exporting Data
Case Study
Exporting DataAccess 2007 Command SummaryGlossary of Key TermsAppendix Reference 1Reference 2Index