Deck 11: Analyzing Database Design Using Northwind

Question 1

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

Answer 1

True

Question 2

The default join type for a query with two tables in a one-to-many relationship is the outer join. _________________________

Answer 2

False, inner

Question 3

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

Answer 3

False, second

Question 4

A switchback form is a special form used to help users navigate throughout the rest of the database.

Question 5

One-to-one relationships are rare.

Question 6

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

Question 7

A normalized database simplifies overall database maintenance.

Question 8

You query for zero-length strings using Is Null criteria. _________________________

Question 9

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

Question 10

The CCur function converts a calculated result to a currency value. _________________________

Question 11

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

Question 12

Use Is Empty criteria in a query to select records where there is no entry in a field. _________________________

Question 13

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

Question 14

The Append Only property of the Memo field is available for all Access databases, regardless of which version of Access you are using.

Question 15

If you often sort on a field, its Index property should be set to Yes.

Question 16

A normalized database increases redundant data.

Question 17

A special form used to announce information is called a splash screen.

Question 18

You should always try to create databases that use 1NF normalization rules. _________________________

Question 19

Referential integrity helps create orphan records.

Question 20

A table's Property Sheet controls characteristics for the entire table object.

Question 21

Which statement is true about the figure above?

A) All direct relationships are one-to-one.
B) Referential integrity is not enforced on any relationships.
C) All direct relationships are one-to-many.
D) All direct relationships are many-to-many.

Question 22

A normalized database decreases ____.

A) the ability to create reports
B) database performance (speed)
C) the ability to create queries
D) inaccurate data

Question 23

What is positioned in the right side of the Field Properties pane?

A) The field list
B) The last property value choice you made
C) The Lookup Wizard
D) A description of the current property

Question 24

Normalizing data means ____.

A) analyzing database performance
B) structuring it for a relational database
C) creating clear and logical data entry forms
D) repeating data between two tables

Question 25

A text field allows you to calculate a(n) ____ statistic in the Totals cell.

A) Average
B) Sum
C) Count
D) All of the above

Question 26

A ____ relationship cannot be created directly between two tables in Access.

A) one-to-one
B) one-to-many
C) many-to-many
D) all three types can be directly created with two tables in Access

Question 27

You should strive to create databases that use ____ rules for normalization.

A) zero normal form
B) first normal form
C) second normal form
D) third normal form

Question 28

Two tables have a ____ relationship when they are both related to the same intermediate table with one-to-many relationships.

A) one-to-one
B) one-to-many
C) many-to-one
D) many-to-many

Question 29

An example of a ____ relationship is when sensitive information such as emergency contact information must be separated from basic demographic data in two tables that are related by their primary key fields.

A) one-to-one
B) one-to-many
C) many-to-one
D) many-to-many

Question 30

When two fields are used in a Validation Rule expression, you should enter the rule in the ____.

A) Table Property Sheet
B) individual field's Property Sheet
C) Query Validation box
D) Current Record box

Question 31

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

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 32

A ____ relationship occurs when the primary key field of one table is related to the primary key field of another table.

A) one-to-many
B) many-to-one
C) one-to-one
D) many-to-many

Question 33

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

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

Question 34

Northwind is provided by Microsoft as a(n) ____.

A) Help screen
B) attachment field
C) sample database
D) online tutorial

Question 35

In Table Design View, you can view the properties of ____ field(s) at a time.

A) 1
B) 2
C) 4
D) as many as you select at the same time

Question 36

In the figure above, what type of relationship is shown between the Customers and Shippers tables?

A) One-to-many
B) One-to-one
C) Many-to-many
D) None

Question 37

First normal form refers to ____.

A) redundant data in an original table that is extracted, placed in a new table, and related to the first table
B) derived fields that are removed
C) a 2-dimensional table with rows and columns
D) calculated fields that are removed

Question 38

A multi-field primary key uses ____.

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 39

In the figure above, how many foreign key fields are in the Orders table?

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

Question 40

Second normal form means ____.

A) calculated fields are removed
B) redundant data is extracted into a new table
C) totals are removed
D) a single table with rows and columns

Question 41

In the figure above, the values of which field are being totaled?

A) CategoryName
B) ProductName
C) ProductSales
D) Category Sales

Question 42

Which of the following is NOT a form property?

A) Border Style
B) Record Selectors
C) Control Source
D) Navigation Buttons

Question 43

The "" criteria is used to query for ____ values.

A) Like
B) Null
C) Zero-length string
D) Is Null

