Querying a Database

Question 1

In query Design view, what does the asterisk represent?

Revolt · Accepted Answer

all fields

Question 2

3. Select the Simple Query Wizard, and click .

Revolt · Accepted Answer

OK

Question 3

4. In the Simple Query Wizard dialog box, select the tables to use, and use the to choose the fields to use in the query. Click Next.

Revolt · Accepted Answer

arrow buttons

Question 4

5. Name the query and click .

Revolt · Accepted Answer

Finish

Question 5

Where should the expression for calculating values in a query be input?

Revolt · Accepted Answer

in the first empty column of the query design grid

Question 6

What can queries provide that viewing a table in Datasheet view cannot provide?

Revolt · Accepted Answer

data from more than one table

Question 7

1. With the database open, click the tab.

Revolt · Accepted Answer

Create

Question 8

After selecting tables for the query in the Show Table dialog box, which options are available in query Design view? Check all that apply.renaming tablesediting data in the tableselecting fields to displaysetting criteria for filteringchoosing how to sort the recordsmoving data from one field to another

Revolt · Accepted Answer

selecting fields to display; setting criteria for filtering; choosing how to sort the records

Question 9

What are examples of logical operators in query filtering? Check all that apply.==><=ANDNOTOR

Revolt · Accepted Answer

AND; NOT; OR

Question 10

When multiple columns in a query are sorted simultaneously, which one will be the primary sort?

Revolt · Accepted Answer

the leftmost column

Querying a Database Answers

More from this Course

TRY EDGENUITY HACKS