Querying a Database

Question 1

Which tab can help start a query?

Revolt · Accepted Answer

Create

Question 2

What are the steps for modifying a query to add calculations? Use the drop-down menus to complete them.

Revolt · Accepted Answer

1. Open the query in view.: Design; 3. Right-click and select in the drop-down menu.: Build; 4. Using the Expression Builder, add to create a calculation.: expressions; 5. Click to see the results of the query.: Run

Question 3

✔ BuildPasteTableZoom

Revolt · Accepted Answer

✔ Build

Question 4

✔ expressionsrecordstablestemplates

Revolt · Accepted Answer

✔ expressions

Question 5

CreateGoOK✔ Run

Revolt · Accepted Answer

✔ Run

Question 6

Which methods can be used to run a query? Check all that apply.On the Create tab, in the Queries group, click Run.In query Design view, on the Design tab, click Run.Switch to Datasheet view before any other commands.Close the Show Table dialog box in the Datasheet view.On the Create tab, in the Queries group, click Create Query.

Revolt · Accepted Answer

In query Design view, on the Design tab, click Run.; Switch to Datasheet view before any other commands.

Question 7

What is query filtering most useful for?

Revolt · Accepted Answer

reviewing only the results that meet specific criteria

Question 8

After data is updated in a table, when will the query using that data be updated to reflect the change?

Revolt · Accepted Answer

when the query is next run

Question 9

What is a rule of solid database design regarding calculated values?

Revolt · Accepted Answer

They should not be stored in a database.

Question 10

What are the steps for modifying a query to add calculations? Use the drop-down menus to complete them.

Revolt · Accepted Answer

✔ Design; 1. Open the query in view.: Design; 3. Right-click and select in the drop-down menu.: Build; 4. Using the Expression Builder, add to create a calculation.: expressions; 5. Click to see the results of the query.: Run

Querying a Database Answers

More from this Course

TRY EDGENUITY HACKS