MS+Access+Query

Created by: Patty Martin =Microsoft Access = Creating a Query ** A Query is an Access object for storing questions that you ask about information in a table **  Create query in the query Design View window.  1. Click query tab  2. click new  3. click “simple query wizard”  4. In simple query wizard, use drop down menu to find the table or query you would like to get your information from  5. from the “available fields” box select the fields you want listed for your query  6. move these fields to the “selected fields” box  7. click next and give query a name <span style="font-size: 18pt; mso-bidi-font-weight: bold; mso-bidi-font-style: italic; mso-bidi-font-size: 10.0pt;"> 8. <span style="font-size: 18pt; mso-bidi-font-weight: bold; mso-bidi-font-style: italic; mso-bidi-font-size: 10.0pt;">click finish <span style="font-size: 18pt; mso-bidi-font-weight: bold; mso-bidi-font-style: italic; mso-bidi-font-size: 10.0pt;"> 9. <span style="font-size: 18pt; mso-bidi-font-weight: bold; mso-bidi-font-style: italic; mso-bidi-font-size: 10.0pt;">(in “design view” you can type a criteria in quotes.) // for example in status field type “fulltime” in quotes in criteria row. Your query will only pull up records with “fulltime” typed in status field. // //  Note: any changes made in table will effect query and any changes made in query will effect table. //