Microsoft Access 2007 Introduction

This course is designed for students who wish to learn the basic operations of the Microsoft Access database application to perform their day-to-day responsibilities, and to understand the advantages that using a relational database application can bring to their business processes.
Anyone whose job responsibilities include designing and creating new databases, tables, and relationships; creating and maintaining records; locating records; and producing reports based on the information in the database. Individuals who want to pursue Microsoft Certified Application Specialist certification in Microsoft Office Access 2007 can also take this course.

Skills Gained
* Examine the basic database concepts and explore the Microsoft Office Access 2007 environment.
* Design a simple database.
* Build a new database with related tables.
* Manage data in a table.
* Query a database using different methods.
* Design forms.
* Generate reports.

Delegates will be able to create a database and manage data more effectively. They will be able to design and create new databases, tables, and relationships; create and maintain records; locate records; and produce reports based on the information in the database. Delegates will also be shown the basic concepts of relational database theory.

This Level 1 course is designed for students who wish to learn the basic operations of the Microsoft Access database application to perform their day-to-day responsibilities, and to understand the advantages that using a relational database application can bring to their business processes.

Course Content
Exploring the Microsoft Access 2007 Environment
Examine Database Concepts. Explore the User Interface. Use an Existing Access Database. Customize the Access Environment. Obtain Help.

Designing a Database
Describe the Relational Database Design Process. Define Database Purpose. Review Existing Data. Determine Fields. Group Fields into Tables. Normalize Data. Designate Primary and Foreign Keys. Determine Table Relationships.

Building a Database
Create a New Database. Create a Table. Manage Tables. Create a Table Relationship. Save a Database as a Previous Version.

Managing Data in a Table
Modify Table Data. Sort Records. Work with Subdatasheets.

Querying a Database
Filter Records. Create a Query. Add Criteria to a Query. Add a Calculated Field to a Query. Perform Calculations on a Record Grouping.

Designing Forms
View Data Using an Access Form. Create a Form. Modify the Design of a Form.

Generating Reports

View an Access Report. Create a Report. Add a Custom Calculated Field to a Report. Format the Controls in a Report. Apply an AutoFormat Style to a Report. Prepare a Report for Print.