Linking controls


show more Linking controls provides you with in-depth training on Business. Taught by Adam Wilbert as part of the Access 2010: Forms and Reports in Depth show less
please wait ...

Linking controls

Now that we have seen all of the controls that we have at our disposal when creating forms and reports. Let's bring this full circle and piece a couple of them together to control the chart that we created in last movie. So in the last movie we ended up with this chart here, I am going to double-click on it to open it, and we see that's a graph of Orders by Month. And right now it can see all of the data for my entire database, all the way from January 05 through July 2010. That data is coming from this query here; I'll double-click on the query to run it. This is the data that is getting fed into the chart. If I switch this query in to Design View using the button up here, Design View, I can see how the query was created.

Now what we can do in order to modify, with the data that gets put into the chart, is I can add a criteria here, for instance, I can select a date range. For instance, in this criteria under OrderDate, if I type in >1/1/2009, Enter. Now rerun the query, it g...

Linking controls
Video duration: 7m 41s 3h 7m Intermediate

Viewers:

Linking controls provides you with in-depth training on Business. Taught by Adam Wilbert as part of the Access 2010: Forms and Reports in Depth

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