Access 2007 Basic Study Guide

1-4239-1801-0 © 2008 Publish date: March 22, 2007 208 pages

Buy Now: $25.99

Course ID: access-2007-basic-sg

The Access 2007 Basic study guide is highly-rated having earned an overall quality rating from ProCert Labs of 4.9 out of 5.0.

By choosing this self-directed course, you will learn the basics of using Access 2007 for designing and creating databases. You'll get quality instruction covering the basics including working with tables, records, and fields, sorting and filtering data, and creating forms, queries, and reports.

The Microsoft Access training courseware has been designated as Microsoft-approved courseware for the Microsoft Certified Application Specialist program. If you are preparing for the Access 2007 exam (70-605), this guide is the perfect first step. In order to gain comprehensive certification training, make sure to choose this manual along with our intermediate and advanced computer training books covering Access 2007.

Learning the basics will prepare you for the more advanced features covered in the intermediate and advanced study guides. You'll be able to complete the Access 2007 Basic courseware in as little as one day of focused studies. Because this is a self-directed course, you can learn according to your own schedule or learning style. This manual allows you to work at your own pace without the need of attending classes or take time off of work to advance your skills.

Course Objectives

By choosing this course, you will learn how to use a database management system to organize data efficiently, work with Access databases, use the Help features, plan and create your databases, use various views including Datasheet view and Design view, and work with tables. You will also learn about finding and replacing data, sorting, filtering, and deleting records, setting field properties, creating input masks, and setting validation rules.

Other topics include creating and modifying queries, working with forms, and creating, modifying and printing reports.

Course Contents

Unit 1 introduces Access and database concepts

• Database concepts
• Exploring Access's environment
• How to get help

Unit 2 covers databases and tables

• How to plan and design databases
• A look at tables
• How to create tables

Unit 3 goes over fields and records

• Modifying the design of a table
• How to find and edit records
• How to organize records

Unit 4 covers data entry rules

• How to set field properties
• Using input masks
• Setting validation rules

Unit 5 goes over basic queries

• How to create and use queries
• How to modify query results and queries
• How to perform operations in queries

Unit 6 covers forms

• Creating forms
• Using the Design view
• Sorting and filtering records with forms

Unit 7 discusses reports

• Reports
• How to modify and print reports