| Course | Access 2010: Advanced [WDRS0125/CR/01] |
|---|---|
| Prerequisites | Windows: Introduction and Access: Introduction & Intermediate or equivalent knowledge. |
| Prerequisit Course | |
| Requal. Interval | One Time Only |
| Contact | Nicole M Gee |
| 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. |