Microsoft® Access 2010 Level II

Length: 1 day
Prerequisites: Microsoft Access 2010 Level I or equivalent knowledge
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 Level II Knowledge Assessment
  • Microsoft Office Access 2010 Level II Self-Paced Tutorial
  • Microsoft Office Access 2010 Level II e-Book
  • Managing Information Effectively (Includes Simulation) Interactive Resources

Course Description:  This course is designed for individuals who wish to learn intermediate-level operations of the Microsoft® Office Access® program. The target student may also include individuals whose job responsibilities include creating databases, tables, and relationships, as well as working with and revising intermediate-level queries, forms, and reports. It also introduces them to integrating Access data with other applications such as Microsoft Office Word or Excel.


 Course Objectives:

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

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