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

Which of the following statements is TRUE about data types and delimiters?

The ________ group on the External Data tab has options that you can use to send a portion of a database to other applications.

Access requires a primary key for every table.

________ tables are tables that are joined from one table to another through a common field.

It is more efficient to copy and use an existing query for a new query when:

When designing a database,an important guideline is to store data in their largest parts.

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

When you add two or more tables to a query,you must manually create new join lines.

Explain the NOT logical operator and provide one example.

Sarah is working in a database that stores resort vacation information.She needs to design a field that will allow a user to link to a Web page.Sarah should apply a(n)________ type.

What are the three ways to run a query?

Fields can be renamed either in Design view or in Datasheet view.

How do you launch the Query Wizard and what is the first step of the wizard?

A(n)________ query is a type of query that displays only the records that match criteria that you enter in Query Design view.

Describe how sort order in an Access table is determined.

Which statement accurately describes the function of a query?

A(n)________ verifies data entered into a field and ensures that the data is of the correct type for the field.

________ are displayed in the Relationships window to establish a relationship between two tables.