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.
Format the report in Design view
From the course: Access 2016: Forms and Reports
Format the report in Design view
- [Voiceover] So already we can see that we've got a fairly clean and legible report going on here. At this point the functionality is there and working fine it's just time to start taking a look at some of the refinements that we can make. One of the things that I want to do is make my report wider to take full advantage of the piece of paper that it's gonna get printed on. Then, I want to remove the boxes from all the different data fields. I want to sort the data descending based off of the lifetime sales within each state and then I also want to change these field headers to be a little bit more legible across the top. Finally, if I scroll through my report we'll see that Alabama is here and we have all the details for Alabama. Then if I scroll down we'll find Alaska and we'll see the Alaska has a different color bar, it's this grey color. Whereas Alabama and we can see Arizona is white. I want to get rid of this alternating color scheme for the state names so that they're all…
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)
-
-
-
-