CCNC/CCNC Module 5/Retrieving data with queries/Query Operations/Self Assessment

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

Self Assessment

Icon objectives.jpg


Upon completion of this self assessment the learner will:
  • Design a new query
  • Add criteria to queries by using operators
  • Alter the fields (columns) presented in the query
  • Run the query
  • Save and reuse the query
  • Delete the query

Icon activity.jpg

Portfolio Activity

Use the query designer to create a new query;

  1. Open the query designer
  2. Add the table(s)
  3. Set the fields for the query
  4. Set at least one sort order for the query
  5. Set a criteria to reduce the query results
  6. Set an alias for more than one column name
  7. Run the query and confirm the results
  8. Save the query with a meaningful name
  9. Open the query
  10. Delete the query

Click here to view a sample query that meets these activity tasks,