How Do You Use Microsoft Access Query?
Of all the applications in the Microsoft Office suite, Access may be the most intimidating. Once you learn the basics of building a database, creating forms and reports, and the power of a good query, you will appreciate all that Access has to offer. Creating an Access query comes down to using the proper language. The Access Query Wizard can help you learn how to make and use queries to retrieve the data you need. Start Access. Open the database in which you want to use a query by going to the “File” menu and selecting “Open” in Access 2000-2003, or by clicking the “Office Button” in Access 2007 and clicking “New.” Select the desired database and click “Open.” Click “Queries” in the Objects pane of Access 2000-2003. Double-click “Create Query by Using Wizard. In Access 2007, go to the “Create” tab and click “Query Wizard.” Click “Simple Query Wizard” and “OK,” and then the Query Wizard will start. Select the table to be queried in the “Tables/Queries” drop-down list. Double-click item
