Building the query


show more Building the query provides you with in-depth training on Business. Taught by Adam Wilbert as part of the Access 2010: Queries in Depth show less
please wait ...

Building the query

The next step in creating our reporting tool is to construct the query. I'll go up to the Create menu and I'll create a new query in Design view. Let's add the tables that we're going to need. First, I'm going to choose my Orders table. This will give us information about the OrderDate. I'll choose my Products table. This will give me information about the product's price that will aggregate over the year. I also need information for my States table, but in order to get there I need to have a link. We'll go to DirectCustomers. That will give us the customer that ordered it and the state it went to, and then we can go to States, which will give us the states from the Customers table.

Let's go ahead and close the Show Table window and I'll rearrange these just a little bit here. Move my customer over here and expand it. Okay, so now we can see the relationships between the four tables in our query. I got my Orders table, from which we'll extract th...

Building the query
Video duration: 5m 4s 3h 2m Intermediate

Viewers:

Building the query provides you with in-depth training on Business. Taught by Adam Wilbert as part of the Access 2010: Queries in Depth

Subject:
Business
Software:
Access
Author:
please wait ...