Extending Microsoft 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: 1-877350-79-6
Total pages: 162
Software version: Microsoft Access 2010
Qualifications: NZQA Unit Standard 2787 (version 6)
Click here to view table of contents (pdf 151 kb)
