Important Topics in Access

Topic Importance
Start Accesshigh
Create Tables and Define Fieldshigh
Add Recordshigh
Create and Use Formsmoderate
Switch Viewshigh
Build and Print Reportsmoderate
Get Helphigh
Create and Run Querieshigh
Write queries with match criteriahigh
Write queries with AND and OR criteriamoderate
Write queries with sorted recordsmoderate
Write queries with joined tablesmoderate
Write queries with formulasmoderate
Write queries with aggregate functionsmoderate
Search, filter, delete recordshigh
Change database structuremoderate
Write and run update queriesmoderate
Write and run delete queriesmoderate
Create validation rulesmoderate
Enforce referential integritylow
Use sub-datasheetsmoderate
Sort records without a querymoderate
Create and use indexeslow

Last modified:
Stephen Bloch / sbloch@adelphi.edu