IS 2010 Lecture 8: Access 3
Document Summary
Using simple query wizard- create tab, query wizard button, select simple query wizard. Click the drop down arrow on the next window and choose the first table you want to select data from. To add a field in the query, double click the field name in available fields list to add it to the selected fields list. To add fields from another table, click drop down arrow again and select the next table you want data from. Add fields you want to include again from the available fields list. Click next when you"ve added all the fields you want, choose detail or summary, detail is default. Click next and give the query a title. Creating a query in design view- create tab, query design button. Double click the name of each table you want to include, click the close button.