Question 1

Which of the following statements best describes a one-to-many relationship between two tables?

Accepted Answer

A)  A primary key in the first table matches several foreign keys in the second table. 
B)  A foreign key in the first table matches several primary keys in the second table. 
C)  A primary key in the first table matches exactly one foreign key in the second table. 
D)  Primary and foreign keys have multiple cross matches between a first and second table. 
A)  A primary key in the first table matches several foreign keys in the second table. 
B)  A foreign key in the first table matches several primary keys in the second table. 
C)  A primary key in the first table matches exactly one foreign key in the second table. 
D)  Primary and foreign keys have multiple cross matches between a first and second table.

Question 2

A question you ask about the data stored in a database is called a ________.

Accepted Answer

The answer of A question you ask about the data...

Question 3

Two or more tables which contain duplicate data is an example of ________.

Accepted Answer

A)  one-to-many relationships 
B)  data redundancy 
C)  many-to-many relationships 
D)  data backup 
A)  one-to-many relationships 
B)  data redundancy 
C)  many-to-many relationships 
D)  data backup

Question 4

Jen is working on a database that stores employee data. In the EmployeeData Table, there is a field that stores the number of years each employee has been with the company. She needs to design a query that shows all employees that have worked for company more than ten years. Which of the following query criteria should Jen use to locate is information and display records of employees with the company more than ten years?

Accepted Answer

A)  >10 
B)  #10# 
C)  =>10 
D)  10 
A)  >10 
B)  #10# 
C)  =>10 
D)  10

Question 5

The ________ data type can store text, numerals, and symbols.

Accepted Answer

A)  Text 
B)  Number 
C)  Date / Time 
D)  Currency 
A)  Text 
B)  Number 
C)  Date / Time 
D)  Currency

Question 6

The data type of a field determines the type of operations than can be performed on that field.

Accepted Answer

A) True 
 B)False

Question 7

The ________ data type should be applied to fields that contain a combination of characters.

Accepted Answer

The answer of The ________ data type should be applied...

Question 8

It is best to design fields to hold large amounts of data.

Accepted Answer

A) True 
 B)False

Question 9

In Access, a query criterion use to locate a blank field is:

Accepted Answer

A)  Empty 
B)  Void 
C)  Null 
D)  Invalid 
A)  Empty 
B)  Void 
C)  Null 
D)  Invalid

Question 10

All of the following are acceptable field names EXCEPT:

Accepted Answer

A)  Clientnumber 
B)  ClientNumber 
C)  ClientID 
D)  ClientNum 
A)  Clientnumber 
B)  ClientNumber 
C)  ClientID 
D)  ClientNum

Question 11

Which of the following statements is true regarding multi-table queries?

Accepted Answer

A)  Skill is required in choosing the right tables and managing table relationships 
B)  If join lines do not appear between tables, the multi-table query results will not be affected 
C)  Creating a multi-table query is different from creating a single table query 
D)  You should add all the tables in a database to your multi-table query 
A)  Skill is required in choosing the right tables and managing table relationships 
B)  If join lines do not appear between tables, the multi-table query results will not be affected 
C)  Creating a multi-table query is different from creating a single table query 
D)  You should add all the tables in a database to your multi-table query

Question 12

The run command appears as a red exclamation point in Query design view.

Accepted Answer

A) True 
 B)False

Question 13

Irene is working on a database that stores customer data and order information. The Customer Information Table holds customer information. A unique customer number serves as the primary key for this table. The Order Information Table holds order information. A unique order number serves as the primary key for this table. A customer only has one customer number but may have several order numbers. If Irene wants to establish a one-to-many relationship between the customer information table and the order information table, which of the following steps should she follow?

Accepted Answer

A)  Irene should include the primary key in the customer information table as a foreign key in the order information table. 
B)  Irene should include the foreign key in the customer information table as a primary key in the order information table. 
C)  Irene should include the primary key in the customer information table as a primary key in the order information table. 
D)  Irene cannot establish a relationship between the two tables. 
A)  Irene should include the primary key in the customer information table as a foreign key in the order information table. 
B)  Irene should include the foreign key in the customer information table as a primary key in the order information table. 
C)  Irene should include the primary key in the customer information table as a primary key in the order information table. 
D)  Irene cannot establish a relationship between the two tables.

