• 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

    HCI shortened for Human Computer Interaction is the study of the human and computer ...

    3 star(s)

    * Objects: All objects are designed hierarchy in order in order to display the interface in complete form, meaning the images are layered. It is very important to know which image appears first and the subsequent images which overlays the first image, otherwise the object will appear to the user as an incomplete object.

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

    It has been seen that there are always some errors found in the system that must be noted and corrected. It also means the review of the system from time to time. The review of the system is done for: * knowing the full capabilities of the system * knowing

  2. Free essay

    Hardware and Functions of a Micro Processor

    It is therefore possible that we can consider the CPU to be like a bus station. All information that is passed through the system must go through the CPU as all busses would go through the bus station.

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

    5 Under Permissions select the permissions you want to assign, or clear the permissions you want to remove for the group or user, and then click Apply. Repeat steps 4 and 5 to assign or remove permissions for additional objects for the current user or group.

  2. The Global Positioning System

    All of these facilities listen to the signal broadcast by the satellites. When I describe how the satellites are positioned in space, it will be clear that from this distribution of monitor stations, all of the satellites will visible overhead at some point during the day.

  1. Purposes and Features of a Relational Database

    This means that a company can not only keep track of details, but also add, modify and remove them, in a user friendly, easy to use manor. This also prevents data redundancy and lost/ disorganised data, because everything is completed in real time.

  2. Hardware and Software

    Monitors: LCD (Liquid Crystal Display) monitors are based on a newer technology and are becoming very popular, mainly because they have great space and energy saving advantages over CRT (Cathode Ray Tube) monitors. CRT and LCD monitors are based on completely different technologies, and thus have quite different display.

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