Term
|
Definition
| lines that are printed for each record that contain only those fields you specify and in the order you specify |
|
|
Term
|
Definition
| arrangement of data into tables and fields |
|
|
Term
|
Definition
| What is the one main principle in database design? |
|
|
Term
|
Definition
| storing the same fact in more than one place |
|
|
Term
|
Definition
Why is redundancy a problem?
a) it wastes memory space
b) it makes updating the database more difficult
c) there is a possibility that data will be inconsistent
d) all of the above
e) all but b
f) all but c |
|
|
Term
|
Definition
| a special technique that identifies and eliminates redundancy |
|
|
Term
|
Definition
| a question represented in a way that Access can understand |
|
|
Term
|
Definition
| a special window where you create a query by making entries |
|
|
Term
|
Definition
It is easier to work with a Select Query window if it is:
a) maximized
b) minimized
c) restored |
|
|
Term
|
Definition
| the lower pane in the Select Query window where you specify fields to be included, sort order, and the criteria the records you are looking for must satisfy. |
|
|
Term
|
Definition
|
|
Term
|
Definition
| a query language first proposed in the mid-70's, where users asked questions by filling in a table on a screen |
|
|
Term
|
Definition
| If you select the wrong field in the grid in the Query window, click ____ and then ____. |
|
|
Term
|
Definition
| Once you have created the query, you produce the results using the ___ button on the ______ toolbar. |
|
|
Term
|
Definition
| the most widespread query language where users type commands to find information |
|
|
Term
|
Definition
| Which symbol in the field list do you select to indicate that you want all the fields to be included in a query? |
|
|
Term
|
Definition
| The simplest way to clear out entries in a query is to click ____ on the menu bar and click ______. |
|
|
Term
|
Definition
Some database systems require that text data be enclosed in:
a) brackets
b) parentheses
c) quotation marks
d) colons |
|
|
Term
False
Access inserts the quotation marks automatically |
|
Definition
| T or F: Access requires that you insert text data with quotation marks. |
|
|
Term
|
Definition
| data in a field whose data type is Text |
|
|
Term
|
Definition
| symbols that represent any character or combination of characters |
|
|
Term
|
Definition
| wildcard that represents any collection of characters |
|
|
Term
|
Definition
| wildcard which represents an individual character |
|
|
Term
|
Definition
|
|
Term
|
Definition
If you type Fa*, which records below would probably show up?
a) Fab
b) Fall
c) Face
d) Factory
e) all of the above |
|
|
Term
|
Definition
If you saw something written T?m, which records would you expect to see:
a) Term
b) Tom
c) Tim
d) Tbm
e) all of the above
f) all but a |
|
|
Term
|
Definition
| T or F: You can't add or edit records in Query Datasheet view |
|
|
Term
|
Definition
| a query that prompts for input whenever it is run |
|
|
Term
|
Definition
| When creating a parameter query, it is important that the enclosed value does not match the name of any _____. |
|
|
Term
|
Definition
| You enclose the value of a parameter query in _______. |
|
|
