Microsoft Access 2010 Intermediate Training

How To Take This Class:

Live Instructor-Led Online Class > View Schedule or Register
Onsite Group Training > Request Pricing

Instructor-Led Online Course Tuition:

$225.00

Course Duration:

1 Day

What Students Receive:

Each student will receive:

A printed courseware manual for use during and after class.
Access to a searchable, electronic version of the courseware manual for reference after class (available for 12 months after class.)
A PC headset for communicating with your instructor and fellow students during your Microsoft Access 2010 Training Class
A course completion certificate upon successful completion of your Microsoft Access 2010 Training course
Six months of post-class email support from a Microsoft Access Instructor

Course Description:

You have the basic skills needed to work with Microsoft Office Access™ 2010 databases, including creating and working with Access tables, relationships, queries, forms, and reports. But so far, you have been focusing only on essential database user skills. In this Microsoft Access 2010 Intermediate Training course, you will consider how to maintain data consistency, how to customize database components, and how to share Access data with other applications. This course provides provides training in Access to students who are looking to build on their basic Access skillset.

Course Objectives:

Upon completion of the course, students will be able to:

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

This Microsoft Access 2010 training 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 Prerequisites:

Completion of the Microsoft Access 2010 Introduction Training course, or equivalent experience.

Course Syllabus:

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

Joining Tables

Create Query Joins
Join Tables with No Common Fields
Relate Data Within a Table

Creating Flexible Queries

Set the Select Query Properties
Retrieve Records Based on Input Criteria
Create Action Queries

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

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

Sharing Data Across Applications

Import Data into Access
Export Data to Text File Formats
Export Access Data to Excel
Create a Mail Merge