Important Topics in Access

Topic Pages Importance
Start AccessA 1.09high
Create Tables and Define FieldsA 1.13-20, 1.32-34high
Add RecordsA 1.21-27high
Create and Use FormsA 1.34-40moderate
Switch ViewsA 1.39high
Build and Print ReportsA 1.41-46moderate
Get HelpA 1.47high
Create and Run QueriesA 2.06-15high
Write queries with match criteriaA 2.16-22high
Write queries with AND and OR criteriaA 2.22-24moderate
Write queries with sorted recordsA 2.24-28moderate
Write queries with joined tablesA 2.29-33moderate
Write queries with formulasA 2.33-36moderate
Write queries with aggregate functionsA 2.36-41moderate
Search, filter, delete recordsA 3.08-15high
Change database structureA 3.15-22moderate
Write and run update queriesA 3.22-25moderate
Write and run delete queriesA 3.25-27moderate
Create validation rulesA 3.27-35moderate
Enforce referential integrityA 3.36-39low
Use sub-datasheetsA 3.39-40moderate
Sort records without a queryA 3.40-42moderate
Create and use indexesA 3.43-48low

Last modified:
Stephen Bloch / sbloch@adelphi.edu