


Select all, click Add, then click Close: The Show Table dialog allows you to choose which tables to include in the query. You could also use the Query Wizard button next to it to launch the Query Wizard, however, Design view gives you more control over the query.Īccess will ask you to select the tables to include in the query. Click the Query Design button to create a query in Design view. OK, so now that we have data, we can create the query.Ĭlick the Query Design button from the Ribbon.

Simply open it from the database and it’s ready to go. So no need to rebuild the same queries over and over again. Queries can also be saved to the database. But it’s not just any old search.Ī query allows you to specify exactly which fields you want returned, and from which tables.Ī query also lets you add criteria for filtering the data. So for example, you could specify that you only want to see orders worth more than $100, or only products of a particular brand, or only customers who have only ever purchased one item, etc. Queries allow you to “search the database”.

Create a macro (so that a multi-step task can be done automatically – at the click of a button).Create a query (so you can “search the database”).This article is Part 3 of the Microsoft Access tutorial.
