Access is a Microsoft technology database program. It's used in desktop-type workplace environments, and files also can be used in simple web applications. It can even be used as an interface with massive-scale web applications. Access allows you to manage large amounts of data, such as customer lists, and query and sort that data. Using multiple items in a query works the same way in all of these applications. This "how-to" covers Microsoft Access 2002. The concepts are the same, though, throughout the versions.
Instructions
- 1
Open the Access database in Access.
2Select the table you want to work with by highlighting it and double-clicking on it. The table will open up on your screen. Take a look at the fields that may be appropriate for your query.
3Close the table and choose the "Queries" object. Select "Create query by using a wizard." The wizard will ask you which fields you'd like in your query. There will be a list of the available fields or the "multiple items," as the title of this article refers to them. Check that you're in the table you want, and highlight the first field you want to add. Press the ">" button, and the first field will appear in the Selected Field list. Go through the available fields and select the ones you want.
4Click "Next." The wizard will ask you if you want a detail or summary query. "Summary" means you want the query to perform calculations such as minimums and maximums. For simplicity's sake here, choose "Detail."
5Click "Next." The wizard will ask you to title your query; the default displayed there is good form to use.
6Check the "Open the Query" radio button. You can also mark the "Help" check box if you need more help working with queries at this point.
7Click "Finish."
