From the course: Access 2019: 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 2019: Forms and Reports
Build a report from a query
- [Narrator] 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 those results into the report's record source, you'll create a good foundation from which report design just becomes 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 automatic 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 hand-built from the ground up is really the way to go. For this exercise, I've gone ahead and prebuilt a query called Customer Lifetime Sales, let's open it up to take a look. Here we have a record for each customer in the company. We have their customer ID, first name, and last name, as well…
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 sort6m 48s
-
(Locked)
Understand report structure8m 13s
-
(Locked)
Build a report with the Wizard3m 32s
-
(Locked)
Explore the report wizard output4m 8s
-
(Locked)
Build a report from a query4m 54s
-
(Locked)
Format the report in Design view5m 42s
-
(Locked)
Apply conditional formatting rules3m
-
(Locked)
Advanced conditional formatting5m 10s
-
(Locked)
Create calculation fields5m 49s
-
(Locked)
Add a report header5m 5s
-
(Locked)
Segment dates into groups4m 31s
-
(Locked)
Format date header sections3m 42s
-
(Locked)
-
-