Create a Query in Design View with Criteria in Access 2010


show more Creating a query in Design view with criteria provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Essential Training show less
please wait ...

Creating a query in Design view with criteria

Creating Queries in Design View gives you complete power and flexibility in analyzing your data. Let's start with looking at the query that we already made. Right-click on the Sales Reps Phone List Query and choose Design View. The top part of the window is where you show your tables with their fields, and the bottom is the grid where you specify the fields you want to see. So here is our Sales Rep table, with all of its fields, and the grid below, with just the five fields we wanted to see. If it asks if you want to save the changes, say No. So let's take this a step further.

Let's make a Query to analyze our sales in Maryland. We would need to pull our Maryland customers and look at their orders. Here's how to do it. Click on the Create tab and then choose Query Design. We'll get a new blank Query. The first thing we need to do is add our tables to the query. Now when you're doing this, only add the tables that contain the fields that you need. If you add extra tab...

Creating a query in Design view with criteria
Video duration: 4m 18s 3h 30m Beginner

Viewers:

Creating a query in Design view with criteria provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Essential Training

please wait ...