McGraw-Hill OnlineMcGraw-Hill Higher EducationLearning Center
Student Center | Instructor Center | Information Center | Home
Data Files
Buzz in IT
Updates
Concepts
Flashcards
Multiple Choice Quiz
Puzzlers
Feedback
Help Center


Office XP Access 2002
Office XP Access 2002, 2/e
Timothy O'Leary, Arizona State University

Analyzing Tables and Creating Reports

Concepts

The following concepts will be introduced in this lab:

  1. Filter: A filter is a restriction placed on records in the open datasheet or form to temporarily isolate and display a subset of records.
  2. Query: A query is a request for specific data contained in a database. Queries are used to view data in different ways, to analyze data, and even to change existing data.
  3. Join: A join is an association between a field in one table or query and a field of the same data type in another table or query.
  4. Report: A report is printed output generated from tables or queries.
  5. Controls: Controls are objects on a form or report that display information, perform actions, or enhance the design.