...
Access Training logoAccess Training Class



We offer a 1-day beginner, 1-day intermediate and a 1-day advanced training class in Access.

We currently offer public Access training classes in many cities around the country. Please click on the schedule link to your right to see a complete list of our Access classes.

You can register for these classes by clicking on the link at the top of this page or by clicking on the date of the class you wish to attend.

One on OneWould you prefer to take a private Access course at the same cost, with one of our certified instructors on dates suited to your schedule? Click here for more information.

We also offer custom Access training classes and consulting which can be tailored and targeted specifically to you and your staff. These classes can be held at many training centers or on-site at your location anywhere in the USA. We also provide Access live online training classes in a virtual classroom. Our Access training and support team have over 10 years experience developing and teaching Microsoft applications.
Please contact training@americanmediatraining.com if you would like more information on our Access custom training classes.

Access Logo   Access Beginner Class


Businesses, organizations and individuals worldwide use the Microsoft Access database management system to track multiple, inter-related sets of data, organize the data in tables, and generate reports to analyze the data. This Access 2007/2010 Fundamentals class will teach you to use the core data management features of Access 2007/2010 in order to make faster and more effective business decisions. Access Fundamentals will prepare you to design an Access database which is best suited to your business needs, streamline the process of entering new information by creating user-friendly data entry forms, and query the data to derive meaningful answers to critical business questions. This course draws heavily on real-world examples which will give you exposure to the complex database management problems Access users face, and will equip you to make the best use of Access 2007/2010 right away. Microsoft Access classes have been designed to help you develop proficiency with both Access 2007 as well as Access 2010.

View Outline...

Microsoft Access Course outline

Getting Started with Access 2007/2010

  • Navigate using the Navigation Pane and the Access Ribbon toolbar.
  • Understand Access terminology for databases, tables, records, and fields.
  • Identify the uses of various objects in Access such as a Query or a Macro.

 

Designing the Database

  • Design tables best suited to the purpose of your database.
  • Implement consistent and logical naming conventions to make your database easier for others to use.
  • Harness existing templates to avoid unnecessary duplication of effort.

 

Entering Data and Managing Records

  • Use database table fields to quickly find and edit records.
  • Add captions to provide additional information useful for data entry.
  • Create validation rules and input masks for searchable and accurate records.
  • Employ "wildcards" to generate meaningful results on even the most difficult searches.

 

Using Queries Effectively

  • Retrieve and display a set of database records based on any number of criteria.
  • Use the Query Wizard for faster, easier query creation, or code powerful queries using Structured Query Language.
  • Refine the set of results by modifying, saving or restoring previous queries.
  • Perform global updates and calculations on query results.

 

Generating Meaningful Reports

  • Build custom reports which communicate the data and support business decision making.
  • Modify a report's design while viewing the data for optimal visual effect.
  • Preview a report and modify the page layout as needed for printing.

 

Our outlines are a guide to the content covered on a typical course. We may change or alter the course topics to meet the objectives of a particular course.


Access Logo   Access Intermediate Class


Microsoft Access is a powerful data management tool in which one can consolidate and track various types of inter-related information, and generate reports to analyze the data in order to make better business decisions. Access 2007/2010 Intermediate class will take you beyond the basics, giving you experience with Access's more advanced capabilities. Upon completing this course, you will be thoroughly versed in the precepts of data normalization and effective database design, so that you can quickly author sophisticated queries to seek exactly the necessary data to answer complex business problems. Students will also learn to create forms which are well-suited to the users' perspectives and needs, and create charts and graphs which express the data with visual impact and clarity. Our instructors will share their broad base of Access experience, in order to help you attain the practical knowledge and skills necessary to put the advanced functionality of this data management system to work for you. Microsoft Access classes have been designed to help you develop proficiency with both Access 2007 as well as Access 2010.

View Outline...

Microsoft Access Course outline

Designing the Database to Meet Business Requirements

  • Organize data efficiently and eliminate redundant data for improved database performance.
  • Create logical relationships between tables and fields, and maintain those relationships with referential integrity.
  • Understand database normalization and the various normal forms

 

Enhancing Database Tables with Advanced Techniques

  • Quickly view information from several tables using subdatasheets.
  • Create and modify a lookup column to more efficiently display information from separate list of values or from another table.

 

