Question 1

A collection of customer information and purchase transactions that might be stored in both Access and Excel would be called a

• field.

• record.

• table.

• database.

Question 2

Which statement is NOT true?

• A relationship is a connection between two tables using a common field.

• A primary key is used to identify common fields in a table.

• Multiple users on different computers can work on a database simultaneously.

• Access speed measures the time it takes for a storage device to make the file content available for use.

Question 3

Examining the image below, which statement best describes what we see?

• Image Description

• This is a screen print from Access  with the File tab highlighted and the Employees table shown from the list of tables. There are six records listed with 6 fields listed: Employee, LastName, FirstName, Title, Title of Contact,  Birth Date and Hire Date. The Title field name has a small funnel to the right.

• Six records have been filtered from a query called employees.

• Six records have been filtered on the title field containing sales representative from the employees table.

• A table called employees has been created from six filtered records.

• A query called employees has been created from a filtered table.

Question 4

To locate the tool to compact an Access database, click on the

• file tab, options, current database, and select compact and repair database tools.

• home tab, advanced, and select compact and repair database tools.

• database tools tab, and select compact and repair database tools.

• external data tab, and select compact and repair database tools.

Question 5

Field names in a table can be created or modified in which view?

• Datasheet

• Design

• Form

• Report

Question 6

 To add, delete, and edit a record, use

• datasheet view of a table.

• design view of a table.

• design view of a query.

• report view.

Question 7

When building a database, you should first

• create and input the design of the table and reports at the same time.

• determine the input and then design the tables.

• determine the output and then design the tables.

• input the data and then design the reports.

Question 8

You should use Excel over Access when

• you have a large amount of data.

• you need to group, sort, and total data based on various parameters.

• you need multiple related tables to store data.

• All of the above