Grader – Instructions Access 2019 Project Exp19_Access_Ch06_Capstone – Northwind Traders Sales Analysis 1.0 Project

Grader – Instructions Access 2019 Project

Exp19_Access_Ch06_Capstone – Northwind Traders Sales Analysis 1.0

Project Description:

Northwind Traders is a small international gourmet foods wholesaler. You will update the company’s database by increasing the price of all of the meat and poultry products. You will make a table for archiving older order information. You will also summarize quantities sold by category and identify customers who have no orders.


Steps to Perform:

Step

Instructions

Points Possible

1

Start Access. Open the downloaded Access file named
Exp19_Access_Ch6_Cap_Northwind. Grader has automatically added your last name to the beginning of the filename. Save the file to the location where you are storing your files.

0

2

Using a select query, you will identify all of the products with a category of meat or poultry, and then use an update query to increase the prices of the products.

Create a select query that includes the
CategoryID from the Categories table and the
UnitPrice and
ProductName fields from the Products table (in that order). Run the query and note the CategoryID for Meat/Poultry.

8

3

Add the appropriate CategoryID criterion to limit the query output to only Meat/Poultry. Convert the query to an update query. Update the UnitPrice for Meat/Poultry only by increasing it by 6 percent.

8

4

View the query in Datasheet view prior to running it to make sure you are updating the correct (four) records. Return to Design view and run the query. Save the query as
Update Meat/Poultry Prices. Close the query.

10

5

You will identify orders shipped during the first half of the year and create a new table in which to store them. You will then delete the orders from the current orders table.

Create a select query that identifies all of the orders shipped
Between 1/1/2020 and 3/31/2020. Include all fields from the Orders table.

9

6

Convert the select query to a make table query. Name the new table
Orders Archive. Run the query. Save the query as
Make Orders Archive Table. Close the query.

6

7

Make a copy of the
Make Orders Archive Table query and save it as
Append Orders Archive Table. Open the
Append Orders Archive Table query in Design view. Convert the make table query to an append query. The query will append to the Orders Archive table.

7

8

Modify the criteria to append orders shipped
Between 4/1/2020 and 6/30/2020. Run the query, save it, and then close it.

6

9

Open the
Orders Archive table in Design view and set
OrderID as the primary key field. Switch to Datasheet view, then save and close the table.

4

10

Make a copy of the
Append Orders Archive Table query and save it as
Delete Archived Orders. Open the
Delete Archived Orders query in Design view. Convert the append query to a delete query.

6

11

Modify the criteria to delete all archived orders from the Orders table (six records). Run, save, and then close the query.

6

12

You want to determine how sales are performing with respect to each product category. You will create a crosstab query that displays quantities by category and salesperson.

Open the Profit query in Design view and add the
LastName field from the Employees table to the last column of the design grid. Run, save, and close the query.

4

13

Use the query wizard to create a crosstab query based on the
Profit query that sums the total
Quantity by
Ship Country (row heading) and
CategoryName (column heading). Accept the query name as
Profit_Crosstab.

8

14

Modify the query to display
CategoryName as the row heading field and
LastName as the column heading field. Run, save, and close the query.

6

15

You will create a query to determine which customers have no matching orders. The customers will be contacted to determine if they would like to place an order.

Create a query to find out if any of the customers have no current order details. Add all of the fields from the Customers table to the results. Save the query as
Customers With No Orders. Run the query and close it.

12

16

Close all database objects. Close the database and then exit Access. Submit the database as directed.

0

Total Points

100

Created On: 09/12/2019 1 Exp19_Access_Ch06_Capstone – Northwind Traders Sales Analysis 1.0

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

 This week, explore the relationship between strategic goals and alignment with projects and best practices from the five process groups, especially

 This week, explore the relationship between strategic goals and alignment with projects and best practices from the five process groups, especially focusing on executing, monitoring, and controlling projects. This assessment is the first component of your course project.   In this assessment, you will write a topic definition statement for your

  For this discussion, compare and contrast the characteristics of quantitative and qualitative research, addressing the philosophical assumptions of

  For this discussion, compare and contrast the characteristics of quantitative and qualitative research, addressing the philosophical assumptions of both. Based on your review of the assigned readings, identify and describe what you believe to be meaningful about the qualitative research design and methodology. Define and describe the context in

  this week, explore scholarly literature on critical success factors and project management success. Specifically, focus on complex projects and their

  this week, explore scholarly literature on critical success factors and project management success. Specifically, focus on complex projects and their success or failures, which may include tools, templates, processes, procedures, and metrics, and their relationship to the five process groups: initiating, planning, executing, monitoring and controlling, and closing. Post

