From the course: Cert Prep: Access 2016 Microsoft Office Specialist (77-730)
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
✓ Solution: Create reports
From the course: Cert Prep: Access 2016 Microsoft Office Specialist (77-730)
✓ Solution: Create reports
- [Instructor] Welcome to the solution video for the chapter 6 challenge. For this challenge, we use the 06 05 challenge database and I challenged you to complete all the tasks in under seven minutes. Let's get started. Our first task is to save the file as my 06 05 challenge in the chapter 6 folder. File and save as. I know you know this routine by now. I'll just remind you to always remove that one at the end of the file name. Enable your content and we can mark number one as done. Next, we're going to create a report based on the employees table. Include department name and title. We're going to group by department and sort by name. We really should use the wizard for this. And I'll go ahead and select department name and title. We go ahead and group by department, sort by name. We'll accept all other defaults, except we will name it department list. Click finish and we'll close the report. Mark number two as done. Task number three, create a report based on the 2013 to 2016 sales…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.