Microsoft Access Training | Chicago & Los Angeles

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 2003 - Level 3

  • Upcoming Classes
  • Course Outline
  • Instructors

Course Description

Most organizations maintain and manage large amounts of information. One of the most efficient and powerful methods for storing data is a relational database. In this course, you will cover advanced features of Microsoft Access 2003, such as building advanced forms, creating advanced reports and to automate operations using Macros.

Target Audience

This Microsoft Access course is primarily aimed at existing Access users who need to learn advanced Access features such as Macros, Advanced Forms and Advanced reporting including Forms. Students should have completed the Access Level 2 course or have equivalent experience prior to attending.

Access Training deals

Found out more about our Microsoft Access Training deals and our 100% Money Back Guarantee.

Learning Objectives

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


  • Restructure an existing set of Data to improve the design of a Database.
  • Use a variety of Techniques to summarize and present Data with queries.
  • Create and revise basic Access Macros.
  • Create Macros that improve Data entry efficiency and integrity.
  • Improve the effectiveness of Data entry in Forms.
  • Improve the effectiveness of data displayed in Reports.
  • Maintain an Access database by using various Utility tools.
 
 

Upcoming Classes

Chicago

Mar, 2010 Apr, 2010 May, 2010 Jun, 2010
Access 2003 - Level 3 Mar 5 ! Apr 22 May 26  

Click here for directions

Los Angeles

Mar, 2010 Apr, 2010 May, 2010 Jun, 2010
Access 2003 - Level 3 Mar 3 ! Apr 16 May 27  

Click here for directions

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

 

Course Outline

Structuring Existing Data

  • Import Data
  • Analyze Tables
  • Create a Junction Table
  • Improve Table Structure

Writing Advanced Queries

  • Create Unmatched and Duplicates Queries
  • Group and Summarize Records Using the Criteria Field
  • Summarize Data with a Crosstab Query
  • Create a PivotTable and a PivotChart
  • Display a Graphical Summary on a Form

Simplifying Tasks with Macros

  • Create a Macro
  • Attach a Macro to a Command Button
  • Restrict Records Using a Where Condition

Adding Interaction and Automation with Macros

  • Require Data Entry with a Macro
  • Display a Message Box with a Macro
  • Automate Data Entry

Making Forms More Effective

  • Change the Display of Data Conditionally
  • Display a Calendar on a Form
  • Organize Information with Tab Pages

Making Reports More Effective

  • Cancel Printing of a Blank Report
  • Include a Chart in a Report
  • Arrange Data in Columns
  • Create a Report Snapshot

Maintaining an Access Database

  • Link Tables to External Data Sources
  • Back Up a Database
  • Compact and Repair a Database
  • Protect a Database with a Password
  • Determine Object Dependency
  • Document a Database
  • Analyze the Performance of a Database
 
 

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
"Great Class, I will be back and I will be sending my staff also. Please send me a schedule for Rich."
John Habermeier - Synergy Builders
"Can't say enough good things about this course. Rich was on target with his explanations and really engaged our group. Honestly the best training class of have ever taken, hand down!"
Lupita Signorella - Baker & McKenzie LLP
"Just completed three day Access 2003 course. Great instructors, excellent materials. Will definitely refer Training Connection to colleagues and will stop here first for additional training in the future. Thanks!"
Maria I. Johnson - Harris N.A.
... view bioRich
 
Access Training Testimonial
"The Access series was exactly what I needed to take my skill-set to the next level. The instructor, George, was very knowledgeable and patient. He gave us lots of tips not included in the book. What I learned in 3 days is going to save me hours every day. I'm going to look like a Super Genious when I get back to work tomorrow. I will definitely come back. Thanks Training Connection!"
Miho Hamashima - SchoolsFirst FCU
Access Training Testimonial
"I had never taken any Access training before and took Access Levels 1, 2, and 3. I knew what I expected to see and knew what I wanted to see, but I feel I got the best of both worlds! George is very knowledgeable in this field and showed us things that were not even in the training materials. These are powerful things that I can actually use back at the office. I am glad I found Training Connection on the web and will definitely look for more courses to take here. Thank you.
Karen T Heynen - Healthnet, Inc
Access Training Testimonial
"Just completed three day Access 2003 course. Great instructors, excellent materials. Will definitely refer Training Connection to colleagues and will stop here first for additional training in the future. Thanks!"
Maria I. Johnson - Harris N.A.
Access Training Testimonial
"Great Class, I will be back and I will be sending my staff also. Please send me a schedule for Rich."
John Habermeier - Synergy Builders
# # # # # # # # # # # # # # # # # #
Computer and Business Skills Training

Adobe Training

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

Web Development

AJAX Training
CSS Training
HTML Training
JavaScript Training
PHP MySQL 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