Question 1

Match each term with the correct choice.
-A process of structuring data into a well-defined database

Accepted Answer

A) Zero-length string 
B) Null 
C) Caption 
D) Normalizing 
E) Northwind 
A) Zero-length string 
B) Null 
C) Caption 
D) Normalizing 
E) Northwind

Question 2

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

Accepted Answer

The answer of The Relationships window shows how well the...

Question 3

-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. 
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 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

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

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

-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 8

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 9

Second normal form means ____.

Accepted Answer

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 
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 10

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 
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 11

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 
A)  watermark 
B)  lookup image 
C)  header 
D)  theme

Question 12

A normalized database decreases ____.

Accepted Answer

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

Question 13

Match each term with the correct choice.
-An intentional "nothing" entry

Accepted Answer

A) Zero-length string 
B) Null 
C) Caption 
D) Normalizing 
E) Northwind 
A) Zero-length string 
B) Null 
C) Caption 
D) Normalizing 
E) Northwind

Question 14

-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. 
A)  ShipVia 
B)  ShipperID 
C)  CompanyName 
D)  The Shippers table does not have a primary key field.

Question 15

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

Accepted Answer

The answer of A(n) ____________________ join operation is the default...

Question 16

List three reasons why data normalization is valuable.

Accepted Answer

1. Reduces inaccurate data
2. Reduces re

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

intermedia

Question 19

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 20

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

Accepted Answer

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

Match each term with the correct choice. -A process of structuring data into a well-defined database

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

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

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

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

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

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

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

Second normal form means ____.

A multi-field primary key uses ____.

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

A normalized database decreases ____.

Match each term with the correct choice. -An intentional "nothing" entry

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

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

List three reasons why data normalization is valuable.

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

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

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

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

Getting Started With Microsoft Office 2013

Getting Started With Chapter Access 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Importing and Exporting Data

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Chapter Access and the Web

Filters

Exam 11: Analyzing Database Design Using Northwind

Match each term with the correct choice. -A process of structuring data into a well-defined database

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

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

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

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

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

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

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

Second normal form means ____.

A multi-field primary key uses ____.

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

A normalized database decreases ____.

Match each term with the correct choice. -An intentional "nothing" entry

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

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

List three reasons why data normalization is valuable.

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

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

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

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

Getting Started With Microsoft Office 2013

Getting Started With Chapter Access 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Importing and Exporting Data

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Chapter Access and the Web

Filters