Question 1

If a field exists that is currently part of your data,such as a Universal Product Code,it can be used as a(n)________ primary key.

Accepted Answer

The answer of If a field exists that is currently...

Question 2

The best type of key to use for fields such as CustomerID and ProductID would be an arbitrary ________ key.

Accepted Answer

The answer of The best type of key to use...

Question 3

The ________ Number Field Size property is used for very large numbers with a maximum of 15 significant digits.

Accepted Answer

The answer of The ________ Number Field Size property is...

Question 4

A(n)________ helps to enter data in a consistent manner.

Accepted Answer

The answer of A(n)________ helps to enter data in a...

Question 5

When more than one field is used to create a key,it is referred to as a(n)________ key.

Accepted Answer

The answer of When more than one field is used...

Question 6

In a database,________ occurs when data is repeated multiple times.

Accepted Answer

The answer of In a database,________ occurs when data is...

Question 7

A(n)________ is created when a relationship between two tables based on a common field is established.

Accepted Answer

The answer of A(n)________ is created when a relationship between...

Question 8

In order to minimize duplicate information in a database,you would go through the process of ________.

Accepted Answer

The answer of In order to minimize duplicate information in...

Question 9

A(n)________ table separates a many-to-many relationship into two one-to-many relationships.

Accepted Answer

The answer of A(n)________ table separates a many-to-many relationship into...

Question 10

The value in a table that is the primary key of another table is a(n)________ key.

Accepted Answer

The answer of The value in a table that is...

Question 11

The ________ property helps Access understand how to display data.

Accepted Answer

The answer of The ________ property helps Access understand how...

Question 12

When two tables have a one-to-many relationship,one-to-many is called the ________ of the relationship.

Accepted Answer

The answer of When two tables have a one-to-many relationship,one-to-many...

Question 13

Match between columns
                        Premises: Normalization
One-to-one relationship
Referential integrity
Many-to-many relationship
Cascade Update

Accepted Answer

The Answer of The process of minimizing the duplication of is...

Question 14

Match between columns
                        Premises: Foreign key
Natural primary key
Null
Numeric key
Composite key

Accepted Answer

The Answer of Empty and When more than one field is...

Question 15

Match between columns
                        Premises: Short Time
Short Date
Long Time
Long Date
General Date

Accepted Answer

The Answer of 11/9/2015 and 11/9/2015 10:10:10 PM and 10:10:10 is...

Question 16

Match between columns
                        Premises: Double
Integer
Byte
Long Integer
Single

Accepted Answer

The Answer of For large numbers with up to seven is...

Question 17

Match between columns
                        Premises: Long Text
Calculated
OLE Object
Lookup Wizard
AutoNumber

Accepted Answer

The Answer of Used for keys and Allows for cross-application is...

Question 18

Match between columns
                        Premises: Input mask
Field
Primary key
Field size
Delimiter

Accepted Answer

The Answer of Indicates the maximum length of an attribute is...

Question 19

Match between columns
                        Premises: Description
Data type
Short Text data type
Number data type
Field name

Accepted Answer

The Answer of Helps the user to discern the meaning is...

Question 20

Match between columns
                        Premises: Design view
Attribute
Datasheet view
Entity
Relationship

Accepted Answer

The Answer of Becomes a field in a table and is...

Quiz 12: Tables,Keys,and Relationships

If a field exists that is currently part of your data,such as a Universal Product Code,it can be used as a(n)________ primary key.

The best type of key to use for fields such as CustomerID and ProductID would be an arbitrary ________ key.

The ________ Number Field Size property is used for very large numbers with a maximum of 15 significant digits.

A(n)________ helps to enter data in a consistent manner.

When more than one field is used to create a key,it is referred to as a(n)________ key.

In a database,________ occurs when data is repeated multiple times.

A(n)________ is created when a relationship between two tables based on a common field is established.

In order to minimize duplicate information in a database,you would go through the process of ________.

A(n)________ table separates a many-to-many relationship into two one-to-many relationships.

The value in a table that is the primary key of another table is a(n)________ key.

The ________ property helps Access understand how to display data.

When two tables have a one-to-many relationship,one-to-many is called the ________ of the relationship.

Match the following terms with their definition.

Match the following terms with their definition.

Match the following Date/Time data types with their example.

Match the following number field sizes with their description.

Match the following data types with their description.

Match the following terms with their definition.

Match the following table Design view elements with their definition.

Match the following terms with their definition.