Querying a Database

Question 1

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

Revolt · Accepted Answer

data from more than one table

Question 2

What are the steps to creating a query with the Simple Query Wizard? Use the drop-down menus to complete them.

Revolt · Accepted Answer

✔ Create; 1. With the database open, click the tab.: Create; 3. Select the Simple Query Wizard, and click .: OK; 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.: arrow buttons; 5. Name the query and click .: Finish

Question 3

CreateX EnterFinish✔ OK

Revolt · Accepted Answer

✔ OK

Question 4

check boxesrow selectors✔ arrow buttonsdrag-and-drop tool

Revolt · Accepted Answer

✔ arrow buttons

Question 5

CreateEnter✔ FinishX OK

Revolt · Accepted Answer

✔ Finish

Question 6

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 7

In query Design view, what does the asterisk represent?

Revolt · Accepted Answer

all fields

Question 8

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

Revolt · Accepted Answer

AND; NOT; OR

Question 9

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

Revolt · Accepted Answer

the leftmost column

Question 10

Which terms would be found in search for "Mo*”? Check all that apply.MarcometroMommoneymonkeymore

Revolt · Accepted Answer

Mom; money; monkey; more

Querying a Database Answers

More from this Course

TRY EDGENUITY HACKS