Chapter 2 Questions and Answer Flashcards
Questions and Answer
Jenna needs to design a database for a clothing company. The first step Jenna should take is to determine what:
tables will be required.
__________________________ is the unnecessary duplication of data in two or more tables, and can lead to errors.
Data redundancy
When creating a multi-table query, which of the following statements is NOT correct?
All tables in the database should be included in the multi-table query.
Which of the following relationships can be used to describe a customer record that is linked to several order records?
One-to-many
Natasha needs to acquire data for a database from an Excel spreadsheet. She should use the ____________ group on the External Data Tab.
Import & Link
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.
Export
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.
wildcard
A(n) ______________________ is a mathematical symbol such as a multiplication or division sign.
operator
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?
70
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.
Is Null
Which table view would you select if you wanted to define a table from start to finish?
Design view
Users may enter, delete, or edit table records in the ______________________view.
Datasheet
To modify the structure of a table, including creating or changing the fields of the table, you would use the _______________view.
Design
A query’s search specifications can be edited on the _____________________ row in the query design view.
Criteria
You can specify a data source for a query on the ______________ row in the query design view.
Table
True or False Number data types in a query criterion do not require any delimiters.
True
True or False An operand is the part of the expression that is being operated on in a query.
True
True or False Table data can be edited in Design view.
False
True or False When designing a table, data should be stored in the largest elements possible.
False
True or False In a query, a Date/Time criterion must be enclosed with the pound sign delimiter.
True
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.
True
True or False The results of a query are referred to as a recordset.
True
True or False You can create a query in Design view or by using the Query Wizard.
True
True or False Multi-table queries are more difficult to design than Single-Table queries.
False
True or False Once a multi-table query is created, you cannot add more tables to the query.
False
