Week 3 (Creating Queries)

      Queries are the primary mechanism for retrieving information from a database and consist of questions presented to the database in a predefined format. It is a fundamental means of accessing and displaying data from tables. I've learned that we can create a query by using either the Query Design or the Query Wizard.

      To create a new query, click on the Create tab and then        click on the query wizard button.



When the Query wizard appears, highlight the Simple Query Wizard selection and click OK.







       I've learned that to start creating a Simple Query wizard, we should specify the table for the query and which fields would be displayed. Fill in the Selected Fields by just simply clicking on the right arrow button. Finally, give a name for the new query and click on Finish button.
       I've also learned that the Query Design View has two major sections. In the top section, the tables used for the query are displayed along with the available fields. In the bottom section, those fields that have been selected for use in the query are displayed. For us to Run the query, just simple click on the Run button with the large red exclamation point then save and close the query.