For each question, click on the radio button for your answer. You will be notified immediately whether your choice is correct or not. Double clicking may work better in some browsers.
Choose the BEST answer.
1. To require that a field for HoursPerDay is at least 4 hours, you would create _____.
a. an Input Mask
b. a Format rule
c. a conditional expression
d. a validation rule
2. A field for a phone has its Format Property set to @@@-@@@-@@@@ and its Input Mask Property set to !\(999") "000\-0000;;# . After you enter a USA phone number with area code 333, 555-4444 into the table and save the record, the phone number will look like _____.
a. 333-444-5555
b. (333) 444-5555
c. (###) ###-####
d. 3335554444
3. Three tables are related. Table1 has a One-to-Many relationship to Table2. Table 3 has a One-to-Many relationship to Table2, also. In datasheet view, which tables can show subdatasheets?
a. Table1, Table2, Table3
b. Table1, Table2 only
c. Table1, Table 3 only
d. Table2 only
4. When Access does not contain a table of data but reaches out to another source for the data, that table is _____.
a. embedded
b. linked
c. an accessory table
d. a subdatasheet
5. In the Query Design View, to select records with a Country value of France and a City value of either Paris or Lyon, your grid should look like:
a.
b.
c.
d.
e. either a or b or c
f. either b or c
6. To create a calculated field for a query, you could write _____ in the Field row.
a. Balance:[Budget]-[ActualCost]
b. =[Budget]-[ActualCost]
c. Balance=[Budget]-[ActualCost]
d. any of the above
7. To concatenate text field values, you use the _____ character to paste them together.
a. asterisk
b. ampersand
c. hash
d. square brackets
8. A query that asks the user for values first is called _____.
a. an action query
b. an append query
c. a crosstab query
d. a parameter query
e. a select query
9. The syntax of an IIf expression has the general form ____.
a. IIf(falsepart, truepart, expression)
b. IIf(expression, truepart, falsepart)
c. IIf(truepart, falsepart, expression)
d. IIf(expression, falsepart, truepart)
10. To have a print-out of what other objects depend on a particular table you could _____ .
a print the Object Dependencies task pane
b. print the Documenter report, which includes this information
c. print the Relationships window
d. capture a screen shot of the Object Dependencies task pane and print.
e. either a or d