TRAIN Online Class Schedule
Course Access 2010: Advanced[WDRS0125/CR/01]
Prerequisites Windows: Introduction and Access: Introduction & Intermediate or equivalent knowledge.
Requal. Interval One Time Only
Contact Barbara Brooks
Authorized Instructors Barbara Brooks (WR)
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
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.