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

Case Study-PGD

Extracts from this document...


ANALYSE Software I have chosen to use the database software to solve the problem. There are two different database software packages. These are Microsoft Access and Microsoft Works database. Both packages are available to my access but I have chosen to use Microsoft Access and this would allow me to implement all the user requirements. Access is also a relational database which will make it easier to link all the tables in the database. Hardware The hardware required for the system is: * Monitor- To allow the user to see whatever is happening. * Mouse- To allow the user to interact with the monitor. * Keyboard- To allow the user to input any data. * Printer-To print all reports and forms. ...read more.


The data would be Class ID, Class description, level, days, location and instructor. * Bookings by members would also be keyed in once the booking date has been confirmed. This information would be entered into the booking form which would be much easier for the user. Data such as MemberID, BookingID, ClassID, Date of Birth and Booking dates will all be automatically validated by the computer because they would be set to a preset type which Autonumber or Date. I would be getting all my data from the paper-based database from the gym. This would be given to be in person. In order to check for any mistakes, I would proof read all the information that has been given to me. ...read more.


The user would be able to enter the member type and the query would search for the records in the database. This query would be source for the members report. Backup Strategy In order not lose any important data; the computer file containing the completed system must be backed up onto a floppy disk or a flash drive every time it is updated. This copy should be kept on another computer which in a different location which could be my house in case of any problems such floods or theft. The system should also be protected by a password in order to prevent any unauthorised users to access any data. This protection would not be a problem as there is a password-protect function in Access. Rose-Anne Tagoe-Nunoo Database Coursework ...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 Management & Manipulation of Information 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 Management & Manipulation of Information essays

  1. Designing a booking system for an Estate Agent.

    A big disadvantage is that this doesn't prevent double booking. Several clients might book for a same time of property viewings but also with different negotiators. This will create a problem with the organisations time management as one would have to give up their time slot also creating disappointment for the other client.

  2. Background and investigation for designing a database for a DVD rental shop.

    I would like the proposed system to automatically calculate rental fees and overdue fee, then give me an overall charge for the member to pay. Direct Observation Aims Providing that question 24 in the interview with Ashley yields a positive result and I am permitted to do so, I will

  1. Free essay

    Data Protection

    Surf and download more safely: The best defence against spyware and other unwanted software is not to download it in the first place. Much software tries to pose as anti-virus themselves when they're actually spyware. Common sense is also recommended when downloading.

  2. ICT Security Report

    a network that is designed to bring the network down by surging it with useless traffic. This is so the computer then becomes unavailable for the user. Most attacks target big, high profiled web servers so that they then become unavailable on the Internet.

  1. Home Office LTD company. Database

    Screenshot showing the validation working for when the quantity falls below 3 Validation is used so the user is reminded with a message. This works by data > validation and then setting rules for the sheet to follow, so if the value becomes lower than 3 (as with the conditional formatting)

  2. A relative of mine works for a corporate firm on CRM (Customer Relationship Management) ...

    Recent reports from research firms, such as Gartner Group, Mercer Management Consulting, and Meta Group, point out that problems leading to CRM failures are organizational. The software is not faulty; the fault lies with the company in which the technology is being installed.

  1. Intermediate GNVQ Sample Database Assignment - Bolton Tools Database

    day, weekend, week. * The system must be able to print out a list of every tool sorted by category. Within each category the tools will be sorted in alphabetical order. The 1-day hire price with and without VAT must be shown for each tool.

  2. Implementation of an IT system.

    I entered the name of the macro, which was "view car details", where it says "Macro1": I clicked OK, and then a dialogue box saying, "That name is not valid", the dialogue box looked like this: So, after this, I knew I had a problem, so I looked into the "Successful ICT Projects in Excel (3rd edition)"

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