Access Chapter 2

Question 1

Wildcard

Answer 1

A special character that can represent one or more characters in the criterion of a query.

Question 2

Field Property

Answer 2

A characteristic of a field that determines how a field looks and behaves.

Question 3

AND Logical Operator

Answer 3

Returns only records that meet all criteria.

Question 4

Criteria Row

Answer 4

A row in the Query Design view that determines which records will be selected.

Question 5

Data Type

Answer 5

Determines the type of data that can be entered and the operations that can be performed on that data.

Question 6

Caption Property

Answer 6

Used to create a more readable label that displays in the top row in Datasheet view and in forms and reports.

Question 7

Query

Answer 7

Enables you to ask questions about the data stored in a database.

Question 8

Null

Answer 8

The term Access uses to describe a blank field.

Question 9

AutoNumber

Answer 9

A data type that is a number that automatically increments each time a record is added.

Question 10

Data Redundancy

Answer 10

The unnecessary storing of duplicate data in two or more tables.

Question 11

Number Data Type

Answer 11

A data type that can store only numerical data.

Question 12

One-to-many Relationship

Answer 12

A relationship established when the primary key value in the primary table can match many of the foreign key values in the related table.

Question 13

Foreign Key

Answer 13

A field in one table that is also the primary key of another table.

Question 14

Cascade Update Related Fields

Answer 14

An option that directs Access to automatically update all foreign key values in a related table when the primary key value is modified in a primary table.

Question 15

Referential Integrity

Answer 15

Rules in a database that are used to preserve relationships between tables when records are changed.

Question 16

CamelCase Notation

Answer 16

Uses no spaces in multiword field names, but uses uppercase letters to distinguish the first letter of each new word.

Question 17

Sort Row

Answer 17

A row in the Query Design view that enables you to reorder the data in ascending or descending order.

Question 18

Multitable Query

Answer 18

Contains two or more tables, enabling you to take advantage of the relationships that have been set in your database.

Question 19

OR Logical Operator

Answer 19

Returns records meeting any of the specified criteria.

Question 20

Simple Query Wizard

Answer 20

Provides dialog boxes to guide you through the query design process.

Question 21

All of the following are suggested guidelines for table design except:

Answer 21

Avoid data arithmetic

Question 22

All of the following are suggested guidelines for table design

Answer 22

• Include all necessary data.
• Store data in its smallest parts.
• Link tables using common fields.

Question 23

Which of the following determines the type of data that can be entered and the operations that can be performed on that data?

Answer 23

Data Type

Question 24

When entering, deleting, or editing table data

Answer 24

The table must be in Datasheet view.

Question 25

When importing data into Access, which of the following statements is true?

Answer 25

You can assign a primary key while you are importing Excel data.

Question 26

The main reason to enforce referential integrity in Access is to

Answer 26

Keep invalid data from being entered into a table.

Question 27

An illustration of a one-to-many relationship would be a

Answer 27

Customer may have multiple orders.

Question 28

A query’s specifications providing instructions about which records to include must be entered on the

Answer 28

Criteria row of the query design grid.

Question 29

When adding Value criteria to the Query Design view, the value you enter must be delimited by

Answer 29

Nothing ( ).

Question 30

It is more efficient to make a copy of an existing query rather than create a new query when which of the following is true?

Answer 30

The existing query and the new query use the same tables and fields.

Question 31

Which of the following is true for the Query Wizard?

Answer 31

No criteria can be added.