Extending Access extends your Microsoft Access knowledge to create multi-table databases that include relationships, filters, multi-table queries, forms with subforms, data validation rules and customised reports. In completing the learning tasks you will create 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: 0-877350-27-30
Total pages: 162
Software version: Microsoft Access 2007
Qualifications: NZQA Unit Standard 2787
Click here to view table of contents (pdf 151 kb)
