Jan's Illustrated Computer Literacy 101 Logo:Jegsworks Jan's Illustrated Computer Literacy 101


Home > Jan's CompLit 101 > Working with Databases > Tables & Queries > Quiz
Icon: Arrow - Previous pagePrevious    NextIcon: Arrow - Next page

Jan's Working with Databases

Tables & Queries: Quiz

For each question, click on Radio Button 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. Query grid

 b. Query grid

 c. Query grid

 d. Query grid

 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