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

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

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