Question 1

Which of the following is NOT a principle of relational database design?

Accepted Answer

A) Design each table to contain fields that describe only one subject. 
B) Identify a primary key field or key field combination for each table. 
C) Data should be entered before table relationships are built. 
D) Build one-to-many relationships between the tables of your database using a field common to each table. 
A) Design each table to contain fields that describe only one subject. 
B) Identify a primary key field or key field combination for each table. 
C) Data should be entered before table relationships are built. 
D) Build one-to-many relationships between the tables of your database using a field common to each table.

Question 2

The entry mm/dd/yyyy in a Date/Time field's Format property would display September 6, 2009 as: ____.

Accepted Answer

A) 09/06/2009 
B) 9/6/2009 
C) 9/6/9 
D) 09/06/09 
A) 09/06/2009 
B) 9/6/2009 
C) 9/6/9 
D) 09/06/09

Question 3

In the figure pictured above, the Duration field is given a Number data type.Explain why this is better than a Text data type for this field.

Accepted Answer

Number data type will allow only numbers

Question 4

Byte, Long Integer, Single, and Double are examples of entries for which property?

Accepted Answer

A) Field Size 
B) Format 
C) Input Mask 
D) Validation Rule 
A) Field Size 
B) Format 
C) Input Mask 
D) Validation Rule

Question 5

The Field Properties pane displays information for how many fields at the same time?

Accepted Answer

A) One 
B) However many are visible in the window 
C) All of the fields in that particular table 
D) All of the fields in the entire database 
A) One 
B) However many are visible in the window 
C) All of the fields in that particular table 
D) All of the fields in the entire database

Question 6

Where do you modify field properties?

Accepted Answer

A) In Table Datasheet View 
B) In Table Design View 
C) In Database Design View 
D) As you are entering data in a form 
A) In Table Datasheet View 
B) In Table Design View 
C) In Database Design View 
D) As you are entering data in a form

Question 7

>=#1/1/93# is an example of an entry for which property for a Date/Time field?

Accepted Answer

A) Format 
B) Default Value 
C) Validation Rule 
D) Input Mask 
A) Format 
B) Default Value 
C) Validation Rule 
D) Input Mask

Question 8

A field that contains unique information for each record is called a(n)____ field.

Accepted Answer

A) Text 
B) Data 
C) Linking 
D) Primary key 
A) Text 
B) Data 
C) Linking 
D) Primary key

Question 9

A common place to use an Input Mask property would be for a Phone Number field.

Accepted Answer

A) True 
 B)False

Question 10

(999)000-000;1;_ would be a possible entry for which field property?

Accepted Answer

A) Format 
B) Input Mask 
C) Caption 
D) Validation Rule 
A) Format 
B) Input Mask 
C) Caption 
D) Validation Rule

Question 11

The goal of building one-to-many relationships between tables is to minimize ____ data.

Accepted Answer

A) Redundant 
B) Textual 
C) Numeric 
D) Rarely used 
A) Redundant 
B) Textual 
C) Numeric 
D) Rarely used

Question 12

If the Products and Sales tables were joined in a one-to-many relationship, which field would most likely be the linking field?

Accepted Answer

A) ProductID 
B) CustomerID 
C) EmployeeID 
D) SalesID 
A) ProductID 
B) CustomerID 
C) EmployeeID 
D) SalesID

Question 13

In the figure above, the Data Type for the Phone field is ____________________ .

Accepted Answer

The answer of   In the figure above, the...

Question 14

A(n)____ key field is the field used on the "one" side of a one-to-many relationship.

Accepted Answer

A) Primary 
B) First 
C) Foreign 
D) Infinity 
A) Primary 
B) First 
C) Foreign 
D) Infinity

Question 15

To tie the information from one table to another in an Access relational database, a(n)____ must be common to each table.

Accepted Answer

A) Record 
B) Field 
C) Object 
D) Property 
A) Record 
B) Field 
C) Object 
D) Property

Question 16

In the figure above, the ____________________ field is the key field.

Accepted Answer

The answer of   In the figure above, the...

Question 17

