MA2007-1 - Microsoft Access 2007: Introduction
This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports.
Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Basic, Intermediate, and Advanced.
Getting started
Database concepts
Exploring the Access environment
Getting help
Databases and tables
Planning and designing databases
Exploring tables
Creating tables
Fields and records
Changing the design of a table
Finding and editing records
Organizing records
Data entry rules
Setting field properties
Working with input masks
Setting validation rules
Basic queries
Creating and using queries
Modifying query results and queries
Performing operations in queries
Using forms
Creating forms
Using Design view
Sorting and filtering records
Working with reports
Reports
Modifying and printing reports