Microsoft Office Access 2007 Level 1

Course objectives:
In this course you will create and modify new databases and their various objects, examine the basic database concepts, and create and modify databases and their various objects using the Microsoft® Office Access 2007 relational database application. This course is designed for students who wish to learn the basic operations of the Microsoft Access Database program to perform their day-to-day responsibilities, and to understand the advantages that using a relational database program can bring to their business processes. The Level 1 course is for the individual 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. It also provides the fundamental knowledge and techniques needed to advance to more complex Access responsibilities such as maintaining databases and using programming techniques that enhance Access applications.

Upon successful completion of this course, students will be able to:

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 the data in a table.

query a database using different methods.

design forms.

generate reports.


Course content:
Exploring the Access Environment

Examine Database Concepts

Explore the User Interface

Explore the Ribbon

Customize the Access Environment

Obtain Help

Use an Existing Access Database
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
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

Create a Form Using the Form Wizard

Modify the Design of a Form
Generating Reports

View an Access Report

Create a Report

Create a Report Using the Report Wizard

Add a Custom Calculated Field to a Report

Format the Controls in a Report

Apply an AutoFormat to a Report

Prepare a Report for Print
Appendix A: Microsoft Office Specialist Program