Access Level 2 Training

Microsoft Access 2007/2010 Level 2

Class timetable | Course outline

Course Description

On this Access class you will learn how to maintain data consistency, how to customize database components, and how to share Access data with other applications. 

Target Audience

This Access course is primarily aimed at people who need to know how to work with data in existing databases. Students should have completed the Access Level 1 course or have a basic knowledge of Microsoft Access, especially building a database file and data tables.

Access Level 2 Class facts
Money Back Guarantee

For added peace of mind, Training Connection’s Microsoft Access training comes with a 100% Money Back Guarantee.
If by lunchtime you don't feel that the program is for you, then you can leave the course at this point and receive a full refund of your course fees.

Access Level 2 Class Timetable

Chicago Feb 28 ! Register
Los Angeles Mar 6 ! Register
Chicago Mar 29 Register
Los Angeles Apr 19 Register
Chicago May 1 Register
Chicago May 31 Register
Los Angeles Jun 5 Register
Chicago Jul 3 Register

*  Class almost full    !  Class guaranteed to run    †  Class is full

Book Access Level 2 Training
 

Learning Objectives

Upon successful completion of this Access training course students will be able to:

  • Modify the Design and Field properties of a Table to Streamline Data Entry and Maintain Data Integrity.
  • Retrieve Data from Tables using Joins.
  • Create Flexible Queries to Display Specified Records, allow for User-Determined Query Criteria, and modify Data using Queries.
  • Enhance the Capabilities of a Form.
  • Customize Reports to Organize the Displayed Information and Produce Specific Print Layouts.
Detailed Course Outline

Controlling Data Entry

  • Restrict Data Entry Using Field Properties
  • Establish a Pattern for Entering Field Values
  • Create a List of Values for a Field

Joining Tables

  • Create Query Joins
  • Join Unrelated Tables
  • Relate Data Within a Table

Creating Flexible Queries

  • Set Select Query Properties
  • Create Parameter Queries
  • Create Action Queries

Improving Forms

  • Design a Form Layout
  • Enhance the Appearance of a Form
  • Restrict Data Entry in Forms
  • Add a Command Button to a Form
  • Create a Subform

Customizing Reports

  • Organize Report Information
  • Format the Report
  • Set Report Control Properties
  • 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
  • Analyze Access Data in Excel
  • Export Data to a Text File
  • Merge Access Data with a Word Document
Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.
 

What's included

Microsoft Access Training Manual
Certificate of Course Completion
6 Months FREE Repeat Policy
2 AMC Movie Vouchers

Related Courses

Access Level 1 course Access Level 1
Access Level 3 course Access Level 3
Access VBA training Access VBA

Register for Access Training
Access Training Testimonial
"I really enjoyed the instructor, Rich. His hands-on teaching style is very efficient to helping understand the concepts. He was very friendly with the audience and encourage class participation. He was open to your questions and was very helpful to applying what we learn in class to our daily work experience."
Stacy Chears - BMO Capital Markets
Access Training Testimonial
"It was very helpful that I was able to provide personal examples and the instructor used those examples to help me better understand Access. Relating to current work situations is always more effective learning that textbook, and by being able to use these examples, I think, really helped my understanding."
Carl Saxton - Feeding America
Access Training Testimonial
"The instructor, George, went to great lengths to personalize the class for me and my classmate. I was able to ask specific questions about my troubleshooting and got the answers to my questions, as well as an explanation to the larger, overall picture. This class helped me understand Access language as well as how to tackle specific problems. I enjoyed the class very much and would like to come back!"
Rose Reid - Individual
Access Training Testimonial
"George is an unique teacher whose knowledge in Access is unfathomable. He is very patient and his teaching technique is great. I learned a whole lot in this class and will be able to use it at work. I sincerely thank George, and also the training center for having a great teacher. I look forward to taking some more classes!"
Anonymous -
# # # # # # # # # # # # # # # # # #
Computer and Business Skills Training

Adobe Training

Acrobat Training
After Effects Training
Captivate Training
Dreamweaver Training
Flash Training
Flash Builder Training
Illustrator Training
InDesign Training
Photoshop Training
Premiere Pro Training

Web Development

AJAX Training
CSS Training
HTML Training
JavaScript Training
jQuery Training
PHP MySQL Training
WordPress Training

Microsoft Office

Access Training
Excel Training
Outlook Training
PowerPoint Training
Project Training
Visio Training
Word Training

Business Skills

Business Communication
Business Etiquette Training
Business Writing Class
Customer Service Training
Project Management Training
Time Management Training

QuickBooks

QuickBooks Training
 
 
  • HOME
  • TRAINING
  • TIMETABLE
  • ONSITE TRAINING
  • ROOM HIRE
  • ABOUT US
  • CONTACT US

  • SITE MAP
  • TERMS
  • COPYRIGHT 2007 - 2009