Question 1

-Using the accompanying figure, list three principles of relational database design. Use the specific table and field names in your explanation.

Accepted Answer

The answer of 
-Using the accompanying figure, list three principles...

Question 2

-Anne Michael is working with the table in the accompanying figure. Explain what will happen when she works with the PaymentNo field in Datasheet View.

Accepted Answer

The answer of 
-Anne Michael is working with the table...

Question 3

A(n) Number data type is used to store values that represent money. _________________________

Accepted Answer

Currency

Question 4

Match the following common Number field properties with the correct description.
-Stores numbers times 10 to the -38th to +38th power
A)Long integer
B)Single
C)Byte
D)Field size
E)Double

Accepted Answer

The "Single" data type is used to store floating-point numbers with a range that includes numbers times 10 to the -38th to +38th power.

Question 5

To quickly remove all Lookup properties, change the Display Control property to Combo Box. _________________________

Accepted Answer

Text

Question 6

You can modify the Field Size property of a Short Text field. _________________________

Accepted Answer

The Field Size property of a Short Text field can be modified to control the maximum number of characters that can be entered in the field.

Question 7

-In the accompanying figure, explain why using an employee's last name as the primary key field in the Employees table does not constitute good database design.

Accepted Answer

The answer of 
-In the accompanying figure, explain why using...

Question 8

If the primary key field on the "one" side of a one-to-many relationship has an AutoNumber data type, then the data type on the foreign key field must be set to AutoNumber. _________________________

Accepted Answer

Number

Question 9

-In the accompanying figure, how does the Enforce Referential Integrity option relate to the creation of orphan records?

Accepted Answer

The answer of 
-In the accompanying figure, how does the...

Question 10

Match the following common Number field properties with the correct description.
-Stores numbers from 0 to 255
A)Long integer
B)Single
C)Byte
D)Field size
E)Double

Accepted Answer

The Byte data type in Microsoft Access can hold a number from 0 to 255, which matches the property listed.

Question 11

To move a field list in the Relationships window, drag the table's primary key field. _________________________

Accepted Answer

title bar

Question 12

-Using the accompanying figure, explain the term "orphan record" and how to avoid creating one in the Donations table.

Accepted Answer

The answer of 
-Using the accompanying figure, explain the term...

Question 13

To edit the list of values for a Lookup Field in Datasheet View, click the Edit List Items button. _________________________

Accepted Answer

To edit the list of values for a Lookup Field in Datasheet View, click the Edit List Items button.

Question 14

You can modify the Field Size property of a Number field. _________________________

Accepted Answer

The Field Size property of a Number field can be modified to specify the maximum and minimum value that can be stored in the field. The available sizes are Byte, Integer, Long Integer, Single, Double, Decimal, and Replication ID.

Question 15

Match the following common Number field properties with the correct description.
-Stores numbers in the range of 10 to the -324th to +324th power
A)Long integer
B)Single
C)Byte
D)Field size
E)Double

Accepted Answer

This is referring to the range of a Double Number Field Property, which can store extremely large numbers up to 1.79769313486232E+308 and small decimal values down to 2.225E-308.

Question 16

The . jpg file extension is short for JPEG, an acronym for the Joint Photographic Experts Group. _________________________

Accepted Answer

The .jpg file extension does indeed stand for JPEG, which is short for the Joint Photographic Experts Group.

Question 17

Match the following common Number field properties with the correct description.
-Determines the largest number that can be entered in a field
A)Long integer
B)Single
C)Byte
D)Field size
E)Double

Accepted Answer

Field size determines the largest number that can be entered in a field. The other properties refer to data types for numbers, such as single, double, byte, and long integer, but do not determine the maximum value that can be entered.

Question 18

Field descriptions may be entered in Table Design View. _________________________

Accepted Answer

Field descriptions can be entered in the "Description" property of a field in Table Design View.

Question 19

Match the following common Number field properties with the correct description.
-Stores numbers from -2,147,483,648 to 2,147,483,647
A)Long integer
B)Single
C)Byte
D)Field size
E)Double

Accepted Answer

Long integer stores numbers in the range of -2,147,483,648 to 2,147,483,647, which matches the given property. Single and Double are also number field properties, but their range and precision are different. Byte is a number field property that stores numbers from 0 to 255, which does not match the given property. Field size is not a number field property, but rather a setting that determines the maximum number of characters/bytes that can be stored in a field.

Question 20

The Input Mask property provides a pattern for data to be entered using three parts.

Accepted Answer

The Input Mask property provides a pattern for data to be entered using three parts - the first part is for the input mask itself, the second part is for the optional prompt character, and the third part is for the optional placeholder character.

Quiz 6: Modifying the Database Structure