• 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)

    One is the customer making order: Customer phone calls or emails Luki to ask for product Luki checks stock Luki gather information and stock Luki sends off or asks customer to come and receive order Second there is, the client receiving order and deciding how much stock to order: Luki

  2. Peer reviewed

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

    3 star(s)

    simply predict the time it will take for an action to be carried out. The gives the designer the ability to calculate the amount of time it will take to execute the instruction given to the interface. The designer identifies the outcome of intended actions when different types of operators.

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

    When all the systems requirements have been identified, the systems analyst produce a detailed report on the specifications of the new system. Phase 4: System Design This phase produces a logical design specification for the new system. During this phase, the analyst schedules design activities, works with the user to

  2. Purposes and Features of a Relational Database

    Increase company operations rate If the details for a company are stored in a database they can be searched for and pulled up quickly and easily. This means that accessing data doesn't become a time killing chore. It instead becomes a quick job that, takes little or no time to

  1. Free essay

    Hardware and Functions of a Micro Processor

    Input A Input B A B 0 0 0 0 1 1 1 0 1 1 1 0 * ENOR - This gate again does the opposite to the EOR gate. It will give a low output if either, but not both of its two inputs are high.

  2. Hardware and Software

    Inkjets work out to be more expensive than laser printers. Task One (M1) Software Packages 1. Corel Paint Shop Pro Photo X2 2. Adobe PhotoShop 8.0 CS Win I have chosen two of the software, which I think are good for creating, capturing and manipulation graphic images.

  1. You have been asked to create a database to handle various account combinations of ...

    -Yes 10 -No 0 Thank you. Final Specification Carrying out the questionnaire has enabled me to come up with the following specification according to the results that were achieved. 1) The model should be simple and user friendly and be able to communicate well.

  2. Program Code Program DVD_Program; Uses Menuunit, CRT, dos; ...

    (video, 'c:\pas\ video.pas'); Reset (video); size:= filesize (video); For i:= 1 to size Do Begin Read (video, two_rec); epos:= filepos (video); If (two_rec.vid= an_id) then Begin found:= true; i:= size; End; End; Close (video); End; {--------------------------------------------------------------------} {This procedure is used to display an existing member record from the database.} Procedure

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