Exploring Microsoft Office 2010, Volume 2, Grauer - Complete test bank - exam questions - quizzes (updated 2022)

Testbank, Access Chapter 1



1) A ________ is a question you ask about data stored in a database.

A) query

B) form

C) report

D) macro

Answer: A

Diff: 1

Reference: Databases Are Everywhere

Objective: 1

AppChap: Access 1: Introduction to Access



2) You can click the ________ button on the table toolbar to sort records in alphabetical
order, from A to Z.

A) form

B) descending

C) order

D) ascending

Answer: D

Diff: 1

Reference: Filters, Sorts, and Access Versus Excel

Objective: 6

AppChap: Access 1: Introduction to Access

,3) A form can best be described as a(n):

A) record.

B) object.

C) attribute.

D) table.

Answer: B

Diff: 1

Reference: Databases Are Everywhere

Objective: 1

AppChap: Access 1: Introduction to Access

,4) A field, or a combination of fields, that has a unique value is a:

A) primary key/

B) foreign key/

C) table/

D) field value/

Answer: A

Diff: 1

Reference: Databases Are Everywhere

Objective: 1

AppChap: Access 1: Introduction to Access

5) Data from two or more tables can be connected by specifying a:

A) hyperlink.

B) field value.

C) common field.

D) form.

Answer: C

Diff: 1

Reference: Relational Database

Objective: 9

AppChap: Access 1: Introduction to Access



6) A relational database is a collection of:

A) forms.

B) field values.

C) common fields.

, D) related tables.

Answer: D

Diff: 1

Reference: Relational Database

Objective: 9

AppChap: Access 1: Introduction to Access



7) A primary key:

A) must include letters.

B) must contain a unique value for each record within the table.

C) has the same value for all records.

D) is not usually necessary.

Answer: B

Diff: 1

Reference: Databases Are Everywhere

Objective: 1

AppChap: Access 1: Introduction to Access