For this assessment, you will develop an 8–14 slide PowerPoint presentation with thorough speaker's notes designed for a hypothetical in-service session related to the improvement plan you developed in Assessment 2.

Before starting this assignment, you will want to watch the four videos in the Reading & Resources section under Content in week 5.

$ 77.33

Before starting this assignment, you will want to watch the four videos in the Reading & Resources section under Content in week 5. This week you will be using the “Contacts” database you created in Week 2 and the Queries you added in week 3 to create reports in Access. Please note that this assignment does not use the Excel databases you downloaded in week 1 and then used for your midterm exam in week 4. Complete instructions are listed below for what reports you will create in Access. If you have taken good notes on how to create simple reports using the “Report wizard,” you should have no problems with these reports.

Order Now
Category:
Order This Paper

Description

Assignment Prompt:

Before starting this assignment, you will want to watch the four videos in the Reading & Resources section under Content in week 5. This week you will be using the “Contacts” database you created in Week 2 and the Queries you added in week 3 to create reports in Access. Please note that this assignment does not use the Excel databases you downloaded in week 1 and then used for your midterm exam in week 4. Complete instructions are listed below for what reports you will create in Access. If you have taken good notes on how to create simple reports using the “Report wizard,” you should have no problems with these reports.

Previous Work:
The queries you created in week 3 are as follows:

  • 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
Note: Full answer to this question is available after purchase.
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

    • Assignment Instructions:

    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

    Read; Your midterm Exam consists of using Microsoft Access to create Queries in a database you will import from an Excel file.

    Order This Paper

    Reviews

    There are no reviews yet.

    Be the first to review “Before starting this assignment, you will want to watch the four videos in the Reading & Resources section under Content in week 5.”

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

    Related products

    error: Content is protected !!