TRAIN Online Class Schedule
Course Access 2010: Advanced [WDRS0125/CR/01]
Prerequisites Windows: Introduction and Access: Introduction & Intermediate or equivalent knowledge.
Prerequisite Course
Requal. Interval One Time Only
Contact Barbara Brooks
Authorized Instructors Barbara Brooks(WR)  
Reference Material
Target Audience Those with responsibilities such as working with heavily related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance.
Objective Analyze tables, create a junction table, and improve table structure. Create subqueries, create unmatched and duplicate queries, group and summarize records using criteria, summarize data using a crosstab query, and create a PivotTable and a PivotChart. Create and attach a Macro, restrict records using a condition, validate data using a Macro, and automate data entry using a Macro. Display a calendar on a form, organize information with Tab pages and display a summary of data in a Form. Include a chart in a report, print data in columns, and create a report snapshot. Link tables to external data sources, determine object dependency, document a database and analyze the performance of a database.
Course Content * Structuring Existing Data
* Writing Advanced Queries
* Simplifying Tasks with Macros
* Making Effective Use of Forms
* Maintaining an Access Database
Course Content
Instructor's Comments If you withdraw from the class 10 business days or fewer before it begins and do not find a replacement, you will be charged the full fee.

Invalid Fermi ID: 00000X

Fermi ID Employee   Visitor   Contractor   Other -- Fermilab Phone Book
  This course has a fee. Select the project and task to use when the class is booked.
Project:
Task
Note: The task code popup above requires a recent version of JavaScript. If no tasks appear when you select a project code please use a newer browser. If one is not available please contact the ServiceDesk for assistance. If you return to this page please re-select your project code to re-populate the task code popup.
Waiting List Option Add me to any class that becomes available.
Do you wish to be added to the waiting list? When a class is created or an opening becomes available, persons on the waiting list are automatically enrolled. An email notification will be sent at that time.