Create appropriate worksheets and upload to access database

Assignment Help Database Management System
Reference no: EM13993577

Your new boss, who is the vice president in charge of marketing at a multinational hardware/services corporation, has asked you to help her understand the current state of the company. She has sent you a file (attached), to help her understand the current state of the company.

Part 1:

Access

a. Based on the excel data file (attached) create the appropriate worksheets and upload to access database. The goal is to improve the data integrity and follow the rules for the three normal forms.

b. Create appropriate relationships. Create and run a query.

c. Create one form for one of your worksheets

d. Save the access data base.

Part 2:

Using the 5 step data exploration process, explore the data set. Discuss the data set, explore it, define the task and present your results.
Your results should be in the form that you can present to your boss to better understand the company. At a minimum your results should include at least:

- a write up discussing the data set, cover the steps of the data exploration process.

- various charts and tables in the form of a Dashboard that focus on the information you feel is the most important to the manager. This should include at least a pivot table and pivot chart.

Reference no: EM13993577

Questions Cloud

The following computations present depreciation : It had a useful life of 10 years and a salvage value of $50000. The following computations present depreciation on both bases for 2010 and 2011.
Improving this victory motorcycles strategy : Make recommendations for improving this Victory Motorcycles strategy as well as describing any challenges you foresee in executing those recommendations. Provide specific examples to support response
Make a good case for involving management : You make a good case for involving management at all levels in the strategic planning process. Should we take this a step further by including non-management employees as well. If so, what are some companies and industries where this may be appropria..
Example of the protestant reformation impact : Compare Erasmus and Luther in their attempts to bring about religious reform. Consider the role of the printing press and the actions of German princes in helping Luther to succeed. Next, identify one (1) example of the Protestant Reformation's im..
Create appropriate worksheets and upload to access database : Based on the excel data file (attached) create the appropriate worksheets and upload to access database. The goal is to improve the data integrity and follow the rules for the three normal forms. Create appropriate relationships. Create and run a ..
Sharing facilities reduces costs of both real estate-labor : A multi concept restaurant incorporates two or more restaurants, typically chains, under one roof. Sharing facilities reduces costs of both real estate and labor. The multi concept restaurants typically offer a limited menu, compared with full-sized,..
Determining the next month production needs : Frick Company makes units that each requires 2 pounds of material at $3 per pound. 500 and 700 units will be built in May and June, respectively. Frick keeps material on hand at 20% of the next month's production needs. How much is the material co..
What makes something a trade secret : What makes something a trade secret? What steps should a company take to ensure that a trade secret remains a trade secret? Analyze and evaluate the various issues presented while arguing and debating the connections between business, law, politics, ..
What the team has learned from the review and discussion : Continue reviewing 1 or 2 team member's drafts and review as a team this week. By the end of this week, all team members' papers should have been reviewed at least once.

Reviews

Write a Review

Database Management System Questions & Answers

  What is the optimal number of disks

If you have two redo log groups with four members each, what's the optimal number of disks you need to provide appropriate protection on the redo log files

  Objectives of file management principle

What are the requirements to ensure the objectives of file management principle is realized?

  Er diagram of cardinality and modality

ER Diagram of cardinality and modality bank management system and discription of bank management system

  Explain how you would formulate an sql injection attack

Explain how you would formulate an SQL injection attack against an e-Commerce server such as Amazon

  Does the reason for leaving the company

What is your recommendation for this policy and process? Does the reason for leaving the company affect the recommendation? Why or why not? Be specific and explain your reasoning.

  Search and set up the national parks database

create a table named Park. Accept the default ID primary key field with the AutoNumber data type, renaming it as Park ID. Enter at least five additional fields, such as Name, State, Fee, Hours

  Imagine that you work for a finance industry-based

imagine that you work for a finance industry-based organization. your organization is looking to submit its database

  Describes the basics of database planning

The link should be to an informative piece that describes the basics of one of the following: Database Planning, SQL, Access 2010, Queries and Form Design

  Explain the need for key restructuring

Give at least three reasons why ETL functions are most challenging in a data warehouse environment.

  Create the appropriate relationships between each entity

Modify the database diagram from Lab 1 with the entities and attributes that the scenario identified (i.e., a college tracking students, courses, and instructors). Create the appropriate relationships between each entity within the diagram.

  Which object would you use to enter, delete, or modify data

Which object would you use to enter, delete, or modify data. Which object would you use to retrieve customers who live in Germany and the United States

  Analysis of the sales numbers to management

Create a graph or chart that compares the data in a meaningful way, i.e. compare regions by month, compare products by month, etc. Create a spreadsheet formatted to present your analysis of the sales numbers to management.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd