Question: Need help with Access. Create the following Queries utilizing these two databases use the query naming convention provided in parentheses: o Customer ID , Customer
Need help with Access.
Create the following Queries utilizing these two databases use the query naming convention provided in parentheses: o Customer ID Customer Type Commercial or Residential Contract Type Swimming Pool or Landscaping Contract Number Query Name CustData o Customer ID Last Name, First Name, City, State, Work Phone Number Query Name CustContacts o Customer ID Contract Number, Contract Type Swimming Pool or Landscaping Contract Amount $ Contract Profitability Profit Generated $Query Name ContrTypeFinancials o Customer ID Customer Type Commercial or Landscaping Contract Amount $ Contract Profitability Profit Generated $Query name CustTypeFinancials o Customer ID Last Name, Customer Type Commercial or Residential Repeat Yes or no Referral Yes or NoQuery name CustHistory
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
