Start Access | A 1.09 | high |
Create Tables and Define Fields | A 1.13-20, 1.32-34 | high |
Add Records | A 1.21-27 | high |
Create and Use Forms | A 1.34-40 | moderate |
Switch Views | A 1.39 | high |
Build and Print Reports | A 1.41-46 | moderate |
Get Help | A 1.47 | high |
Create and Run Queries | A 2.06-15 | high |
Write queries with match criteria | A 2.16-22 | high |
Write queries with AND and OR criteria | A 2.22-24 | moderate |
Write queries with sorted records | A 2.24-28 | moderate |
Write queries with joined tables | A 2.29-33 | moderate |
Write queries with formulas | A 2.33-36 | moderate |
Write queries with aggregate functions | A 2.36-41 | moderate |
Search, filter, delete records | A 3.08-15 | high |
Change database structure | A 3.15-22 | moderate |
Write and run update queries | A 3.22-25 | moderate |
Write and run delete queries | A 3.25-27 | moderate |
Create validation rules | A 3.27-35 | moderate |
Enforce referential integrity | A 3.36-39 | low |
Use sub-datasheets | A 3.39-40 | moderate |
Sort records without a query | A
3.40-42 | moderate |
Create and use indexes | A 3.43-48 | low |