Microsoft® Access 2010 Level I

Length: 1 days
Prerequisites: Familiarity with the Windows operating system.
Course Level:  Introductory through intermediate topics

This course includes a Blended Learning  Bonus Pack.  In addition to the instructor-led course and book, participants will also receive the following bonus on-line materials for 12 months at no additional charge:

  • Microsoft Office Access 2010 Knowledge Assessment
  • Microsoft Office Access 2010 Interactive Resources (CBT for instructor-led course)
  • Microsoft Office Access 2010 e-Book Student
  • Using Data to Communicate (Includes Simulation) Interactive Resources 

Course Description:  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 who want to use the application to be more productive in their work. It provides the fundamental knowledge and techniques needed to use more complex Access features such as maintaining databases and using programming techniques that enhance Access applications.

 Course Objectives:

  • identify the basic components of an Access database.

  • build the structure of a database.

  • manage data in tables.

  • query a database.

  • design forms.

  • generate reports.

Course Content:

Lesson 1: Getting Started with Access Databases

Identify the Elements of the Access 2010 Interface

Identify the Components of a Database

Examine the Relational Database Design Process

 

Lesson 2: Building the Structure of a Database

Create a New Database

Create a Table Using the Design View

Manage Tables

Establish Table Relationships

 

Lesson 3: Managing Data in a Table

Modify Table Data

Sort and Filter Records

Work with Subdatasheets

 

Lesson 4: Querying a Database

Create a Query

Add Criteria to a Query

Add a Calculated Field to a Query

Perform Calculations on a Record Grouping

 

Lesson 5: Designing Forms

Create a Form

Modify the Design of a Form

View and Edit Data Using an Access Form

 

Lesson 6: Generating Reports

Create a Report

Add a Control to a Report

Format the Controls in a Report

Enhance the Appearance of a Report

Prepare a Report for Print