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

  Assignment related to the prestige hotel

Import the Location data from the Excel file a02m2location into your database as a new table. Set the LocationlD Indexed property to Yes (No Duplicates), and then set the data type to Long Integer. Select the LocationlD field as the primary key. N..

  Use oracle, list all system privileges assigned to user hr

Use Oracle, list ALL system privileges assigned to user HR. Please show screen shot if you can make it!

  Create a database for a human resources group.

State assumptions in creating the DB and underlying database objects. Use Access to create DB and tables.

  How complicated are my data management tasks

To keep specific rows and columns from scrolling off the screen you first must position the cell pointer

  How do information systems projects get started

How are organizational information systems related to a company strategy? How does strategy affect the information systems a company develops and uses?

  Modifying a database design in visio

1. Use Microsoft Visio (or open source equivalent) in which you: a. 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).

  Contents of the product table

To list all the contents of the PRODUCT table, you would use and When you issue the DELETE FROM tablename command without specifying a where condition

  Explain how data is physically stored and accessed

Explain how data is physically stored and accessed

  Design an er schema with attributes and primary keys

Design an ER schema with attributes, primary keys, cardinalities and participation constraints if appropriate

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Suppose we have a relation employees ssn name department

suppose we have a relation employees ssn name department salary.nbspfor each of the following queries either write the

  Q1 explain what a relational database is and explain why

you are the trainer for a major technology firm. one of the problems your firm has is hiring new technologists who have

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