Access - Ch 2

Question 1

Unnecessary storing of duplicate data in 2+ tables

Answer 1

Data Redundancy

Question 2

Determines types of data that can be entered

Answer 2

Data Type

Question 3

Same as a Primary Key from a different table

Answer 3

Foreign Key

Question 4

Determine how the field looks & behaves

Answer 4

Field Properties

Question 5

Used to create a label that is more understandable

Answer 5

Caption Property

Question 6

Determines maximum # of characters in the field area

Answer 6

Field Size

Question 7

Changes the way a field is displayed

Answer 7

Format

Question 8

Simplifies data by providing literal characters that are typed for every entry

Answer 8

Input Mask

Question 9

Automatically predefined value for each field

Answer 9

Default Value

Question 10

Requires that data entered must conform to specified rule

Answer 10

Validation Rule

Question 11

Specifies the error message that displays when rule is violated

Answer 11

Validation Text

Question 12

Indicates that value is necessary for the record

Answer 12

Required

Question 13

Used for calculated field only

Answer 13

Expression

Question 14

Used for calculated fields only

Answer 14

Result Type

Question 15

Enforces rules in database that are used to preserve relationships between tables

Answer 15

Referential Integrity

Question 16

PK table must only have 1 occurrence of each value, can match multiple FK values in related field

Answer 16

One-to-Many Relationship type

Question 17

Used to set rules to determine which records will be selected

Answer 17

Criteria Row

Question 18

Special characters that can represent one or more characters in text value

Answer 18

Wildcards

Question 19

Enable you to limit the query results to those meeting the criterion only

Answer 19

Comparison Operators

Question 20

Blank field

Answer 20

Null

Question 21

Contain 2+ tables, enable you to take advantage of the relationships that have been set in database

Answer 21

Multitable Queries