Question 44

When a query is based on another query's field list, the field list is called a(n) ____.

A) Action
B) Sub report
C) Append query
D) Subquery

Question 45

The Lookup Wizard creates a one-to-____________________ relationship.

Question 46

Which function would you use to convert a value to currency?

A) CCurr
B) CCur
C) CurrencyConverter
D) ValueToCurrency

Question 47

In the figure above, what is the name of the field list?

A) CategoryName
B) Product Sales for 1995
C) ProductSales
D) CategorySales

Question 48

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

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

Question 49

A ____ is a type of form used to make choices to modify the contents of another object in the database.

A) switchboard
B) dialog box
C) splash screen
D) startup form

Question 50

Which is NOT true of the Caption property?

A) It is an optional property.
B) It is used as the default field name at the top of the field column in datasheets.
C) It is used as the default field name in labels that describe fields on forms and reports.
D)It must match the field name.

Question 51

The Sales Reports form in the figure above is an example of which type of Access form?

A) Dialog box
B) Splash Screen
C) Data Entry form
D) Switchboard form

Question 52

The figure above is in ____ View.

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

Question 53

A numeric field allows you to calculate a(n) ____ statistic in the Totals cell.

A) Average
B) Sum
C) Count
D) All of the above

Question 54

The ____ property, when set to Yes, allows you to add data to a Long Text field, but not change or remove existing data.
A)
Paste Structure Only
B)
Paste Structure and Data
C)
Append Only
D)
Append

A) Paste Structure Only
B) Paste Structure and Data
C) Append Only
D) Append

Question 55

In the figure above, which field is the grouping field?

A) CategoryName
B) ProductName
C) ProductSales
D) CategorySales

Question 56

In the figure above, what is the name of the query being constructed?

A) Category Sales for 1995
B) Product Sales for 1995
C) ProductSales
D) CategorySales

Question 57

In the figure above, results are grouped first by ____.

A) Categories
B) CategoryName
C) Products
D) ProductName

Question 58

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

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

Question 59

In the figure above, what type of control shows the list of categories (Beverages, Condiments, so forth)?

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

Question 60

The Relationships window shows how well the data has been ____________________.

Question 61

If an employee does not want his/her phone number listed in a company database, and you want to enter two quotation marks with nothing between them to indicate an intentional nothing entry in the field, the ____________________ field property in the employee table must be set to Yes.

Question 62

A(n) ____________________ primary key consists of two fields, such as OrderID and ProductID.

Question 63

Match each term with the correct choice.
a.Zero-length string
d.Normalizing
b.Null
e.Northwind
c.Caption
A process of structuring data into a well-defined database

Question 64

Tables with a many-to-many relationship must be related to an additional table, called a(n) ____________________ table.

Question 65

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

Question 66

Match each term with the correct choice.
a.Zero-length string
d.Normalizing
b.Null
e.Northwind
c.Caption
A sample database

Question 67

CASE
Kelsey and Matt are in an advanced Access class together and have teamed up as study partners. They have created a mini-quiz for each other. Following are some of Kelsey's questions for Matt.
Which window shows you how well the data has been normalized?

Question 68

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 database includes two tables, one containing standard information such as student ID, name, and address, and the other containing student ID and immunization dates for required immunizations, one record per student. What would be the proper relationship between the tables?

Question 69

CASE
Kelsey and Matt are in an advanced Access class together and have teamed up as study partners. They have created a mini-quiz for each other. Following are some of Kelsey's questions for Matt.
What is the first clue that data is not properly normalized?

Question 70

Describe third normal form.

Question 71

Match each term with the correct choice.
a.Zero-length string
d.Normalizing
b.Null
e.Northwind
c.Caption
A property that displays the default field name at the top of the field column

Question 72

Match each term with the correct choice.
a.Zero-length string
d.Normalizing
b.Null
e.Northwind
c.Caption
An intentional "nothing" entry

Question 73

A(n) ____________________ table is a table that stores values used in a field of another table.

Question 74

A(n) ____________________ join operation is the default join that applies to one-to-many relationships between two tables in a query.

Question 75

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

Question 76

Compare and contrast a zero-length string with a null entry.

Question 77

List three reasons why data normalization is valuable.

Question 78

A one-to-one relationship occurs when one record of the first table is related to ____________________ record(s) in the second table.

Question 79

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?

Question 80

Match each term with the correct choice.
a.Zero-length string
d.Normalizing
b.Null
e.Northwind
c.Caption
A blank entry