Exam 31: Access: Tables and Queries in Relational Databases: Designing Databases and Extracting Data

Multitable queries take advantage of table relationships in a database.

A(n)________ relationship requires a table called a junction table.

The ________ Wizard guides you through the query design process in Access.

Which of the following is NOT a guideline for adding fields to a database table?

You use the ________ view to create queries.

In field names,object names,and filenames,uppercase letters are used to distinguish the first letter of a new word in ________ notation.

If a worksheet in an Excel workbook was named,Access uses the worksheet name as the database name.

________ is the value used to describe a blank field in an Access table.

Data redundancy may result in errors.

Which field property type should be used to enter a predefined value into a field when most of the records will have the same value?

Jose is working on a database that stores stock information.He needs to design a field that will allow a user to connect to a graph created in Excel.Jose should apply a(n)________ data type.

Where do you change the order of query fields to change the order of query results?

Which of the following is FALSE about changes in multitable queries?

Spaces should be included in field names.

A one-to-many relationship is established when the foreign key in the first table matches multiple primary key values in the second table.

An unchanging value is called a(n)________.

If you want to modify a saved query,open the query in ________ view.

In a query,which of the following statements is TRUE regarding delimiters in the criterion of a field?