Access ch 2

Question 1

Data Redundancy

Answer 1

Unnecessary storage of data in two or more tables

Question 2

Data Type

Answer 2

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

Question 3

Foreign Key

Answer 3

The same key as the Primary key in an adjoining table

Question 4

field properties

Answer 4

determines how the field looks and behaves

Question 5

caption property

Answer 5

create a label that is more understandable than a field name

Question 6

Referential Integrity

Answer 6

enforces rules in a database that are used to preserve relationships b/w tables when records are changed

Question 7

Cascade Update Related Fields

Answer 7

when a primary key is updated, all foreign keys are as well

Question 8

Cascade Delete Record Fields

Answer 8

When a primary key record is deleted, all foreign key records are deleted as well

Question 9

one-to-many relationship

Answer 9

primary key can match many of the foreign key values in another table

Question 10

Simple Query Wizard

Answer 10

guides you through query design with step by step process. creates basic queries that do not require criteria.

Question 11

Wildcards

Answer 11

*,?,[],[!]

Question 12

Comparison operators

Answer 12

=<>

Question 13

null

Answer 13

a blank field

Question 14

AND condition

Answer 14

query results will only show records that match ALL criteria

Question 15

OR condition

Answer 15

displays records that match ANY of the citeria