Students will learn intermediate features of Access 2000 including charting, advanced queries, working with multiple tables, and more.
Access 2000: Level 1(or equivalent experience)
- Create charts and modify chart elements
- Create and apply advanced filters; filters by selection, filters by form, filters by input
- Work with relationships; define relationship types, join tables in queries
- Maintain data integrity; set required properties, validation rules, set lookup fields
- Use advanced form features; use expressions, improve accuracy in forms
- Work with Subdatasheets
- Use advanced report features; label a report, create customized headers/footers, add calculated controls, add custom pages