Querying a Database Answers

5 verified answers
1
Free Preview

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

A
the ability to edit data
B
filtered data from a table
C
a view with rows and columns
D
data from more than one table
149968
Free Preview

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

Answers:
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
149969

CreateX EnterFinish✔ OK

A
Create
B
X Enter
C
Finish
D
✔ OK
149970

check boxesrow selectors✔ arrow buttonsdrag-and-drop tool

A
check boxes
B
row selectors
C
✔ arrow buttons
D
drag-and-drop tool
149971

CreateEnter✔ FinishX OK

A
Create
B
Enter
C
✔ Finish
D
X OK

Did you find these answers helpful?

Querying a Database Answers — TX-Business…