| 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: - Filter: A filter is a restriction placed on records in the open datasheet or form to temporarily isolate and display a subset of records.
- 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.
- 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.
- Report: A report is printed output generated from tables or queries.
- Controls: Controls are objects on a form or report that display information, perform actions, or enhance the design.
|
|