Performing Complex Queries for Sophisticated Results

  • Perform inner, outer and self-joins to link unrelated data tables.
  • Save and reuse queries you use regularly.
  • Use calculated fields to display the results of a mathematical or logical expression.

 

Designing Access Forms to Meet Users' Expectations

  • Aid the user with visual cues, such as shapes and borders which group related controls.
  • Use graphics effectively to draw the users' attention toward relevant portions of the form.
  • Embed documents and spreadsheets in Access forms, to provide supplemental information when the user needs it most.
  • Use form controls and menus effectively for data validation, to assist the user in entering appropriate data.

 

Displaying Data Powerfully with Charts, Graphs, and PivotTools

  • Highlight important features in charts by including graphic elements.
  • Use the exhaustive set of Access chart and graph properties to draw attention to critical data.
  • Configure PivotTables and PivotCharts to view data within a datasheet or form.

 

Our outlines are a guide to the content covered on a typical course. We may change or alter the course topics to meet the objectives of a particular course.


Access Logo   Access Advanced Class


This course, builds on the skills and concepts taught in Access 2007/2010: Intermediate. Students will learn how to query with SQL; create crosstab, parameter, and action queries; create macros; import, export, and link database objects; work with XML documents; work with Windows SharePoint Services; optimize databases; password-protect and encrypt databases; set Access options and properties; create hyperlink fields; and use Microsoft Outlook to update data. Microsoft Access classes have been designed to help you develop proficiency with both Access 2007 as well as Access 2010.

View Outline...

 

Querying with SQL

  • SQL and Access
  • Writing SQL statements
  • Attaching SQL queries to controls

 

Advanced queries

  • Creating crosstab queries
  • Creating parameter queries
  • Using action queries

 

Macros

  • Creating, running, and modifying macros
  • Attaching macros to the events of database objects

 

Advanced macros

  • Creating macros to provide user interaction
  • Creating macros that require user input
  • Creating the AutoKeys and AutoExec macros
  • Creating macros for data transfer

 

Importing, exporting, and linking

  • Importing and Exporting objects
  • Interacting with XML documents
  • Linking Access objects
  • Working with Windows SharePoint Services

 

Database management

  • Optimizing resources
  • Protecting databases
  • Setting options and properties

 

Internet integration

  • Hyperlink fields
  • Working with Outlook 2007 and Outlook 2010

 

Our outlines are a guide to the content covered on a typical course. We may change or alter the course topics to meet the objectives of a particular course.

Microsoft Certified Expert Microsoft Certified Instructor
Access LogoAccess Level 1 training courses
Upcoming classes - full schedule
Date City Cost Days
11/21/2024 Chicago $350
1

Classes are run over  consecutive days unless otherwise specified. Class times are 9am - 4pm unless otherwise stated.

 

 

 

 

 

Access training courses offered all cities

Course Start Date Duration Cost Register
Access level 1 beginner course Training Courses in Chicago 11/21/2024 1 days $350 Register

We can offer you customized on-site training courses in Access wherever you are in the USA:

Atlanta, Chicago, Los Angeles, Denver, Miami, Philadelphia, Orlando, Charlotte, Houston, Richmond, Washington DC, New York, Boston, Columbus, Cincinnati, Memphis, Indianapolis, Baltimore, Dallas, Austin, Phoenix, Albuquerque, Las Vegas, Salt Lake City, Seattle, Portland, San Francisco, San Diego, Long Beach, Sacramento, St Paul/Minneapolis

We also provide Access training courses in the following cities:

Access training courses in Los Angeles
Access training courses in Denver
Access training courses in Minneapolis
Access training courses in San Francisco
Access training courses in Phoenix
Access training courses in Boston
Access training courses in Salt Lake City
Access training courses in Philadelphia
Access training courses in Miami
Access training courses in Portland
Access training courses in Chicago
Access training courses in New York
Access training courses in Dallas
Access training courses in Houston
Access training courses in San Diego
Access training courses in Kansas
Access training courses in Cleveland

Our Contact:
AMT Centers, 11500 W. Olympic Blvd. Suite 400, Los Angeles, CA 90064 Tel: 1 800 278 7876