Microsoft Access 2007: Intermediate |
|
|
|
Overview: |
This two-day intermediate workshop builds upon basic database concepts and offers training in the development of multiple database relationships. Advanced properties of forms, reports and queries are presented. Additionally, creating and modifying charts, creating filters, joining tables in queries, working with input masks, and creating and utilizing macros are covered. |
Who Should Attend? |
Users who wish to learn more advanced database functions will benefit from this course. |
Prerequisites: |
Microsoft Access: Introduction (DBAS7115T, DBAS7125T or DBAS7515A). |
Objectives: |
Create lookup fields to add data to databasesProduce subforms to display data from tables or queries that have a one-to-many relationshipCreate a form using Design View and apply calculated controls to display totals and other computationsProduce queries using joined tablesSave forms and reports as data access pages so that intranet/Internet access can be achievedCompose Extensible Markup Language (XML) documents for importing and exporting data on the Web |
|
|