Building reports from queries


show more Building reports from queries 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 ...

Building reports from queries

Building a report off an existing query is probably the easiest way to get a great looking report that displays some fairly complex information from your database. By leveraging the power of queries, and feeding the results into the report's record source, you'll create a good foundation from which report design becomes just a matter of dragging-and-dropping fields into the appropriate locations. I've said this before about Access, but sometimes all of the wizards and automated object-creation features of the program can really get in the way and just make things more confusing than they really are. Once you understand what's going on behind-the-scenes, it's often the case that the hand-built from the ground up really is the way to go.

In this exercise, I've gone ahead and pre-built a query that totals up our customer's lifetime spent amount with the Two Trees Olive Oil Company. Let's go ahead and open up TotalSalesCustomers query. I'll double-click ...

Building reports from queries
Video duration: 6m 34s 3h 7m Intermediate

Viewers:

Building reports from queries 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 ...