Final Review
Covers
Chapters 1–5 & 7 of the Access textbook and HTML
Chapter 1
Database
Table
Report
Query
Form
Primary Key
Creating tables in the Datasheet view and Design view
Modifying table fields in the Design view
Data Types
o Short Text – 255 chars
o Number
o Currency
o Date/Time
o Yes/No
o AutoNumbers
Adding or deleting records
Adding or deleting fields
Creating forms and reports using the wizard
Basic queries
Chapter 2
Foreign key
Creating queries in the Design view
Creating a query using a criteria
Creating a query based on multiple criteria (compound)
o AND
o OR
Adding fields from multiple tables
Deselecting the show checkbox in query
Unique Values property
Sorting a query
