Chapter 12 Study Guide
This is to help you study for your quiz over Chapter 12.
Do not only memorize this guide word for word, you should be prepared to show that you understand the terms and ideas listed below.
- Tables are related when a field in one table corresponds to a field in another table.
- Table relationships can be viewed, created and deleted in the Relationships window (Tools-->Relationships)
- Sudatasheets show the records from another table that are related to the current table.
- Queries
--Select Query - selects data that matches a specified criteria.
--Range Query - matches a range of values. Uses relational operators ( < > <= >= <>)
--Complex Queries - a select query with multiple criteria. Uses AND and/or OR
--Wildcards * matches any number of characters, ? matches any one character
--Update query modifies or updates records.
-Mail merge integrates data from a database into a "form letter". This drastically reduces the time needed to create large mailings.
-Mail merge can also be used with mailing labels.
"