Lab Final Sample

Multiple Choice
Identify the choice that best completes the statement or answers the question.

____ 1. In a(n) ____ database such as those maintained by Access, a database consists of a collection of tables, each of which contains information on a specific subject.
a.|tabular|c.|attribute|
b.|record|d.|relational|

____ 2. A(n) ____ data type can store a variable amount of text or combination of text and numbers where the total number of characters may exceed 255.
a.|Memo|c.|Variable|
b.|Long Text|d.|Character|

____ 3. A field with the ____ data type can contain an attached file, such as an image, document, chart, or spreadsheet.
a.|Attachment|c.|Document|
b.|File|d.|Extend|

____ 4. To show the symbol for the Euro instead of the dollar sign, change the ____ property for the field whose data type is Currency.
a.|Field Size|c.|Caption|
b.|Format|d.|Description|

____ 5. In the accompanying figure, the key symbol that appears in the row selector for the Book Rep Number field indicates that Book Rep Number is the ____ for the table.

a.|principal key|c.|main key|
b.|foreign key|d.|primary key|

____ 6. In the accompanying figure, the Book Rep table displays in ____.
a.|Structure view|c.|Layout view|
b.|Design view|d.|Table view|

____ 7. You can place an insertion point by tapping or clicking in the field or by pressing ____.
a.|F2|c.|F4|
b.|F3|d.|F5|

____ 8. To open the Navigation Pane, tap or click the ____ Button.
a.|Open Navigation Pane|c.|Shutter Bar Open/Close|
b.|Open Pane|d.|Navigation Bar Show/Hide|

____ 9. To create a query using the Query Wizard, tap or click ____ on the ribbon and then click the Query Wizard button.
a.|CREATE|c.|NEW OBJECT|
b.|INSERT|d.|REPORT|

____ 10. To view the results of a saved query, press and hold or right-click the query in the Navigation Pane and tap or click ____ on the shortcut menu.
a.|Datasheet View|c.|Results View|
b.|Open|d.|Run|

____ 11. To change the design of a query, press and hold or right-click the query in the Navigation Pane and then tap or click ____ on the shortcut menu.
a.|Open |c.|Query Window|
b.|SQL|d.|Design View|

____ 12. To back up the database that is currently open, use the ____ command on the Save As tab in the Backstage view.
a.|Close and Back Up|c.|Save As Back Up|
b.|Back Up Current|d.|Back Up Database|

____ 13. To compact and repair a database, tap or click the ___ button in the Info gallery in the Backstage view.
a.|Restore|c.|Compaction|
b.|Fix|d.|Compact & Repair|

____ 14. To create a new query in Design view, tap or click CREATE on the ribbon to display the CREATE tab and then tap or click the ____ button to create a new query.
a.|Query|c.|Query Design|
b.|Design View|d.|Select Query|

____ 15. In the accompanying figure, the lower pane in the window where you enter criteria is called the ____.
a.|design grid|c.|criteria grid|
b.|query grid|d.|column grid|

____ 16. In the accompanying figure, you can delete the table by pressing and holding or right-clicking the field list and tapping or clicking ____ on the shortcut menu.
a.|Delete Table|c.|Remove Table|
b.|Hide Table|d.|Erase Table|

____ 17. In the accompanying figure, you can enter CSU10 in the ____ row of the Customer Number field to find all customers whose customer number is CSU10.
a.|Sort|c.|or|
b.|Show|d.|Criteria|

____ 18. To save a query, tap or click the Save button on the ____.
a.|status bar|c.|CREATE tab on the ribbon|
b.|Quick Access Toolbar|d.|HOME tab on the ribbon|

____ 19. To change the design of a query that is not currently open, press and hold or right-click the query and then tap or click ____ on the shortcut menu.
a.|Datasheet View|c.|Change View|
b.|Layout View|d.|Design View|

____ 20. To create a parameter query, enter a parameter rather than a specific value as a criterion in the design grid. The parameter must be enclosed in ____.
a.|curly braces { }|c.|parentheses ( )|
b.|square brackets [ ]|d.|single quotes ‘’|

____ 21. To use a parameter query, press and hold or right-click the query in the Navigation Pane and then tap or click ____ on the shortcut menu.
a.|Use Parameter|c.|Open|
b.|Enter Values|d.|Run|

