Start Access | high |
Create Tables and Define Fields | high |
Add Records | high |
Create and Use Forms | moderate |
Switch Views | high |
Build and Print Reports | moderate |
Get Help | high |
Create and Run Queries | high |
Write queries with match criteria | high |
Write queries with AND and OR criteria | moderate |
Write queries with sorted records | moderate |
Write queries with joined tables | moderate |
Write queries with formulas | moderate |
Write queries with aggregate functions | moderate |
Search, filter, delete records | high |
Change database structure | moderate |
Write and run update queries | moderate |
Write and run delete queries | moderate |
Create validation rules | moderate |
Enforce referential integrity | low |
Use sub-datasheets | moderate |
Sort records without a query | moderate |
Create and use indexes | low |