| Course | Access 2010: Intermediate [WDRS0124/CR/01] |
|---|---|
| Prerequisites | Windows: Introduction and Access: Introduction or equivalent knowledge. |
| Prerequisit Course | |
| Requal. Interval | One Time Only |
| Contact | Nicole M Gee |
| Reference Material | |
| Target Audience | Individuals responsible for creating new databases, the designing of tables and relationships, intermediate level queries, forms, reports, and data access pages. |
| Objective | Modify the design and field properties of a table to streamline data entry and maintain data integrity. Create a list of values for a field. Create query joins, join unrelated tables, relate data within a table. Set select query properties, create parameter and action queries. Design a form layout and enhance the appearance of a form. Restrict data entry in forms, add a command button to a form and create a subform. Organize report information, format the report and set report control properties. Control report pagination, summarize report information and add a subreport to an existing report. Import and export data. Analyze Access data in Excel. Export data to a text file. Merge Access data with a Word Document. |
| Course Content | * Controlling Data Entry * Joining Tables * Creating Flexible Queries * Improving Your Forms * Customizing Reports * Sharing Data Across Applications |
| 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. |