| Querying Tables and Creating Reports
By the end of this lab students should know how to: - Evaluate table design.
- Establish relationships.
- Enforce referential integrity.
- Create and modify a simple query.
- Query two tables.
- Filter a query.
- Find unmatched and duplicate records.
- Create a Parameter query.
- Create reports from tables and queries.
- Display a Totals row.
- Modify a report design.
- Select, move, and size controls.
- Change page margins.
- Preview and print a report.
- Compact and back up a database.
|