Quiz 3

Question 1

Which of the following is a collection of data organized into meaningful information to be used in a meaningful way?

Answer 1

Database

Question 2

An access database can most accurately be described as a structured collection of

Answer 2

Objects

Question 3

Of the following which is not a main object type in an access database

Answer 3

Record

Question 4

A ____ is a question you ask about data stored in a database

Answer 4

query

Question 5

The ____ view in access looks similar to an excel spreadsheet

Answer 5

Datasheet

Question 6

You can create of modify a table’s field names and data types in

Answer 6

Design

Question 7

A primary key

Answer 7

Must contain a unique value for each record within a table

Question 8

Access differs from other microsoft software because

Answer 8

Works Primarily from storage

Question 9

When you make a change to the content of a record in an access table, when are the changes saved

Answer 9

When you move the insertion point to a different record

Question 10

Which of the following is true about access compact and repair feature

Answer 10

it defragments a fragmented database file if needed

Question 11

Access’ _____ feature creates a duplicate copy of a database

Answer 11

Backup database

Question 12

You can click the _____ button on the table toolbar to sort records in alphabetical order from a - z

Answer 12

Ascending

Question 13

When you apply a multiple sort in access, columns are sorted

Answer 13

From left to right

Question 14

Alice is working in a database containing the names, service locations and services offered by landscapers. She needs to find landscapers that offer services in the Phoenix area and that service rare plants. The best way for her to search for this data is to perform a:

Answer 14

Filter by Form

Question 15

Ryan is working in a database that organizes vendor contact information. Ryan must find vendors located in Seattle and Portland. The vendors must have offices in both cities in order to meet Ryan’s requirements. He should use the Filter by Form ________ condition.

Answer 15

AND

Question 16

Irene is working in a database that organizes city court case information. Irene must find court cases in either Jackson county or Jefferson county. Irene should use the Filter by Form ________ condition.

Answer 16

OR

Question 17

A relationship is a connection between

Answer 17

Two or more tables using a common record

Question 18

A relational database has the ability to create relationships between two ________

Answer 18

Tables

Question 19

When you ________, you ensure that data entered into a related table first exists in the primary table

Answer 19

Enforce referential integrity

Question 20

A field that is defined as a primary key in one table is defined as a(n) ________ in a related table

Answer 20

Foreign Key

Question 21

You can use a maximum of ____________ numbered buttons in addition to the + and - buttons to expand and collapse an outline.

Answer 21

Three

Question 22

To apply an outline to columns, you must ____________ the desired columns.

Answer 22

Group

Question 23

A(n) ____________ allows you to summarize and examine data such as analyzing book sales by categories.

Answer 23

Pivot Table

Question 24

Which of the following is NOT an area used when creating a PivotTable?

Answer 24

Tables

Question 25

____________ is used to exclude particular categories or values from a PivotTable.

Answer 25

Filtering

Question 26

A ____________ is a series of buttons that allows users to filter a PivotTable.

Answer 26

Slicer

Question 27

Slicer styles are located on the ____________ tab

Answer 27

Options

Question 28

PivotTable styles are located on the ____________ tab

Answer 28

Design

Question 29

A ____________ is used to graphically represent the data in a PivotTable.

Answer 29

Pivot Chart

Question 30

You can use subtotals in a dataset to calculate subtotals of groups such as sales of books within a discipline.

Answer 30

True

Question 31

To properly have two levels of subtotals, you must subtotal the secondary category first and then add a subtotal for your primary category.

Answer 31

False

Question 32

You can move a field from one PivotTable area to another by just dragging it.

Answer 32

True

Question 33

To remove a field from a PivotTable, you select it and press Delete.

Answer 33

False

Question 34

Changes made to the original worksheet are automatically reflected in the PivotTable.

Answer 34

False

Question 35

When creating a calculated field in a PivotTable, range names and cell references outside the PivotTable CANNOT be used.

Answer 35

True

Question 36

Changes made to a PivotChart are automatically reflected in the corresponding PivotTable.

Answer 36

True