From the course: Cert Prep: Access Expert - Microsoft Office Specialist for Office 2019 and Office 365
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
✓ Solution: Full-length practice exam
From the course: Cert Prep: Access Expert - Microsoft Office Specialist for Office 2019 and Office 365
✓ Solution: Full-length practice exam
(peppy music) - [Instructor] Welcome to the solution video for the final challenge. For this challenge, we used the 07_01 challenge exercise file and I challenged you to complete all of the tasks in 40 minutes or less. Let's get started. First, we'll save the database file as MyChallenge in the chapter seven folder. File, Save As. Navigate to wherever your files are saved. There we go, Enable Content, and task number two. Create a report from the Orders table. Include all fields. Group on Region and then on Priority. Sum the Sales Amount field. Name the report Total Sales. We're going to use the Report Wizard. We'll go to Create, Report Wizard, Orders table, we're including all fields, grouping on region. I'm just double-clicking on these to pop them in. Priority, summing on the Sales Amount, and the name will be Total Sales. Finish, perfect. Let's go back to our instructions. Change the title in the header…
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.