Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
Can someone please help me with this access homework, it's all on queries Go to EMPLOYEES UND HERE menfu : Koli Cewe overies based on
Can someone please help me with this access homework, it's all on queries
Go to EMPLOYEES UND HERE menfu : Koli Cewe overies based on detail provided below 5 50.00 - 7 CD . Total of Tot - 2 51,500. $8,.00 $55.00 - 50. $5,000.00 SS QueryProvide the last name and First Name of Customers who never made purch $5.00 Answer wil look similar to but may not be exactly the same as the following in Customers without acting SALES Name Name - Qeyd: Orders with Transaction, Fame of customer), L e of customer) and total and Ta you will have to use two tables). Taxis a calculated field calculated as 6,5% of total Query 1 Custom query: Use Customers table. Combine FirstName and lastname together. Make su there is between the first and last names Aswer wilcok similar to but in the same as the folosing inge! Anwer wil bosimilar to but may not be cactly the same as the following image! Singh | Why Pune Michacl Query's Transcam I) - FName LO2 Artur 7 O EGOERE Lamp - Gratatos Solsol Gratacos Solso Gratacos Solso $85.75 $32.50 Total - 50.00 $500.00 $450.00 $9.000.00 $S65. SS.on Alexander Ergere S520.00 15.118 Befred Tham Lucian Mathew Query: Last name, First Name of Customers whose job title is Owner and state is from TX or CA Jonas Luka ohn John [The states and job Lite do not have to be shown on the queryl s ed nn transaction D Get all columns of table Answer willicck similar to - but may not be cact the same as the following image Query 5: Create a parameter query To La sales caren loh Roger Smith I ner will lock similar to. but may not be exactly the same as the folowing image 2 X Enter Parameter Value -D Query. Find as count. a number of customers from each state. The number of customer should be labeled Card Answer will look similar to but may not be exactly the same as the following image) Query 3: All the Customers' firstrume, lastname with lastmes containing T. Query: Crosstab query: Customersin. Employeel,Sum of Total Answer wil lock similar to - but may not be exactly the same as the following image! Answer wil bak similar to - but mayrol be exactly the same as the following image)Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started