Microsoft® Access 2010 Crash Course:  Learn Access in Two Days!

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

Course Description:  This course combines Levels I and II for those participants who need to go beyond the basics and get started with a current or upcoming database project. 

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.

• Streamline data entry and maintain data integrity

• join tables to retrieve data from unrelated tables

• create flexible queries to display specified records, allow for user-determined query criteria, and modify data using queries.

• improve forms.

• customize reports to organize the displayed information and produce specific print layouts.

• share data between Access and other applications

Course Content: 

DAY ONE
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

DAY TWO

Lesson 1: Controlling Data Entry

Constrain Data Entry Using Field Properties

Establish Data Entry Formats for Entering Field Values

Create a List of Values for a Field

Lesson 2: Joining Tables

Create Query Joins

Join Tables with No Common Fields

Relate Data Within a Table

Lesson 3: Creating Flexible Queries

Set the Select Query Properties

Retrieve Records Based on Input Criteria

Create Action Queries

Lesson 4: Improving Forms

Restrict Data Entry in Forms

Organize Information with Tab Pages

Add a Command Button to a Form

Create a Subform

Display a Summary of Data in a Form

Change the Display of Data Conditionally

Lesson 5: Customizing Reports

Organize Report Information

Format Reports

Control Report Pagination

Summarize Report Information

Add a Subreport to an Existing Report

Create a Mailing Label Report

Lesson 6: Sharing Data Across Applications

Import Data into Access

Export Data to Text File Formats

Export Access Data to Excel

Create a Mail Merge