• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16
  17. 17
  18. 18
  19. 19
  20. 20

Creating an Information Technology System for Chin Bookmakers

Extracts from this document...


Creating an Information Technology System for Chin Bookmakers Analysis Introduction Chin Bookmakers is a small independent bookmakers situated on Eden Hill Road in Peterlee. They currently have a small manual credit account for giving credit, on bets, to customers. At present Chin Bookmakers have approximately thirty customers to whom they give credit. They would like to extend the number of customers they presently give credit to but the system they use is time consuming and prone to error. At present amount of credit given to customers has to be checked manually by employees. This means checking backlogs to ensure previous credit has been repaid. The bookmakers would like a computerised system that will allow them to check customers credit allowance quickly and ensure that the information is correct and kept up to date. Also they would like the system to produce charts and graphs to give an overview of credit given and credit repaid on a monthly basis. The Current System An employee of Chin Bookmakers was interviewed to ascertain the exact procedure for entering logs into the credit book. The following was recorded. The customer places a bet in the usual way and asks for the bet to put on his credit account. ...read more.


This will be the only workbook and will contain; * Menu * Customer Database * place bet and paying in sheets. Sheet1 - Menu This sheet will act as the front end and will be selected automatically using an Autoexec macro when the workbook is loaded. It will have 5 options as follows. CHIN BOOKMAKERS Ltd Sheet2 - Customer Database This is where all the customers will be kept on the system. It will include details about the customers and will laid out as follows. Information here will automatically be updated by other sheets in the work book. All cells will be protected to ensure information is not tampered with or so that cells and formulae are not accidentally erased.The sheet will be protected by a password known only to authorised employees. Sheet3 - Place Bet This sheet is required to debit a customers account. The customers account no. is placed in the space provided and their details are automatically displayed. All cells are locked apart from the account no. section and bet amount section which are the only cells from which data is inputted. There is one command button: 1. ...read more.


Initial Design Decisions My first decision was to create a large customer database to hold 100 customers. I asked Mr Chin about this and he said he wasn't sure how many customers he was planning to give credit to. I then decided to use an end of table line to add new rows as they were needed. I also decided to create an add new customer worksheet but thought it more convenient to scrap this and create a macro with the command button situated in the credit book work sheet. Final Design My final design is as shown in the design section, The adding of new customers is very simple with pop up boxes asking for all the information needed. It is a step by step process and any new user should be able to use it. Commentary on Testing Test 3 Test 4 Test 5 Test 6 Program successfully exited. Evaluation Looking back at the objectives and performance indicators the following have been achieved: 1. Trials showed that it took the user about 30 seconds to enter each new customer well within the 60 seconds allocated. 2. User Manual Introduction Installation Backups Adding a customer Placing a bet Paying in Exiting the Application Technical Manual Installing the System Macros ?? ?? ?? ?? 4 20 Michael Charlton Michael Charlton ...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

    The systems development life cycle (SDLC) is a conceptual model used in project management ...

    3 star(s)

    there is an often overlooked need for developing corporate and project specific underlying structure to support the technology. When this underlying structure is omitted, lower productivity can often result. Best projects to use Prototyping It has been argued that prototyping, in some form or another, should be used all the time.

  2. Business blue print document for the implementation of SAP R/3 (4.6B) payroll at Mastek ...

    > Anthem Health provides both Medical and Dental insurance for MSI employees and their dependents. LIFE INSURANCE > MSI provides life death and dismemberment insurance coverage for all of its employees through UNUM Life Insurance Company effective from the date of joining MSI.

  1. Computing Project

    The forms will not be cluttered and the layout of the buttons must be suitable so that there are spaces and blanks. Items must be placed in a logical way in order to make it easier for the user and to make it look nice.

  2. I have been given the task to design a database for a company called ...

    will be the customer's ID number, title and surname so that the recipient knows whom the parcel is from. Then so that the delivery person knows where the parcel has got to go I will include information on the destination ID, name of recipient and their address.

  1. Spare Parts Database Project

    Add all records except 'Item code' and click on 'Save' A message box must appear saying 'Item code' OK 9 Click on 'Add' command button. Add all records except 'Customer code' and click on 'Save' A message box must appear saying 'Customer code' OK 10 Click on 'Add' command button.

  2. Computing Project

    will hold all necessary details Specific Objectives * The database will be able to create reports to show what stage the student is at * The database will calculate how many lessons a student has had and how much they have paid with plus if there are any outstanding balances remaining.

  1. ict implementation

    23 24 25 Implementation User interface To set up my new computer system I need to use a spreadsheet software package and so I choose to use Microsoft excel. I used this software as it is simple to use for setting up and provides the most commonly used spreadsheet package .

  2. Smart Card System

    IP, so IP have to been told which protocol to send the datagram to. Finally, the checksum allows IP at the other end to verify that the header wasn't damaged in transmit. TCP and IP have separate checksums. IP has to be able to verify that the header didn't get

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