|Course||Access 2013: Level 2/Intermediate[WDRS0173/CR/01]|
|Prerequisites||Windows: Level 1 and Access: Level 1|
|Requal. Interval||One Time Only|
|Target Audience||Individuals responsible for creating new databases, the designing of tables and relationships, intermediate level queries, forms, reports, and data access pages|
|Objective||Upon successful completion of this one day course you will be able to: 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||- Successfully analyze table design problems and normalize tables using directions from the Instructor.
- Efficiently design select queries as directed in the Lesson Lab.
- Choose the appropriate features and apply them to customize forms with 100% accuracy.
- Using the information from the exercises, correctly import and export data.
Students will learn how to create and work with Access tables, relationships, queries, forms, and reports.
- Controlling Data Entry
- Joining Tables
- Creating Flexible Queries
- Improving Your Forms
- Customizing Reports
- Sharing Data Across Applications