From the course: Access 2016: Forms and Reports
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Build a report from a query
From the course: Access 2016: Forms and Reports
Build a report from a query
- [Voiceover] Building a report off of 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 make things more confusing than they really are. Once you understand what's going on behind the scenes, it's often the case that hand-built from the ground up really is the way to go. But, for this exercise, I've gone ahead and pre-built a query over here called Customer Lifetime Sales. This query adds up the customer's lifetime spend amount with the H Plus Four Company. Here, we have the customer's ID number, and their…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
(Locked)
Organize records with group and sort5m 8s
-
(Locked)
Understanding report structure7m 31s
-
(Locked)
Build a report with the wizard6m 49s
-
(Locked)
Build a report from a query3m 55s
-
(Locked)
Format the report in Design view5m 27s
-
(Locked)
Apply conditional formatting rules7m 13s
-
(Locked)
Create calculation fields4m 44s
-
(Locked)
Add a report header5m 7s
-
(Locked)
Segment data into groups5m 43s
-
(Locked)
Challenge: Create an employee report23s
-
(Locked)
Solution: Create an employee report3m 50s
-
(Locked)
-
-
-
-