Microsoft Office Access 2010: Level 2 Training

We offer private customized training for groups of 3 or more attendees.

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
Gain insight and ideas from students with different perspectives and experiences.

Interesting Reads Take a class with us and receive a book of your choosing for 50% off MSRP.