IT 226 Project Two Guidelines and Rubric Competency In this project, you will demonstrate your mastery of the following competencies: ·

IT 226 Project Two Guidelines and Rubric Competency In this project, you will demonstrate your mastery of the following competencies: · Determine appropriate ways to communicate information to internal and external stakeholders · Apply communication techniques to effectively negotiate and manage conflict Scenario You are the manager of a team of 10 software developers working on a new application for your company, Optimum Way Development, which is based out of Raleigh, North Carolina. Your organization recently acquired a smaller software company based in San Jose, California. You have been informed that your team will be bringing on five people from this newly acquired company; all five people will be moving to Raleigh to join your team. You schedule a phone call with the five new team members and discover that they are upset about the recent impersonal message they received from human resources informing them that they would have to relocate to Raleigh in order to stay employed; no one expressed excitement about joining the team. During this conversation, you also discover that many of the new team members have more education and experience than the people currently on your team. Based on the conversation, you notice that most of these team members are likely older than you, whereas all of the current Raleigh team members are younger than you. After the call, one of your current senior team members approaches you about rumors that are circulating concerning the Raleigh team being required to train the new team members from San Jose. They heard that there are plans to eliminate positions and are concerned the new hires will ultimately be taking their positions. The director who oversees your division has requested that you create and present a recommendation report that documents your plans for managing the conflicts that currently exist or may arise on your team. The director has an advanced degree in a computer science-related field and has worked in technology for over a decade. Directions In order to identify and resolve existing and future conflicts, you have been asked to compose and present your plan for managing conflict for this project. In addition to identifying and resolving the conflicts, you are also responsible for keeping the development of the new application moving forward by continuing to meet scheduled milestones. To do this, you will create a recommendation report and corresponding presentation. The audience for both deliverables is your director. As you create your report and presentation, remember to  use communication techniques and platforms that are appropriate for your audience’s preferences and motivations. Both deliverables should be based on the above scenario and include the following: 1. To start,  explain the major elements of the software application, including background, audience, functions, and features. 2. Next,  explain the areas of conflict for the team. Make sure to include contributing factors and the possible impacts. 3. Articulate the desired outcome of any conflict resolution activities. · How would you like to see this conflict resolved? · What is the “best-case” scenario? 4. Recommend action steps for managing areas of possible conflict with a detailed explanation on how the action steps contribute to conflict resolution. 5. In the presentation only,  use dialogue to communicate the appropriate main ideas to the audience. Although you will not give this presentation over video, you should use the speaker’s notes section in PowerPoint to write the accompanying speech. What to Submit To complete this project, you must submit the following: Recommendation Report Your report should be at least 2 full pages in length (not including a title page), single-spaced and submitted as either a Word document or PDF. Outside resources are not required, but any resources used must be appropriately cited using APA style. You may use the  Recommendation Report Template Word Document for this submission. Presentation Your presentation should be in a presentation format (such as PowerPoint) and  provide an overview of the main ideas from the recommendation report. Using the speaker’s notes section of PowerPoint, include the speech that would accompany the presentation. Outside resources are not required, but any resources used must be appropriately cited using APA style. Supporting Materials The following resource(s) may help support your work on the project: Resource:  Software Design Documents Use one of these software design documents to summarize the application in your report and presentation. Shapiro Library Resource:  Shapiro Library APA Style Guide This Shapiro Library guide goes over the basics of APA-style formatting and citations.

STUDENT COVER SHEET- Student and Trainer/Trainer Details

STUDENT COVER SHEET- Student and Trainer/Trainer Details Student ID Student name Contact number Email address Trainer name Jason Chu Course and Unit Details Course code ICT50118/ICT60115 Course name Diploma/Advanced Diploma of IT Unit code ICTICT608 Unit name Interact with a client on a business level Assessment Title Assessment 1 –