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
From the course: Cert Prep: Access 2016 Microsoft Office Specialist (77-730)
✓ 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…
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)
Create and run a query6m 9s
-
(Locked)
Create a crosstab query3m 37s
-
(Locked)
Create an action query3m 6s
-
(Locked)
Create a parameter query4m 1s
-
(Locked)
Modify a query4m 43s
-
(Locked)
Create calculated fields and grouping within queries4m 39s
-
(Locked)
✓ Challenge: Create queries23s
-
(Locked)
✓ Solution: Create queries8m 47s
-
(Locked)
-
-
-
-