Microsoft Office Access 2010: Level 2 Training

Answers to Popular Questions:

 
Yes, this class can be tailored to meet your specific training needs.
Yes, we provide Microsoft Office consulting services.
Yes, group discounts are provided.

Course Description

 
You will improve and customize tables, queries, forms and reports, and share Access data with other applications.
Course Length: 1 Days
Course Tuition: $250 (US)

Prerequisites

To ensure your success, we recommend that you first take Microsoft Office Access 2010 : Level 1, or have equivalent knowledge and skills.

Course Outline

 


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

Course Directory [training on all levels]

Upcoming Classes