This assignment will build on what you learned in M3 Wk2 - Assignment by creating queries to access information from your database. this is M3 Wk2 assignment and I need to create queries .

Instructions

If you need to review, watch the Introduction to Databases and Relational Model videos and Access Basics Part 1 (Links to an external site.)Links to an external site. and Part 2 (Links to an external site.)Links to an external site.. 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. Complete the following online course: Introduction to queries (Access Basics, Part 3, all 5 videos) (Links to an external site.)Links to an external site. Create and save the following queries in your database: The employees that report to same supervisor. 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.

Turn-in Attach and submit your updated CustomerPhones.accdb database file. Rubric M3 - Assignment 3 (1) M3 - Assignment 3 (1) Criteria Ratings Pts This criterion is linked to a Learning Outcome The customers that have a fax number. 5.0 pts This criterion is linked to a Learning Outcome The employees that report to person X. 5.0 pts This criterion is linked to a Learning Outcome The license plates of the cars that are not assigned to an employee 5.0 pts This criterion is linked to a Learning Outcome All customers that placed an order in October. 5.0 pts This criterion is linked to a Learning Outcome The top selling product in October 5.0 pts Total Points: 25.0 Previous Next

. INTL 10/26/201 Order Table design view: Table Tools Home Create External Deta Catabaue ToolsDsign New Totals 2 Selection Cut Copy Format Painter Speling Go To View Paste Toggle Fiterin Selet O pboard font RIch Text Sort & Piter All Tables Field Name Descri Orderld Customerto Customer : Table Employee: Table CompanyCM : Table Text Orders Table Products: Table l OrderDetails: Table Caption es INo Smat Teg Text Al gn The dela type determines the kind of values General that users can st ore in tn e field. Press F1 help on dets types Dezign view. F6 Swtch parnes F1- Help. ENG 210 AM INTL 102620 Products lable desian view: Table Tools Home Create Etrnal Deta Datsbese Tools Design Save Spelling Selet Oipboard Fomt Rich Text ort&Fiter All Tables Data Type Descrip Customer : Table Text tmployee: Table CompanyC:Table Order: Table Products: Table OrderDstails: Tabe ield Size Long integer Yes No rart tagu Texl Align & Tield name an be up to 64 characters long including spaces Press Fl tar help on tield Genera Design view. P6Swth Danes, Fl . Heto ENG 210 AM . INTL 10/26/201 Order Table design view: Table Tools Home Create External Deta Catabaue ToolsDsign New Totals 2 Selection Cut Copy Format Painter Speling Go To View Paste Toggle Fiterin Selet O pboard font RIch Text Sort & Piter All Tables Field Name Descri Orderld Customerto Customer : Table Employee: Table CompanyCM : Table Text Orders Table Products: Table l OrderDetails: Table Caption es INo Smat Teg Text Al gn The dela type determines the kind of values General that users can st ore in tn e field. Press F1 help on dets types Dezign view. F6 Swtch parnes F1- Help. ENG 210 AM INTL 102620 Products lable desian view: Table Tools Home Create Etrnal Deta Datsbese Tools Design Save Spelling Selet Oipboard Fomt Rich Text ort&Fiter All Tables Data Type Descrip Customer : Table Text tmployee: Table CompanyC:Table Order: Table Products: Table OrderDstails: Tabe ield Size Long integer Yes No rart tagu Texl Align & Tield name an be up to 64 characters long including spaces Press Fl tar help on tield Genera Design view. P6Swth Danes, Fl . Heto ENG 210 AM