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-

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!