Question: This assignment will build on what you learned in M3 Wk2- Assignment by creating queries to access information from your database Instructions 1. If you

This assignment will build on what you learned in M3 Wk2- Assignment by creating queries to access information from your database Instructions 1. If you need to review, watch the l videos and Access Basics Part 1and Part 2 2. Make sure you've entered several records into each of the tables you created in Assignment 2. Just make up the data for the records it doesn't matter what you enter as long as it makes sense. You won't be able to see the results of your queries until you've entered records into the tables. 3. Complete the following online course: 4. Create and save the following queries in your database: o The employees that report to same supervisor o The license plates of the cars that are not assigned to an employee. o All customers that placed an order in October o The top selling product in October Turn-in Attach and submit your updated CustomerPhones.accb database file Turn-in Attach and submit your updated CustomerPhones.accdb database file M3 - Assignment 3 (1) Criteria Ratings Pts The customers that have a fax number The employees that report to person X. The license plates of the cars that are not assigned to an employee All customers that placed an order in October The top selling product in October 5.0 pts 5.0 pts 5.0 pts 5.0 pts 5.0 pts Total Points: 25.0 This assignment will build on what you learned in M3 Wk2- Assignment by creating queries to access information from your database Instructions 1. If you need to review, watch the l videos and Access Basics Part 1and Part 2 2. Make sure you've entered several records into each of the tables you created in Assignment 2. Just make up the data for the records it doesn't matter what you enter as long as it makes sense. You won't be able to see the results of your queries until you've entered records into the tables. 3. Complete the following online course: 4. Create and save the following queries in your database: o The employees that report to same supervisor o The license plates of the cars that are not assigned to an employee. o All customers that placed an order in October o The top selling product in October Turn-in Attach and submit your updated CustomerPhones.accb database file Turn-in Attach and submit your updated CustomerPhones.accdb database file M3 - Assignment 3 (1) Criteria Ratings Pts The customers that have a fax number The employees that report to person X. The license plates of the cars that are not assigned to an employee All customers that placed an order in October The top selling product in October 5.0 pts 5.0 pts 5.0 pts 5.0 pts 5.0 pts Total Points: 25.0
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
