Answered step by step
Verified Expert Solution
Link Copied!

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 queriesimage text in transcribed

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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions