Creating Queries  «Prev  Next»

Creating Query in Design View - Exercise Result

You entered:
These are the steps you probably took to create the query shown here in Design view:
Creating Query in Design View
Creating Query in Design View

  1. Display the Queries view of the database window.
  2. Double-click the Create query in Design view option.
  3. Add the Hours and Projects tables to the query.
  4. Close the Show Table dialog box.
  5. Double-click the fields you need: Project Description from the Projects table, Date and Hours worked from the Hours table.
  6. View the query results by clicking the View button.
  7. Close the query. When Access asks you if you want to save it, choose Yes and name the query “Project Hours.”