Question 1

A(n)________ lists either values retrieved from a table or query,or a set of values that you specified when you created the field.

Accepted Answer

The answer of A(n)________ lists either values retrieved from a...

Question 2

The ________ field size is used for integers that range from 0 to 255.

Accepted Answer

The answer of The ________ field size is used for...

Question 3

Match the following terms with their definition.
I.Entity
II.Attribute
III.Relationship
IV.Data type
V.Delimiter
A.Define data
B.A character such as a tab or comma
C.An association between tables
D.A person,place,item,or event
E.A field

Accepted Answer

The answer of Match the following terms with their definition.
I.Entity
II.Attribute
III.Relationship
IV.Data...

Question 4

If you select ________ Related Fields when you define a relationship,any time that you delete records from the one side table,the related records in the many side table are also deleted.

Accepted Answer

The answer of If you select ________ Related Fields when...

Question 5

The ________ property tells Access how data is to be displayed.

Accepted Answer

The answer of The ________ property tells Access how data...

Question 6

________ is the process of minimizing the duplication of information in a relational database through effective database design.

Accepted Answer

The answer of ________ is the process of minimizing the...

Question 7

A(n)________ defines a consistent template and provides the punctuation,so you do not have to type it.

Accepted Answer

The answer of A(n)________ defines a consistent template and provides...

Question 8

The ________ field size is used for very large numbers with up to 15 significant digits.

Accepted Answer

The answer of The ________ field size is used for...

Question 9

The ________ number format uses the regional settings preset in Windows for the thousands divider.

Accepted Answer

The answer of The ________ number format uses the regional...

Question 10

Match the following number field sizes with their description.
I.Byte
II.Integer
III.Long integer
IV.Single
V.Double
A.For integers that range from -2,147,483,648 to +2,147,483,647
B.For integers that range from -32,768 to +32,767
C.For integers that range from 0 to 255
D.For large numbers with up to seven significant digits
E.For very large numbers with up to 15 significant digits

Accepted Answer

The answer of Match the following number field sizes with...

Question 11

The ________ number format displays the number as entered.

Accepted Answer

The answer of The ________ number format displays the number...

Question 12

The ________ number format displays at least one digit after the decimal point.

Accepted Answer

The answer of The ________ number format displays at least...

Question 13

The field size indicates the ________ length of a data field.

Accepted Answer

The answer of The field size indicates the ________ length...

Question 14

A(n)________ relationship is a relationship between tables in which one record in one table has many matching records in a second table,and one record in the related table has many matching records in the first table.

Accepted Answer

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

Question 15

Match the following data types with their description.
I.Short text
II.Long text
III.Number
IV.AutoNumber
V.OLE object
A.Can store up to 1 gigabyte of characters
B.Used for numeric data
C.Upper limit of 255 characters
D.Allows cross-application editing
E.Used for keys

Accepted Answer

The answer of Match the following data types with their...

Question 16

If you select ________ Related Fields when you define a relationship,then when the primary key of a record in the one side table changes,Access automatically changes the foreign keys in all related records.

Accepted Answer

The answer of If you select ________ Related Fields when...

Question 17

________ occurs when data is repeated several times in a database.

Accepted Answer

The answer of ________ occurs when data is repeated several...

Question 18

The ________ field size is used for large numbers with up to seven significant digits.

Accepted Answer

The answer of The ________ field size is used for...

Question 19

Match the following Date/Time format field properties with the appropriate example.
I.General Date
II.Long Date
III.Medium Date
IV.Long Time
V.Medium Time
A.10:10 PM
B.11/9/2015 10:10:10 PM
C.10:10:10 PM
D.Wednesday,November 9,2015
E.9-Nov-15

Accepted Answer

The answer of Match the following Date/Time format field properties...

Question 20

Match the following terms with their definition.
I.Primary key
II.Numeric key
III.Composite key
IV.Natural primary key
V.Foreign key
A.Identifies a record in another table
B.Represents an individual item,such as CustomerID
C.Unique identifier that is already a part of your data
D.Multiple fields used to identify each person or item
E.One field used to identify each person or item

Accepted Answer

The answer of Match the following terms with their definition.
I.Primary...

Quiz 2: Workshop 2: Tables, Keys, and Relationships

A(n)________ lists either values retrieved from a table or query,or a set of values that you specified when you created the field.

The ________ field size is used for integers that range from 0 to 255.

Match the following terms with their definition. I.Entity II.Attribute III.Relationship IV.Data type V.Delimiter A.Define data B.A character such as a tab or comma C.An association between tables D.A person,place,item,or event E.A field

If you select ________ Related Fields when you define a relationship,any time that you delete records from the one side table,the related records in the many side table are also deleted.

The ________ property tells Access how data is to be displayed.

________ is the process of minimizing the duplication of information in a relational database through effective database design.

A(n)________ defines a consistent template and provides the punctuation,so you do not have to type it.

The ________ field size is used for very large numbers with up to 15 significant digits.

The ________ number format uses the regional settings preset in Windows for the thousands divider.

The ________ number format displays the number as entered.

The ________ number format displays at least one digit after the decimal point.

The field size indicates the ________ length of a data field.

A(n)________ relationship is a relationship between tables in which one record in one table has many matching records in a second table,and one record in the related table has many matching records in the first table.

Match the following data types with their description. I.Short text II.Long text III.Number IV.AutoNumber V.OLE object A.Can store up to 1 gigabyte of characters B.Used for numeric data C.Upper limit of 255 characters D.Allows cross-application editing E.Used for keys

If you select ________ Related Fields when you define a relationship,then when the primary key of a record in the one side table changes,Access automatically changes the foreign keys in all related records.

________ occurs when data is repeated several times in a database.

The ________ field size is used for large numbers with up to seven significant digits.

Match the following Date/Time format field properties with the appropriate example. I.General Date II.Long Date III.Medium Date IV.Long Time V.Medium Time A.10:10 PM B.11/9/2015 10:10:10 PM C.10:10:10 PM D.Wednesday,November 9,2015 E.9-Nov-15