Microsoft Office Access 2007 Brief / Edition 1

Microsoft Office Access 2007 Brief / Edition 1

by Linda O'Leary, Linda I. O'Leary

ISBN-10: 0073294543

ISBN-13: 9780073294544

Pub. Date: 06/29/2007

Publisher: McGraw-Hill Higher Education

Product Details

McGraw-Hill Higher Education
Publication date:
O'Leary Series
Edition description:
New Edition
Product dimensions:
8.50(w) x 10.90(h) x 0.59(d)

Table of Contents

Introduction to Microsoft Office 2007

Office Access 2007

Overview of Microsoft Office Access 2007

Lab 1: Creating a Database

Designing 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 Careers
Lab 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 Careers
Lab 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 Careers
Working Together 1: Exporting Data

Case Study
• Exporting Data

Access 2007 Command Summary

Glossary of Key Terms


Reference 1

Reference 2


Customer Reviews

Average Review:

Write a Review

and post it to your social network


Most Helpful Customer Reviews

See all customer reviews >