Modified 28 January 2007
Syllabus AccessTests will assess 60% of the Advanced features. Exams will assess 40% of the Advanced features
| Basic | Advanced | |
| TABLES | Database with single table only | Database with multiple tables |
| Field types: text, auto number, number, Boolean, date/time, currency, and memo | Field types: OLE objects and Lookup lists | |
| Primary key | Calculated fields | |
| Set field properties: field size, default values | Field properties: Format, Input mask, Caption, Validation, Required, Zero length, Indexed | |
| Add, edit and delete records | Relational data base where tables are linked | |
| Add, edit, rename, move and delete fields | One-to-one, One-to-many and Many-to-one relationships | |
| Column widths and row heights | Referential integrity | |
| Find and replace | Import or link tables from another database | |
| Sort and filter | Print table structure, tables and selections of a table | |
| QUERIES | Simple select Queries (one criteria only) | Advanced select queries: more than one criteria, formulae and calculations |
| Parameter query | ||
| Action queries: Update, append and delete | ||
| CrossTab query | ||
| Create command button to run a query | ||
| Create a query using more than one table/query | ||
| FORMS | Use wizard | Create and edit in design view (use toolbox) |
| Controls | ||
| Calculations | ||
| REPORTS | Use wizard Editing in design view (use toolbox) | |
| Backup a database | Integration with word processor and spreadsheets | |
Return to Computer Applications Technology or Computer Studies lesson plan index. This work may be freely copied for non-commercial use only. Copyright © Pam Miller.