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.

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

$ 66.45

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

Order Now
Category:
Order This Paper

Description

Prompt:

Your midterm Exam consists of using Microsoft Access to create Queries in a database you will import from an Excel file. The attached (below) file labeled “Statewide Landscape” contains data from all contracts completed by Statewide during 2016. Start by downloading the Excel File (attached below), import it into Access, then, create the five Queries listed below using the Access Wizard. These queries will use both databases included in the Excel Workbook File; the Customer_Contact Type table on Tab 1 and the Customer ID Database on Tab 2. Use the following steps to get started:

1. Import both databases from Excel into Access. A video presentation is provided in the Lessons Tab under week 4 to help you learn how to import Excel files. Save these files as “Contactype” and “CustID” You

Note: Full answer to this question is available after purchase.
should recognize the data from the first week’s assignment.
2. Create the following Queries utilizing these two databases use the query naming convention provided in parentheses:

  1. Customer ID, Customer Type (Commercial or Residential), Contract Type(Swimming Pool or Landscaping), Contract Number (Query Name- CustData)
  2. Customer ID, Last Name, First Name, City, State, Work Phone Number (Query Name – CustContacts)
  3. Customer ID, Contract Number, Contract Type (Swimming Pool or Landscaping), Contract Amount ($), Contract Profitability (%), Profit Generated ($) (Query Name – ContrTypeFinancials)
  4. Customer ID, Customer Type (Commercial or Landscaping), Contract Amount ($), Contract Profitability (%), Profit Generated ($) (Query name – CustTypeFinancials)
  5. Customer ID, Last Name, Customer Type (Commercial or Residential), Repeat (Yes or no), Referral (Yes or No) (Query name – 2016CustHistory)

Read; BUSN 311 Week 4 Assignment Instructions

Order This Paper

Reviews

There are no reviews yet.

Be the first to review “BUSN 311 Your midterm Exam consists of using Microsoft Access to create Queries in a database you will import from an Excel file.”

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

Related products

error: Content is protected !!