Microsoft Certified Application Specialist (MCAS)

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 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. The Level I 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. Students should have 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 more information on Acumen Classes
Please contact Deb Wagnon 314.333.3330
or This e-mail address is being protected from spambots. You need JavaScript enabled to view it

1750 South Brentwood Blvd.
Suite 200
Saint Louis, MO 63119