• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Highfield video store currently uses a paper system to perform all the functions required for this business - create a computer system for these functions.

Extracts from this document...


Solutions to the problem Highfield video store currently uses a paper system to perform all the functions required for this business. Before I reach a decision on how to produce an advanced and improved system to the existing system it is imperative to choose the correct software to overcome this situation. I will need to evaluate and consider the factors that need to be tackled on producing this system by evaluating the end users requirements and expectations f the system to ensure the software chosen has the capability to overcome these requirements successfully and competently. As the company is looking for a more flexible data management system, so a database system is likely to be the right solution. Using Microsoft Access as a solution Advantages: o Microsoft Access is a relational database management system which allows a one to many relationships between tables. Thus greatly reduces data inconsistency and data redundancy. o Uses a familiar interface to perform a range of tasks such as; setting up tables, forms, queries, macros and reports. ...read more.


Also contains macro which can automate a series of commands and functions. o Excel forms can also be customised to satisfy the users requirements with different methods of data entry and appearance of the forms. o Graphs can be created to summarise data in a number of different graphs to allow the data to be more understandable to the user and also produces a professional outlook. Disadvantages: o The recording of macros can be problematic as it is easy to make a mistake and the whole process needs to be repeated again. This requires an experienced person with sound knowledge of macros and formulas to perform this task. o Microsoft Excel is a spreadsheet package and doesn't features such a relational database which are available in Access. Therefore data and tables need to be entered again leading to unnecessary data redundancy and data consistency. o Creating and editing macros needs to be done via Visual Basic Editor program in Excel. Users of this program need to be experienced in using this program as the macros commands need to be programmed by the user. ...read more.


o Microsoft Access can provide customised reports to summarise a set of data. Access allows data to be brought together in a report which can be tailored to the user choice. So a professional output which is in line with the companies image can be produce whereas as other software such as Microsoft Excel would not have the capacity to do this. Data would need to be summarised into graphs and is difficult to suit the companies image so the output and interface of a system using this software would need be as professional compared to the software being use to created this system. o Access has the capability to update records in any table by setting up queries to update the necessary records. This will lead to more consistent data is it is more likely to be update and accurate. o Data and information that needs to be stored can be done so more easily due to the set up of the system. Tables are clearly defined and related, which is not the case with other software such as Microsoft Excel as relationships between tables cannot be emplaced. ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Computer Science section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related AS and A Level Computer Science essays

  1. Marked by a teacher

    Designing a data system for a vintage clothes business.

    3 star(s)

    The data that is collected from the buyer and the design is output to a form, of which is stored in her folder system. Currently, for one buyer that buys some clothing, Luki writes down who, when, how much, etc of the product shes sold and to whom.

  2. Peer reviewed

    Principles of Computer Networks

    3 star(s)

    IEEE 802.5 Also known as token ring local area network is a LAN protocol which uses special 3 byte frame called a token which travel around a network ring. Nodes on a token ring LAN are organized into a ring topology.

  1. System Analysis The aim of the Jewellery store system is to make the work ...

    THREE VIEW OF THE SYSTEM Logical data models (LDM) Logical data models represent the abstract structure of some domain of information. They are often diagrammatic in nature and are most typically used in business processes that seek to capture things of importance to an organization and how they relate to one another.

  2. Smart Card System

    The 32-bit wsock32.dll ships with Windows NT and Windows 95 and runs over the Microsoft TCP/IP stack. These 32-bit environments also have a winsock.dll file that acts as a "thunk-layer" to allow 16-bit WinSock applications to run over the 32-bit wsock32.dll.

  1. System I designed in order to produce a promotion package for her newly formed ...

    DR DRE IT'S A G THING 2000 �9.00 1 Spice Girls Holler 2000 �5.00 11 Various Artists Gatecrasher: global sound system 2000 �15.00 6 Various Artists Fresh Hits 2000 �12.00 3 Various Artists Now that's what I call music!

  2. Hardware and Software

    Both of these can be used by professionals. I have explained the software and features it has for each. Corel Paint Shop Pro Photo X2 Corel released the newest version of its image editing suite, Corel Paint Shop Pro Photo X2. The new "X2" gives enthusiast digital photographers an entirely new set of tools to unlock their creative potential.

  1. Describe the functions of each section within the shops and Head Office, paying particular ...

    locating the goods to be sold and negotiating contracts for their supply. * The buying manager ensures the right volume and type of goods are supplied at the right time to maximise profit. Finance and Administration * The Finance and Administration director is responsible for all other functions within the Head Office.

  2. The Global Positioning System

    However, in my experience the electronic compass is not to be trusted. The satellites cannot tell which way the receiver is facing, and so the compass isn't the most accurate device ever. Most handheld units can even give information such as daily sunrise and sunset times, to within about a few minutes accuracy.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work