Managing Business Information

Managing Business information

Executive summary:-

This assignment is based on a case study of a second-hand car company which has to select either Microsoft excel or database access to store their information. In the case advantage and disadvantage of both spreadsheet and database has been explained and then compared with each other. Based on the suitable software recommendation is given to the company with proper reasons. An outline design of recommended software is also given.

Index:-

Table of content page no.

Introduction…………………………………………………………………………….04

Analysis ………………………………………………………………………………

2.1 -Assessment of Spreadsheet and Database Alternatives ………………………….05

2.2 - Recommendation to the Manager………………………………………………………06

2.3 - Outline Design…………………………………………………………………………….07

Conclusion………………………………………………………………….. ………….14

Reference………………………………………………………………………………15

Introduction:-

Organisations and managers use spreadsheets to store their data, even though the data could be better managed in a database (hurn, 2003).There is a lot of confusion between spreadsheets and databases from the basic similarity that the key function of both is to store and manipulate data (hurn, 2003).

Spreadsheet:-

It is a table of values arranged in rows and columns (Rouse, 2015).It store data sets, but they provide the range of utilities so that can easy be manage and process the data sets (Smith, n.d.).Each value can have predefined the relationship to the other values. Each cell is labelled according to its placement (for example a1, a2, a3…..). Spreadsheet application was first created by Daniel Bricklin and bob Frankston. Spreadsheet application is available for computer which we can able to create spreadsheets. Microsoft office excel provide spreadsheet which