QUESTION 3
An action query adds, changes, or deletes multiple table records at one time.
True
False
1 points
QUESTION 4
If you want to add records from one table to a backup table, create a(n) Append query.
True
False
1 points
QUESTION 5
The outer join is the default join operation in Access.
True
False
1 points
QUESTION 6
How can you display the indexes for a table?
| a. | In Table Design view, click the Properties button.
| |
| b. | In Table Datasheet view, click the Show Hidden Properties button.
| |
| c. | In Table Datasheet view, click the Object Dependencies button.
| |
| d. | In Table Design view, click the Indexes button.
|
2 points
QUESTION 7
Create a(n) _____ query to change the name of a supervisor in an Employee table.
| a. | Update
| |
| b. | Target
| |
| c. | Make-Table
| |
| d. | Self-Join
|
2 points
QUESTION 8
As with other action queries, the icon for an Append query includes a(n) _____ to remind you that it changes data when you run the query.
| a. | red asterisk
| |
| b. | red X
| |
| c. | exclamation point
| |
| d. | question mark
|
2 points
QUESTION 9
A(n) _____ query changes the values in a field.
| a. | Make-Table
| |
| b. | Update
| |
| c. | Append
| |
| d. | Change Value
|
2 points
QUESTION 10
A(n) _____ query adds records from an existing table to the end of another table.
| a. | Crosstab
| |
| b. | Append
| |
| c. | Apply
| |
| d. | Make-Table
|
2 points
QUESTION 11
If you often sort on a field, you should set its_____ property to Yes.
| a. | Required
| |
| b. | Bound Column
| |
| c. | Caption
| |
| d. | Indexed
|
2 points
QUESTION 12
If you want to find records in the table on the “one” side of a one-to-many relationship that do not have related records in the “many” side, which join do you use?
| a. | self
| |
| b. | outer
| |
| c. | cascading
| |
| d. | inner
|
