CSCI A114 / INFO I111
Takehome Quiz Two

First semester 2000-2001

Due date
September 14, at the end of the lecture.
Late policy
No late policy. Please turn this on time.
Work policy
Working in groups is accepted but you need to turn in your own version of the assignment.
Task
Print this page, write your answers to the questions on the page, as on an exam, and turn the page with your answers to Adrian. The answers need not be long, but they need to convey the essence.
Grading
Feedback will be provided within a week. Grades will be posted on-line.

Questions:

  1. What is the purpose of queries?

  2. How do you create a new query?

  3. How do you use a query to display all records and all fields?

  4. How do you run a query?

  5. How do you print the answer to a query?

  6. How do you see the SQL version of the query?

  7. What is QBE?

  8. What is QCM?

  9. What is SQL?

  10. How do you close a query?

  11. How do you clear a query?

  12. How do you use a query to display selected fields?

  13. How do you use text data in criteria in a query?

  14. How do you use wildcards in criteria, and for what purpose?

  15. How do you use numeric data in criteria?

  16. How do you use comparison operators?

  17. How do you use compound criteria involving AND?

  18. How do you use compound criteria involving OR?

  19. How do you sort the answer to a query?

  20. How do you join tables in a query?

  21. How do you restrict the records in a join?

  22. How do you use calculated fields in a query?

  23. How do you calculate statistics in a query?

  24. How do you use grouping with statistics?

  25. How do you save a query?

  26. How do you use a saved query?

  27. Express queries One, Two, Three, and Four in plain English (in the same way as the other eight have been formulated in assignment #2).

Last updated: September 6, 2000 by Adrian German for A114/I111