Exam 7: Action and Specialized Queries

The Append query can create a table and add records to it at the same time.

Finding ________ values and knowing what to do with them remains one of the challenges of good database design.

The easiest way to create a crosstab query is to use the Crosstab Query ________.

The ________ query can add records from a spreadsheet to an existing table.

Of the four action queries,which one would help you track student grades over the past decade?

Of the four action queries,which one would help you find records that are the same after you appended an Excel spreadsheet of data into your table?

In a crosstab query,where do the values of a field selected as a column heading display?

Which action query would you use if you wanted to add records from another table?

In a Find duplicates query,it does not matter which table is chosen first.

The Make Table query is an example of a(n)________ query.

Running an update query from ________ view does not display the results in a datasheet like a select query does.

Which query would be helpful to locate students for whom no grades have been assigned during a semester?

When working with queries,viewing a query in Datasheet View is the same as running the query.

Which of the following is not a type of query in Access?

A(n)________ Table query can create a new table based on data in an existing table.

What does Access do to denote action queries differently in the Navigation Pane?

When you convert a Select query to an Append query,Access removes the Show row and adds a(n)________ To row in its place.

A(n)________ query removes records from a table.

Action queries make changes to the data in the underlying ________.