Students will learn intermediate features of Access 2000 including charting, advanced queries, working with multiple tables, and more.
Access 2000: Level 2 (or equivalent experience)
- Design parameter and action queries
- Join tables and work with join properties
- Use Action Queries such as Make Table, Delete, Update Queries
- Build a form based on joined tables; create forms with sub-forms
- Use option groups and additional form design enhancements
- Create macros and command buttons
- Use macros to control form properties, to provide user interaction; use macros to automate tasks
- Use advanced report techniques; hide duplicate data, group data and use functions in reports
- Use hyperlinks from within Access
- Use advanced report features; label a report, create customized headers/footers, add calculated controls, add custom pages