Deck 10: Analyzing Database Design Using Northwind

Question 1

One-to-one relationships are rare.

Answer 1

True

Question 2

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

Answer 2

True

Question 3

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

Answer 3

False

Question 4

Referential integrity helps create orphan records.

Question 5

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

Question 6

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

Question 7

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

Question 8

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

Question 9

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

Question 10

A normalized database simplifies overall database maintenance.

Question 11

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

Question 12

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

Question 13

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

Question 14

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

Question 15

A normalized database increases redundant data.

Question 16

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 17

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

Question 18

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

Question 19

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

Question 20

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

Question 21

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

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

Question 22

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 23

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 24

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 25

A normalized database decreases ____.

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

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

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 28

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 29

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 30

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 31

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 32

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 33

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 34

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 35

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 36

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 37

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 38

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 39

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

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

Question 40

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 41

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 42

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 43

Which of the following is NOT a form property?

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

Question 44

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

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

Question 45

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 46

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

Question 47

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 48

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 49

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

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

Question 50

The figure above is in ____ View.

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

Question 51

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 52

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

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

Question 53

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

Question 54

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

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

Question 55

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

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

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

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

Question 58

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

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

Question 59

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 60

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

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

Question 61

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

Question 63

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 64

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

Question 65

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

Question 66

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 67

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

Question 68

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

Question 69

List three reasons why data normalization is valuable.

Question 70

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

Question 71

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.
The student health database contains a Students table. If each student record in the Students table has a unique StudentID, what special designation would the StudentID field be given in the Students table?

Question 72

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 73

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

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

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 76

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 77

Describe third normal form.