Microsoft Office Access 2010 Training

"Great instruction!  Made the course extremely easy to understand.  Very thorough."

-Debbie Ramkissoon, Randstad

Get your Training Quote

• Feb 10 - Feb 10, 2012
• Mar 16 - Mar 16, 2012
• Apr 23 - Apr 23, 2012
• May 21 - May 21, 2012
• Jun 18 - Jun 18, 2012
• Aug 27 - Aug 27, 2012

Can't travel or you want to stay with your family or business. No problem! Stay in your own city and save the additional expenses of roundtrip airfare, lodging, transportation, and meals and receive the same great instruction live from our instructors in our Live Instructor-Led Remote Classroom Training.

Remote Classroom Training

Our Remote Classroom Training is a live class with students observing the instructor and listening through your computer speakers. You will see the instructor's computer, slides, notes, etc., just like in the classroom. You will be following along, doing work, labs, and individual assignments.

This course is designed for individuals who wish to learn to work with 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.

Upon successful completion of this 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.
• improve forms.
• customize reports to organize the displayed information and produce 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

CED Solutions is your best choice for Access 2010 , Access 2010 training, Access 2010 certification, Access 2010 boot camp, Access 2010 certification training, Access 2010 certification course, Access 2010 course, Access 2010 class.