Benefits Of Using Spreadsheet Database Computer Science Essay

The undermentioned study is abstracted from a instance survey which is based on spreadsheets and databases. Fred ‘s Emporium PLC is a company that designs and creates modern furniture and has been merchandising for 19 old ages. They have been maintaining paper records and would wish to travel frontward and integrate a spreadsheet and database within the company. In this study I will be saying what package should be purchased and why I think it will profit the administration.

Undertaking 1 – Benefits of Using Spreadsheet & A ; Database

Fred ‘s Emporium PLC is cognizant that a spreadsheet and database could be used.

They want to cognize how they will profit from utilizing these applications.The first of import benefit of utilizing a spreadsheet and database is security. Until now the company have kept paper records of client inside informations, providers, bills, employee inside informations, paysheet and histories. Keeping paper records is really insecure due to a possible inadvertent loss or larceny. For any concern maintaining client and employee inside informations safe is really of import. By non making so is a breach of the Data Protection Act.The Data Protection Act was developed to protect how informations about people can be used.

The 1998 Act screens informations stored on a computing machine or an paper filing system about people.HMRC were criticised for transgressing informations security. They wrongly sent out 1000s of taxpayer ‘s inside informations to incorrect people. ( HMRC criticised for informations security breach, 2010 ) . A database and spreadsheet can forestall any inadvertent loss or larceny of informations by utilizing a watchword so merely authorized people have entree to it.Datas can be saved and stored in electronic booklets on computing machines and the booklets can be password protected every bit good.

Having electronic booklets can salvage infinite and costs of maintaining informations in a paper filing system.Spreadsheets can assist the company with pull offing employee inside informations such as paysheets, absences and vacations. For illustration if the company demand to look into an employees pay 5 months back the spreadsheet will hold it stored and is easy to amend inside informations.Recently the company ‘s orders have reduced. A good manner to better this could be to hive away all the client inside informations into a database and utilize the database for mark selling intents for illustration send out publicities etc to old purchasing clients.

This will besides supply a good client relationship. Using the cyberspace to sell merchandises straight to the client ‘s can be used with a database. The database can publish out bills and shop client ‘s inside informations for future mention.Keeping path of the grosss and disbursals is really of import for the company. Spreadsheets can hive away informations about buying disbursals every bit good as any other disbursals. Using the gross informations in spreadsheets can find which merchandises are doing the concern the most money and which merchandises are worsening.

Spreadsheets use specific expressions to work out grosss and disbursals.A database can be used to transport out undertakings related with maintaining path of supplies. Spreadsheets have formulas and maps that can demo the company when supplies reach a critical degree. This will find you need to order more supplies.

Undertaking 2 – Any other package:

Fred ‘s Emporium PLC want to cognize what other package may be required.

Specific package that could be required is design package such as Microsoft Adobe Creative Design. It is more flexible for the interior decorators utilizing Adobe Creative Design because mistakes can be edited whereas it is less flexible if manus drawing.Another benefit is speed. Using package is a batch faster than manus drawing because there are artworks, icons and images already created and available to utilize.

Adobe Creative Design can salvage informations of drawings the interior decorators create and can be password protected.It is more dependable and accurate for illustration the interior decorators develop measurings by manus which sometimes can non be less accurate. Drawings created utilizing the package, the dimensions are calculated with truth.Adobe Creative Design is cheaper and most significantly more environmentally friendly. Planing by manus can travel through a batch of paper outlining designs. Drafting designs can take up more human power, and cost of, paper, templets and a drafting machine.Fred ‘s Emporium PLC references selling their merchandises onto the cyberspace. I would so urge on buying website design package such as Adobe Dreamweaver.

With this the company can make a website advertisement their merchandises for sale. There are many benefits of holding a web site for a concern. Number one benefit of holding a web site is farther selling the company ‘s merchandises.

This will increase the company ‘s gross revenues.A web site can be easy updated so if the interior decorators create new merchandises they can be easy added to the web site.Selling straight to the client instead than selling to High Street furniture stores can salvage money and increase gross revenues because when selling to shops you make less net income due to the store selling it at a higher rate.

It can be easier for clients to make concern with for illustration a client might desire a usage made design, this will make a friendly client relationship. These clients can be locally or planetary.Besides another benefit you can vie with other design furniture companies.

Undertaking 3 – Off the shelf Vs Bespoke Software:

Off the shelf applications such as Microsoft Excel, Access is package that is non specifically designed for the user. Custom made package known as Bespoke is package that has been specifically written for the user.

Advantages of bespoke applications:

The package can be specifically designed to suit the company ‘s demands.Functions and icons can be specifically created to do running undertakings faster.It will be easier for the company to utilize as it will non incorporate unneeded installations and maps. Besides will run in the manner that the company wants it to.It is much more flexible than off the shelf package because alterations can be made to it over clip.

This is utile as demands of the company may alter over clip.There are no licensing costs involved for utilizing bespoke package. There is merely a one off payment to the developers. This will salvage costs.

Disadvantages of bespoke applications:

Bespoke package will be more expensive than off the shelf package.The development of bespoke package can take clip to finish. It may affect Fred ‘s Emporium PLC passing a batch of your clip to the development procedure.Geting support for bespoke package can be an issue, as the developers may non offer support services.If the company do non acquire entree to the beginning codification they will be dependent on the developer ‘s continuance.

The package may be unstable and non run on the system the company owns.

Advantages of off the shelf applications:

It is cheaper to buy an off the shelf application than it is to buy a usage made application. This will salvage costs.The company will be able to portion files produced by the package such as Microsoft Excel.The company do non hold to pass clip in the development procedure. This can salvage clip and costs.

It is easy to acquire support from other users that besides have the same package for illustration ushers on the cyberspace etc.Off the shelf package has most maps because it is made as general package.

Disadvantages of off the shelf applications:

The package may hold maps on that the company may non necessitate.The company may hold to do alterations to suit with how the company works. This is because the package is designed for a multipurpose usage.They may be certain actions that you need to make that the package can non back up it.No alterations can be made to the package except for updates from the developers.It may take longer to larn decently with the package been excessively big.

Whereas usage made package is shortened down to the user ‘s demands.


In decision to this study I recommend buying a usage made package. The ground for my recommendation is it can be designed in a manner the company need it for illustration have merely maps that are needed. By holding usage made package it can be easier to utilize because it will be designed to how the company want it.

There can be big icons to press which can do it easier. Besides if any alterations to the company or anything that needs adding to the package. It can be edited. It can be cost effectual because there is no licensing, merely a one off payment.

Word Count: 1,438