Access questions, very easy

Name ____________________________ Date ___________________

Access 2010: Chapter 6 – Multiple Choice

Instructions: Circle the best answer.

1. You can create new Access tables in either ____ view or Design view.

a. Datasheet

b. Create

c. Home

d. Design

2. Two of the primary reasons to link data from another program to Access are to use the query and ____ features of Access.

a. report

b. function

c. both a. and b.

d. neither a. nor b.

3. When an external table or worksheet is imported, or ____, into an Access database, a copy of the data is placed in a table in the database.

a. linked

b. converted

c. pasted

d. set up

4. If you move, rename, or modify linked tables, you can use the Linked Table ____ within the Database Tools tab to update the links.

a. Manager

b. Wizard

c. Gallery

d. Library

5. The text box consists of a control that is initially unbound and a(n) ____ label.

a. attached

b. unattached

c. primary

d. source

6. Paste Append, which is available if you have ____ a record, allows you to paste the record to a table with a similar structure.

a. cut or copied

b. saved or deleted

c. opened or closed

d. all of the above

7. To use a function, type a(n) ____, followed by the function name.

a. dollar sign

b. asterisk

c. plus sign

d. equal sign

8. The IIf function consists of the letters IIf followed by three items, called ____, in parentheses.

a. criterion

b. expressions

c. arguments

d. properties

9. If you print or preview the report, you will notice that all the controls have boxes around them called ____.

a. frames

b. borders

c. edges

d. markers

10. After reviewing a report, if you realize you need an additional control, you could add it by using the appropriate tool in the ____ group or by dragging a field from the field list.

a. Insert

b. Stretch

c. Fields

d. Controls