Extending Access

Extending Access builds on the Access basics to enable you to create databases that include relationships, filters, multi-table queries, forms with subforms, data validation rules and customised reports. The learning tasks in this manual include both single table and multi-table databases. You will learn how to:
- Determine and create database relationships
- Use subdatasheets
- Apply datasheet filters
- Create multi-table queries
- Create calculated fields in queries
- Customise forms by adding lookup fields, subforms and calculated fields
- Create a startup form
- Set up data validation rules to assist data entry
- Apply data integrity practices
- Exchange data with other applications
- Backup and restore database files
- Compact and repair database files
ISBN: 1-877350-79-6
Total pages: 190+
Qualification: NZQA Unit Standard 2787
Total pages: 190+
Qualification: NZQA Unit Standard 2787
More from this collection