From the course: Cert Prep: Access 2016 Microsoft Office Specialist (77-730)

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

✓ Solution: Create queries

✓ Solution: Create queries

From the course: Cert Prep: Access 2016 Microsoft Office Specialist (77-730)

Start my 1-month free trial

✓ Solution: Create queries

“

- [Narrator] Welcome to the solution video for the Chapter 4 challenge. For this challenge, we used the 04_07 Challenge database, and I challenged you to complete all the tasks in seven minutes or less. Let's go ahead and get started. As always, our first task is to save the database as my 04_07 Challenge right back into the Chapter 4 folder. File, Save As, Chapter 4 looks good, let's get rid of the 1 after the word Challenge, and we'll type My in front of the document title and click Save. Enable our content, and mark number one as done. Next task, use the 2016 Orders table to create a Query named Q1 Customer Orders that displays the following fields. Let's go ahead and go to Create. Let's use our Query Wizard, Simple Query. I'll move this down. 2016 Orders table, we're looking for the Customer dield, OrderID, and OrderDate. I'll go ahead and click Next and Next, and we are going to name our table Q1 Customer Orders. It says running the Query is optional, so if you see this on the…

Contents