1 Day Course

Performance-based objectives

• 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.

Prerequisites

This course is designed for students who wish to learn the basic operations of the Access 2003 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 I course is for the individual whose job responsibilities include working with tables to create and maintain records, locate records, and produce reports based on the information in the database. It also provides the fundamental knowledge and techniques needed to advance to more technical Access responsibilities, such as creating and maintaining new databases and using programming techniques that enhance Access applications. To ensure the successful completion of Microsoft Office Access 2003 I, we recommend a working knowledge of the Windows Operating System.

Course Content

Lesson 1: Exploring the Access Environment

• 1A: Examine Database Concepts
• 1B: Explore the User Interface
• 1C: Explore the Ribbon
• 1D: Customize the Access Environment
• 1E: Obtain Help
• 1F: Use an Existing Access Database

Lesson 2: Designing a Database

• 2A: Describe the Relational Database Design Process
• 2B: Define Database Purpose
• 2C: Review Existing Data
• 2D: Determine Fields
• 2E: Group Fields into Tables
• 2F: Normalize Data
• 2G: Designate Primary and Foreign Keys
• 2H: Determine Table Relationships

Lesson 3: Building a Database

• 3A: Create a New Database
• 3B: Create a Table
• 3C: Manage Tables
• 3D: Create a Table Relationship

Lesson 4: Managing Data in a Table

• 4A: Modify Table Data
• 4B: Sort Records
• 4C: Work with Subdatasheets

Lesson 5: Querying a Database

• 5A: Filter Records
• 5B: Create a Query
• 5C: Add Criteria to a Query
• 5D: Add a Calculated Field to a Query
• 5E: Perform Calculations on a Record Grouping

Lesson 6: Designing Forms

• 6A: View Data Using an Access Form
• 6B: Create a Form
• 6C: Create a Form Using the Form Wizard
• 6D: Modify the Design of a Form

Lesson 7: Generating Reports

• 7A: View an Access Report
• 7B: Create a Report
• 7C: Create a Report Using the Report Wizard
• 7D: Add a Custom Calculated Field to a Report
• 7E: Format the Controls in a Report
• 7F: Apply an AutoFormat to a Report
• 7G: Prepare a Report for Print

For Information Contact
Rhuann Heimann 618-523-4893
This e-mail address is being protected from spambots. You need JavaScript enabled to view it
www.trainatacumen.com