From the course: Cert Prep: Access Expert - Microsoft Office Specialist for Office 2019 and Office 365
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 Expert - Microsoft Office Specialist for Office 2019 and Office 365
✓ Solution: Create queries
(upbeat music) - [Instructor] Welcome to the solution video for the chapter four challenge. For this challenge we used the 04 06 challenge exercise file and I challenged you to complete all the tasks in eight minutes or less, let's jump right in. First we'll save the database as my challenge in the chapter four folder, file, save as, navigate to the desktop where my files are saved, change the name, and save. We'll enable that content and move on to task number two. Query the 2018 Orders table to display customer, order ID, order amount and order date, accept all defaults and run the query. Let's go to create query design, double click on the 2018 Orders table to add it to the query grid. We are bringing in customer, order ID, order amount, order date. We're going to run the query, and we will save the information change the order amount field format field to currency with two decimal places. Let's go into design view…
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.