Access Training | Chicago

Fast Facts

Duration
1 day

Class Size
Max 8 students

Times
9.00am to 4.30pm

Computer
One per student

Training Manual
Included

Price
295.00

Access 2007 - Level 2

Upcoming Classes
Course Outline
Instructors

Course Description

On this 1 day Access course you will consider 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.

Leaning 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.

Upcoming Classes

Chicago	Aug, 2008	Sep, 2008	Oct, 2008	Nov, 2008
Access 2007 - Level 2		Sep 4	Oct 7	Nov 20

Click here for directions

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

Meet the Instructors

Rich

Rich has been creating custom software programs, and delivering tailored training classes for the past 13 years. His passion for instruction and his pursuit of all things technical, combine with his outgoing personality to provide an engaging and enthusiastic exchange of knowledge and ideas with his trainees. Software training for Rich is a labor of love. As he puts it, "When you love what you do, it's really not work after all!"

CLOSE BIO

"Rich did a good job of providing instruction and examples that were a good fit for our level of understanding of Access."

Matthew Mueller - First Amerian Bank

"First off Rich had a great attitude and was an all around cool guy. It made the course much more comfortable and a lot more fun. I was very impressed with his take on the whole two day course. The impromptu discussions we had were enjoyable and informative. I appreciated that he was positive about talking off subject. I'd definitely enjoy taking other courses taught by him. A would buy from again, ha."

Eric Miner - Robinson Steel

"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

... view bioRich

Adobe Training

Web Development

Microsoft Office

Business Skills

QuickBooks