A relational database can best be described as a collection of related ____ designed to minimize redundant data.

Accepted Answer

A) Indexes 
B) Tables 
C) Links 
D) Properties 
A) Indexes 
B) Tables 
C) Links 
D) Properties

Question 18

The good Field Size property value for a State field is ____.

Accepted Answer

A) 2 
B) 10 
C) 50 
D) 255 
A) 2 
B) 10 
C) 50 
D) 255

Question 19

The Input Mask property contains how many parts?

Accepted Answer

A) 1 
B) 2 
C) 3 
D) 4 
A) 1 
B) 2 
C) 3 
D) 4

Question 20

Match between columns
                        Premises: Stores numbers in the range of 10 to the -324th to +324th power
Stores numbers times 10 to the -38th to +38th power
Stores numbers from -2,147,483,648 to 2,147,483,647
Stores numbers from 0 to 255
The largest number that can be entered in a field

Accepted Answer

The Answer of Field size and Long integer and Byte is...

Which of the following is NOT a principle of relational database design?

The entry mm/dd/yyyy in a Date/Time field's Format property would display September 6, 2009 as: ____.

In the figure pictured above, the Duration field is given a Number data type.Explain why this is better than a Text data type for this field.

Byte, Long Integer, Single, and Double are examples of entries for which property?

The Field Properties pane displays information for how many fields at the same time?

Where do you modify field properties?

>=#1/1/93# is an example of an entry for which property for a Date/Time field?

A field that contains unique information for each record is called a(n)____ field.

A common place to use an Input Mask property would be for a Phone Number field.

(999)000-000;1;_ would be a possible entry for which field property?

The goal of building one-to-many relationships between tables is to minimize ____ data.

If the Products and Sales tables were joined in a one-to-many relationship, which field would most likely be the linking field?

In the figure above, the Data Type for the Phone field is ____________________ .

A(n)____ key field is the field used on the "one" side of a one-to-many relationship.

To tie the information from one table to another in an Access relational database, a(n)____ must be common to each table.

In the figure above, the ____________________ field is the key field.

A relational database can best be described as a collection of related ____ designed to minimize redundant data.

The good Field Size property value for a State field is ____.

The Input Mask property contains how many parts?

Getting Started With Microsoft Office 2010 Question

Building and Using Queries

Using Forms Question

Using Reports Question

Improving Queries Question

Enhancing Forms Question

Analyzing Data With Reports Question

Web Apps: Working With Windows Live and Office Web Apps

Getting Started With Access 2.0

Filters

Exam 5: Modifying the Database Structure Question

Which of the following is NOT a principle of relational database design?

The entry mm/dd/yyyy in a Date/Time field's Format property would display September 6, 2009 as: ____.

In the figure pictured above, the Duration field is given a Number data type.Explain why this is better than a Text data type for this field.

Byte, Long Integer, Single, and Double are examples of entries for which property?

The Field Properties pane displays information for how many fields at the same time?

Where do you modify field properties?

>=#1/1/93# is an example of an entry for which property for a Date/Time field?

A field that contains unique information for each record is called a(n)____ field.

A common place to use an Input Mask property would be for a Phone Number field.

(999)000-000;1;_ would be a possible entry for which field property?

The goal of building one-to-many relationships between tables is to minimize ____ data.

If the Products and Sales tables were joined in a one-to-many relationship, which field would most likely be the linking field?

In the figure above, the Data Type for the Phone field is ____________________ .

A(n)____ key field is the field used on the "one" side of a one-to-many relationship.

To tie the information from one table to another in an Access relational database, a(n)____ must be common to each table.

In the figure above, the ____________________ field is the key field.

A relational database can best be described as a collection of related ____ designed to minimize redundant data.

The good Field Size property value for a State field is ____.

The Input Mask property contains how many parts?

Getting Started With Microsoft Office 2010 Question

Building and Using Queries

Using Forms Question

Using Reports Question

Improving Queries Question

Enhancing Forms Question

Analyzing Data With Reports Question

Web Apps: Working With Windows Live and Office Web Apps

Getting Started With Access 2.0

Filters