Site MapHelpFeedbackQuerying Tables and Creating Reports
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.










Microsoft Office 2007 SeriesOnline Learning Center

Home > Access > Lab 3