1) You need to design a new Access database. The first step is to organize the smallest to largest data, also called: D) Hierarchy of data.

2) Access is a relational database, which means that the data are organized into a collection of related:
C) Tables.

3) In Access, a collection of numbers and/or characters that describes one aspect of a business object or activity is called: C) A field.

4) A pre-designed database that contains various pre-built objects is called: A) A template.

5) Tables and forms are examples of database: D) Objects.

6) Each major subject or grouping of information you will store in your database should have a separate E) Table.

7) When you need to create an interface to view, add, update, and delete data in Access, you should use a: A) Form.
8) If you want create a formatted, professional way to present and print the contents of your database, you use a: D) Report.

9) The last row in an Access table is called the: A) Append Row.

10) In a database, the special field that contains a unique value for each record is the: E) Primary key.

11) If any of your database columns display the ###### symbols, you need to: B) Widen the column.
12) When you first open a table in Datasheet view, Access uses the first field to sort the data records: C) In ascending order.

13) When you want to view only certain database fields such as product type, use this function: B) Filter

14) You need to find both a particular product type AND a price, you can do this through: A) compound criteria.

15) Which of the following is a special text format applied to a Long Text data type that allows you to store formatted text?

C) Rich Text