Question: Hello, may I get the syntax for the following questions? Thank you! Select the invoice number, customer code, customer last name, customer first name, and

Hello, may I get the syntax for the following questions? Thank you!
- Select the invoice number, customer code, customer last name, customer first name, and invoice date from the appropriate tables (using the appropriate SQL join keyword), ordering the results by invoice number.
- Update the database so that:
- The customer incorrectly named Dunne is named Dipplehoffer.
- All invoice dates reflect the year 2018. Note: Date values are handled differently than numeric (100) or string (Ralph) values. For help with the date format in Microsoft Access, read Create and run an update query from Microsoft.
- Select the invoice number, customer code, customer last name, customer first name, and invoice date from the appropriate tables (using the appropriate SQL join keyword), ordering the results by customer last name. (Take a screenshot of your results. Name your screenshot)
- Update the database so that:
- The customer incorrectly named Dunne is named Dipplehoffer.
- All invoice dates reflect the year 2018. Note: Date values are handled differently than numeric (100) or string (Ralph) values. For help with the date format in Microsoft Access, read Create and run an update query from Microsoft.
- Select the invoice number, customer code, customer last name, customer first name, and invoice date from the appropriate tables (using the appropriate SQL join keyword), ordering the results by customer last name.(Take a screenshot of your results. Name your screenshot)
External Data Database Tools Help Fields Table Tell me what you want to do - X CUS_INITIAL, , CUSTOMER CUS_CODE, CUS_LNAME, 10010 Ramas 10011 Dunne 10012 Smith 10013 Olowski 10014 Orlando 10015 O'Brian 10016 Brown 10017 Williams 10018 Farriss 10019 Smith CUS_FNAME, Alfred Leona Kathy Paul Myron Amy James George Anne Olette CUS_AREACODE, CUS_PHONE, 615 844-2573 713 894-1238 615 894-2285 615 894-2180 615 222-1672 713 442-3381 615 297-1228 615 290-2556 713 382-7185 615 297-3809 CUS_BALANCE , Click to Add 0.00 0.00 345.86 536.75 0.00 0.00 221.19 768.93 216.55 0.00 0.00 + K File Home Create All Access Objects Tables 3 CUSTOMER EMP 3 EMPLOYEE INVOICE E LINE 3 PART PRODUCT PRODUCT_2 PRODUCT_3 PRODUCT_initial PRODUCT_revised VENDOR Queries O! gryMake-PART-Table gryFig7-04 gryFig7-06 gryFig7-07 gryFig7-08 gryFig7-09 gryFig7-10 3 INVOICE - X INV_NUMBER - CUS_CODE - 1001 10014 1002 10011 1003 10012 1004 10011 1005 10018 1006 10014 1007 10015 1008 10011 0 0 INV_DATE - Click to Add 16-Jan-16 16-Jan-16 16-Jan-16 17-Jan-16 17-Jan-16 17-Jan-16 17-Jan-16 17-Jan-16
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
