Question 1

First normal form means that redundant data in the original table is extracted, placed in a new table, and related to the original table. _________________________

Accepted Answer

A) True 
 B)False

Question 2

You work in the registrar's office of a large university. You are responsible for creating a student database that contains students' ID numbers, names, addresses, phone numbers, and some medical information. 
Suppose the student health database includes two tables, one table called Students that contains student information such as StudentID, student name, address, and telephone number and the other table called Documentation that contains several records for each student and records the dates and descriptions of various medical documents required by the university. What type of relationship would need to be established between the two tables?

Accepted Answer

The answer of You work in the registrar's office of...

Question 3

Match between columns
                        Premises: A blank entry
A property that displays the default field name at the top of the field column
A sample database
An intentional "nothing" entry
A process of structuring data into a well-defined database

Accepted Answer

The Answer of Northwind and Normalizing and Null and Zero-length is...

Question 4

A ____ is achieved by specifying the desired image using a report's Picture property.

Accepted Answer

A)  watermark 
B)  lookup image 
C)  header 
D)  theme

Question 5

Use the Rich Text field data type when you need to store more than 256 characters in a field. _________________________

Accepted Answer

A) True 
 B)False

Question 6

In the figure above, all tables shown need to be directly related to all other tables in order to participate in a relational database.

Accepted Answer

A) True 
 B)False

Question 7

A(n) ____________________ keeps track of the order of the values in the indexed field as data is being entered and edited.

Accepted Answer

The answer of A(n) ____________________ keeps track of the order...

Question 8

A multi-field primary key uses ____.

Accepted Answer

A)  an AutoNumber field and a Text field 
B)  an AutoNumber field and a Number field 
C)  two AutoNumber fields 
D)  two or more fields used in combination for a unique value per record

Question 9

The figure above is in ____ View.

Accepted Answer

A)  Design 
B)  Datasheet 
C)  Table 
D)  Report

Question 10

One of the best ways to teach yourself advanced database skills is to study the sample Northwind database.

Accepted Answer

A) True 
 B)False

Question 11

In the figure above, what is the primary key field of the Shippers table?

Accepted Answer

A)  ShipVia 
B)  ShipperID 
C)  CompanyName 
D)  The Shippers table does not have a primary key field.

Question 12

List three reasons why data normalization is valuable.

Accepted Answer

The answer of List three reasons why data normalization is...

Question 13

In the figure above, what type of control is to the left of the Employee Sales by Country label?

Accepted Answer

A)  check box 
B)  combo box 
C)  command button 
D)  option button

Question 14

To move a field list in the Relationship window, drag its ____________________.

Accepted Answer

The answer of To move a field list in the...

Question 15

The Caption property keeps track of the order of the values in an indexed field.

Accepted Answer

A) True 
 B)False

Question 16

In the figure above, what is true about the Order Details table?

Accepted Answer

A)  It has a multi-field primary key. 
B)  It is directly related to four other tables. 
C)  It contains no foreign key fields. 
D)  It does not participate in a relationship with referential integrity.

Question 17

A right join is the default join between two tables in an Access query. _________________________

Accepted Answer

A) True 
 B)False

Exam 10: Analyzing Database Design Using Northwind

First normal form means that redundant data in the original table is extracted, placed in a new table, and related to the original table. _________________________

Match each term with the correct choice.

A ____ is achieved by specifying the desired image using a report's Picture property.

Use the Rich Text field data type when you need to store more than 256 characters in a field. _________________________

In the figure above, all tables shown need to be directly related to all other tables in order to participate in a relational database.

A(n) ____________________ keeps track of the order of the values in the indexed field as data is being entered and edited.

A multi-field primary key uses ____.

The figure above is in ____ View.

One of the best ways to teach yourself advanced database skills is to study the sample Northwind database.

In the figure above, what is the primary key field of the Shippers table?

List three reasons why data normalization is valuable.

In the figure above, what type of control is to the left of the Employee Sales by Country label?

To move a field list in the Relationship window, drag its ____________________.

The Caption property keeps track of the order of the values in an indexed field.

In the figure above, what is true about the Order Details table?

A right join is the default join between two tables in an Access query. _________________________