From the course: Office 365: Access Essential Training
Unlock the full course today
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Challenge: Creating reports - Microsoft Access Tutorial
From the course: Office 365: Access Essential Training
Challenge: Creating reports
- It's time for our fourth and final challenge. In the challenge start database in the chapter nine folder I've added a query called DailyCheckIns. This provides some details about the guests that are scheduled to check in today, tomorrow, and yesterday. I'd like you to create a format a report off of this data. Explore ways to group and sort the information so that it provides a quick summary of who's arriving at the Landon Hotel. And make sure that it's attractive and easy to read. I estimate that this challenge will take about 10 minutes. Have fun.
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
-
-
-
-
-
-
-
-
-
-
-
Introducing reports4m 19s
-
Using the Report Wizard4m 53s
-
Creating a report in Design view4m 38s
-
Editing a report in Layout view7m 51s
-
Grouping and sorting records7m 7s
-
Creating calculated totals3m 52s
-
Applying conditional formatting rules7m 36s
-
Creating labels5m 21s
-
Adjusting print settings4m 6s
-
Challenge: Creating reports33s
-
Solution: Creating reports5m 29s
-
-
-
-
-