Access 2007: Introduction

Course Specifications:

Courseware: Microsoft Office Access 2007: Level 1

Software: Access 2007

Course length: 1 day

Course Description:

In this course, you will examine basic database concepts and create and modify databases and their various objects using the Access 2007 relational database application.

Course Objective:

You will create and modify new databases and their various objects, as well as understand the advantages that using a relational database program can bring to business processes.

Target Student:

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, This 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.

Prerequisites:

To ensure the successful completion of Access 2007: Introduction, we recommend completion of the following MicroAssist courses, or equivalent knowledge from another source:

1. Windows 2002: Introduction

Delivery Method:

Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities. Each student is provided with a computer and a Manual. The manual is the student's to keep and makes an excellent reference guide.

Course Content

Lesson 1: Exploring the Microsoft Office Access2007 Environment

1. Topic 1A: Examine Database Concepts
2. Topic 1B: Explore the User Interface
3. Topic 1C: Use an Existing Access Database
4. Topic 1D: Customize the Access Environment
5. Topic 1E: Obtain Help

Lesson 2: Designing a Database

1. Topic 2A: Describe the Relational Database Design Process
2. Topic 2B: Define Database Purpose
3. Topic 2C: Review Existing Data
4. Topic 2D: Determine Fields
5. Topic 2E: Group Fields into Tables
6. Topic 2F: Normalize Data
7. Topic 2G: Designate Primary and Foreign Keys
8. Topic 2H: Determine Table Relationships

Lesson 3: Building a Database

1. Topic 3A: Create a New Database
2. Topic 3B: Create a Table
3. Topic 3C: Manage Tables
4. Topic 3D: Create a Table Relationship
5. Topic 3E: Save a Database as a Previous Version

Lesson 4: Managing Data in a Table

1. Topic 4A: Modify Table Data
2. Topic 4B: Sort Records
3. Topic 4C: Work with Subdatasheets

Lesson 5: Querying a Database

1. Topic 5A: Filter Records
2. Topic 5B: Create a Query
3. Topic 5C: Add Criteria to a Query
4. Topic 5D: Add a Calculated Field to a Query
5. Topic 5E: Perform Calculations on a Record Grouping

Lesson 6: Designing Forms

1. Topic 6A: View Data Using an Access Form
2. Topic 6B: Create a Form
3. Topic 6C: Modify the Design of a Form

Lesson 7: Generating Reports

1. Topic 7A: View an Access Report
2. Topic 7B: Create a Report
3. Topic 7C: Add a Custom Calculated Field to a Report
4. Topic 7D: Format the Controls in a Report
5. Topic 7E: Apply an AutoFormat Style to a Report
6. Topic 7F: Prepare a Report for Print