✓ 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, click in order amount …