Creating a query that utilizes multiple criteria for a arena is like building a filter for your query benefits. For example, should you have a desk that contains total addresses off your friends, you possibly can run a question that will present brief data for those who are in New York, or for those who are living in New York and also whose name starts with this letter "B".

1. Create a query in the usual way. With all the example given above, you would include the career fields "Surname" and "City". (View "How to Create a Uncomplicated Query in microsoft access 2007.")
2. From this access 2007 database screen, in Problem view, pick the query, next click on Design.
3. The query opens up in Design view. In the Surname field, click inside the Criteria text message box.
4. To hunt for friends as their name depends on "B," key in Like "B*" while in the Criteria word box. Push Enter.
5. In the standards text field for the Metropolis field, enter "New York." Press Get into.
6. Switch to Datasheet perspective. You will see a list of all close friends living in New york city whose brand begins with the particular letter "B".