Question 14

________ queries contain two or more tables and allow users to take advantage of relationships that have been set between these tables.

Accepted Answer

The answer of ________ queries contain two or more tables...

Question 15

Which of the following would be the best choice for a primary key?

Accepted Answer

A)  First Name 
B)  Last Name 
C)  Social Security Number 
D)  Street Address 
A)  First Name 
B)  Last Name 
C)  Social Security Number 
D)  Street Address

Question 16

A(n) ________ operator, such as the greater than or less than symbol, can can be used in a query ciriterion to limits the results produced by the query.

Accepted Answer

A)  operand 
B)  wildcard 
C)  comparison 
D)  delimiter 
A)  operand 
B)  wildcard 
C)  comparison 
D)  delimiter

Question 17

Once a table is created, you cannot change an existing field in that table.

Accepted Answer

A) True 
 B)False

Which of the following statements best describes a one-to-many relationship between two tables?

A question you ask about the data stored in a database is called a ________.

Two or more tables which contain duplicate data is an example of ________.

The ________ data type can store text, numerals, and symbols.

The data type of a field determines the type of operations than can be performed on that field.

The ________ data type should be applied to fields that contain a combination of characters.

It is best to design fields to hold large amounts of data.

In Access, a query criterion use to locate a blank field is:

All of the following are acceptable field names EXCEPT:

Which of the following statements is true regarding multi-table queries?

The run command appears as a red exclamation point in Query design view.

________ queries contain two or more tables and allow users to take advantage of relationships that have been set between these tables.

Which of the following would be the best choice for a primary key?

A(n) ________ operator, such as the greater than or less than symbol, can can be used in a query ciriterion to limits the results produced by the query.

Once a table is created, you cannot change an existing field in that table.

Windows: Getting Started With Windows 7

Word: Collaboration and Research

Word: Document Presentation

Word: Introduction to Word

Word: Office Fundamentals and File Management

Powerpoint: Introduction to Excel

Powerpoint: Formulas and Functions

Powerpoint: Charts

Powerpoint: Datasets and Tables

Office Fundamentals Document Productivity

Excel: Introduction to Access

Excel: Relational Databases and Queries

Excel: Customize, Analyze, and Summarize Query Data

Excel: Creating and Using Professional Forms and Reports

Access: Introduction to Powerpoint

Access: Presentation Design

Access: Powerpoint Rich Media Tools

Filters

Exam 16: Access: Presentation Development

Which of the following statements best describes a one-to-many relationship between two tables?

A question you ask about the data stored in a database is called a ________.

Two or more tables which contain duplicate data is an example of ________.

The ________ data type can store text, numerals, and symbols.

The data type of a field determines the type of operations than can be performed on that field.

The ________ data type should be applied to fields that contain a combination of characters.

It is best to design fields to hold large amounts of data.

In Access, a query criterion use to locate a blank field is:

All of the following are acceptable field names EXCEPT:

Which of the following statements is true regarding multi-table queries?

The run command appears as a red exclamation point in Query design view.

________ queries contain two or more tables and allow users to take advantage of relationships that have been set between these tables.

Which of the following would be the best choice for a primary key?

A(n) ________ operator, such as the greater than or less than symbol, can can be used in a query ciriterion to limits the results produced by the query.

Once a table is created, you cannot change an existing field in that table.

Windows: Getting Started With Windows 7

Word: Collaboration and Research

Word: Document Presentation

Word: Introduction to Word

Word: Office Fundamentals and File Management

Powerpoint: Introduction to Excel

Powerpoint: Formulas and Functions

Powerpoint: Charts

Powerpoint: Datasets and Tables

Office Fundamentals Document Productivity

Excel: Introduction to Access

Excel: Relational Databases and Queries

Excel: Customize, Analyze, and Summarize Query Data

Excel: Creating and Using Professional Forms and Reports

Access: Introduction to Powerpoint

Access: Presentation Design

Access: Powerpoint Rich Media Tools

Filters