____ 22. To find all customers whose current due amount is greater than $1,000.00, enter ____ in the Criteria row of the Current Due column.
a.|> $1000|c.|> 1,000|
b.|> 1000|d.|> $1,000|

____ 23. The ____ operator allows you to search for a range of values in one field.
a.|BETWEEN|c.|IN|
b.|RANGE|d.|SEARCH|

____ 24. To order the records in the answer to a query in a particular way, you ____ the records.
a.|index|c.|arrange|
b.|sort|d.|list|

____ 25. To sort records in a query, specify the sort order in the ____ row of the design grid below the field that is the sort key.
a.|Show|c.|Sort|
b.|List|d.|Order|

____ 26. The accompanying figure illustrates using a query to ____ tables; that is, to find records in two tables that have identical values in matching fields.
a.|combine|c.|interleave|
b.|concatenate|d.|join|

____ 27. In the accompanying figure, the ____ line between matching fields in the two tables indicates that the tables are related.
a.|infinity|c.|connector|
b.|join|d.|inner|

____ 28. In the accompanying figure, press and hold or right-click the join line and tap or click ____ on the shortcut menu to display the Join Properties dialog box.
a.|Properties|c.|Property Sheet|
b.|Join Properties|d.|Modify Properties|

____ 29. To include the Total row in the design grid, click the ____ button on the DESIGN tab.
a.|Aggregate|c.|Calculations|
b.|Statistics|d.|Totals|

____ 30. To calculate statistics for only those records that satisfy certain criteria, select ____ as the entry in the Total row for the field, and then enter the criterion in the Criteria row.
a.|Having|c.|Restrict|
b.|Where|d.|Find|

____ 31. To create a crosstab, click the ____ button on the CREATE tab.
a.|Crosstab Wizard|c.|Statistics|
b.|Query Wizard|d.|Chart|

____ 32. To show the Navigation Pane if it is hidden, click the ____ Button.
a.|Show|c.|Restore|
b.|Shutter Bar Open/Close|d.|Show/Hide|

____ 33. To organize entries in the Navigation Pane by table, click ____ on the Navigation Pane menu.
a.|Objects by Table|c.|Tables and Related Views|
b.|Table Object|d.|Default|

____ 34. To quit Access, click the ____ button on the right side of the Access title bar.
a.|Quit|c.|Stop|
b.|Close|d.|Exit|

____ 35. To move from Layout view to Form view, tap or click the ____ button on the Access status bar.
a.|Open Form|c.|Data View|
b.|Edit View|d.|Form View|

____ 36. To search for a specific record tap or click the ____ button on the HOME tab to display the Find and Replace dialog box shown in the accompanying figure.
a.|Search|c.|Search and Edit|
b.|Filter|d.|Find |

____ 37. To use a common filter to find only those customers whose city begins with G, tap or click the arrow to the right of the field name and point to the ____ command to display the custom text filters.
a.|Text Filters|c.|Common Filters|
b.|Character Filters|d.|Common Character Filters|

____ 38. To use Filter By Form to filter records, tap or click the ____ button on the HOME tab and then click Filter By Form.
a.|Advanced|c.|Selection|
b.|Filter|d.|Find|

____ 39. To filter records using complex criteria, tap or click the ____ button on the HOME tab and then tap or click Advanced Filter/Sort on the menu that appears.
a.|Filter|c.|Selection|
b.|Find|d.|Advanced|

____ 40. To create a multivalued field, create a ____ field being sure to check the Allow Multiple Values check box.
a.|list|c.|combo|
b.|value|d.|lookup|

____ 41. To create an update query, create a new query and then tap or click the ____ button on the DESIGN tab.
a.|Query Type|c.|Update|
b.|Action|d.|Data Definition|

____ 42. To create a validation rule for the State field to restrict entries to TN or TX, enter ____ in the Validation Rule property box.
a.|T*|c.|T>|
b.|T%|d.|T?|

____ 43. To specify that entries in the Returns field must be between $0.00 and $30,000.00, enter ____ in the Validation Rule property box.
a.|>=0, =0 and =$0, =$0 and