Overview: Students will learn how to create action queries, more efficient forms and reports, and macros.

Prerequisites: Students enrolling in this course should be able to work with Access at an intermediate level, and understand

Access terminology

Benefits: Students will learn how to analyze data by creating complex queries, speed repetitive tasks by creating macros.

Upon successful completion of this course, students will be able to:

• Make select queries more versatile by using parameters; and use action queries to update data values and add or delete records.
• Refine the information derived from queries by creating outer joins and using crosstab queries.
• Enhance form design by manipulating control object properties.
• Automate simple tasks by creating macros to open forms and control form properties.
• Make forms more functional and automate tasks by creating macros.
• Enhance the design of reports by hiding repetitive data, grouping data on prefix values, and using functions in controls.
• Use Access to create links to Internet sites, and to save data as HTML documents.

• Designing parameter and action queries
• Creating parameter queries
• Creating action queries
• Joining tables and working with join properties
• Crosstab queries
• Editing limitations in query datasheets
• Building a form based on joined tables; using functions in forms
• Using option groups and additional form design enhancements
• Creating macros and command buttons
• Using macros to control form properties
• Using macros to provide user interaction
• Using macros to automate tasks
• Hiding duplicate data, grouping data, and using functions in reports
• Using hyperlinks