CCNC/CCNC Module 5/Retrieving data with queries/Query Operations/Running Query

From WikiEducator
Jump to: navigation, search
Tutorial.png Query Operations 

Setting up the query | Running the Query | Saving, Opening and Deleting the Query | Self Assessment | Summary & FAQs


Running the new query

Icon objectives.jpg

Outcomes

Upon completion of this tutorial the learner will be able to:
  • Run a query in design view
  • Review the query results
  • Make query changes to achieve the desired results


The run query button

Figure 1. Run Query

When developing a new query in design mode it is useful to incrementally test that the query is providing the results required. To run the query in design mode Oo-dbms-Queries-Design4-run.jpg press the run query button.

Query results in design view

Figure 2. Query Results

After the query runs the results will be displyed in a split window above the two query design windows. To iteratively build the query, make changes to the design and run the query again. Keep making changes and running the query until it provides the results desired.

Test your knowledge



Icon qmark.gif

Searching...

 

1. Running a query in design mode will remove query design changes?

TRUE
Incorrect, running a query during design can assist in design and iterative changes will not be lost. Click here to review the topic.
FALSE
Absolutely Correct!

Your score is 0 / 0