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


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



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

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

Your score is 0 / 0