Chapter 2 Questions and Answer

Question 1

Jenna needs to design a database for a clothing company. The first step Jenna should take is to determine what:

Answer 1

tables will be required.

Question 2

__________________________ is the unnecessary duplication of data in two or more tables, and can lead to errors.

Answer 2

Data redundancy

Question 3

When creating a multi-table query, which of the following statements is NOT correct?

Answer 3

All tables in the database should be included in the multi-table query.

Question 4

Which of the following relationships can be used to describe a customer record that is linked to several order records?

Answer 4

One-to-many

Question 5

Natasha needs to acquire data for a database from an Excel spreadsheet. She should use the ____________ group on the External Data Tab.

Answer 5

Import & Link

Question 6

Marianne is working with a database containing the names and addresses of people on her holiday card list. In order for Marianne to send this list to Word so she can create a mail merge, she should use the __________________ on the External Data Tab.

Answer 6

Export

Question 7

If you need to run a query, but are unsure of the spelling of a criterion, you can substitute characters with a(n) __________________ that can be used to represent one or more characters.

Answer 7

wildcard

Question 8

A(n) ______________________ is a mathematical symbol such as a multiplication or division sign.

Answer 8

operator

Question 9

Sarah is working in a database that stores information on residents in a nursing home. She needs to find all of the records for patients 70 years or older. Which of the following expressions should she use to specify the age?

Answer 9

70

Question 10

Matthew is working in a database that contains client information. He needs to determine which clients have not been assigned a sales representative. He could use the ____________________ expression to find records that have an empty sales representative field.

Answer 10

Is Null

Question 11

Which table view would you select if you wanted to define a table from start to finish?

Answer 11

Design view

Question 12

Users may enter, delete, or edit table records in the ______________________view.

Answer 12

Datasheet

Question 13

To modify the structure of a table, including creating or changing the fields of the table, you would use the _______________view.

Answer 13

Design

Question 14

A query’s search specifications can be edited on the _____________________ row in the query design view.

Answer 14

Criteria

Question 15

You can specify a data source for a query on the ______________ row in the query design view.

Answer 15

Table

Question 16

True or False Number data types in a query criterion do not require any delimiters.

Answer 16

True

Question 17

True or False An operand is the part of the expression that is being operated on in a query.

Answer 17

True

Question 18

True or False Table data can be edited in Design view.

Answer 18

False

Question 19

True or False When designing a table, data should be stored in the largest elements possible.

Answer 19

False

Question 20

True or False In a query, a Date/Time criterion must be enclosed with the pound sign delimiter.

Answer 20

True

Question 21

True or False If you require a series of queries that ask similar questions, it may be more efficient to create one query and then copy and edit it as needed.

Answer 21

True

Question 22

True or False The results of a query are referred to as a recordset.

Answer 22

True

Question 23

True or False You can create a query in Design view or by using the Query Wizard.

Answer 23

True

Question 24

True or False Multi-table queries are more difficult to design than Single-Table queries.

Answer 24

False

Question 25

True or False Once a multi-table query is created, you cannot add more tables to the query.

Answer 25

False