Create: Query 1: Contact ID (All contacts), Type of contact, Last Name, First Na

Create:
Query 1: Contact ID (All contacts), Type of contact, Last Name, First Name, Company Name, (Query Name – ContList)
Query 2: Contact ID (All contacts), Type of Contact, Last Name, First Name, Type of Phone, Phone # (Query Name – ContPhone)
Query 3: Contact ID (Business contacts), Business or Service Provider Organization Name, Business or Service Provider type, Business Contact Person, Phone # (Query Name – BsnsContacts)
Query 4: Contact ID (Individuals only), Last Name, First Name, City of Residency, State of Residency, Type of Phone, Phone Number, Email Address (Query Name – IndivContacts)
Query 5: Contract ID (All Contacts), Last Name or Business Name, Phone Number, Email Address
You will be using each of these queries to create a report with all data elements included in the Query. Add a title to each Report, using an expansion of the Query name. So the title for Report 1 would be an expansion of ContList, or Contact List Report. Insert page numbers in the footer of each page of each report.
Report 1. Construct one report from the entire database. Save this report as “2016Business”
Report 2: Construct a report using Query 1 save this as Report “ContList”
Report 3: Construct a report using Query 2 save this as Report “ContPhone”
Report 4: Construct a report using Query 3 save this as Report “BsnsConacts”
Report 5: Construct a report using Query 4 save this as Report “IndivContacts”
Report 6: Construct a report using Query 5 save this as Report “ContactEmail”

Leave a Reply

Your email address will not be published. Required fields are marked *

Previous post READ CAREFULLY THE SUBMIT GUIDES AND FOLLOW THE DISSERTATION RESEARCH PAPER (DRP
Next post I am going to provide you with all the theories on this course and you need to c