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

A Chief Constable wants to keep details about local soccer hooligans and their actions, this database will enable the user to go through the criminals and there incidents - database report.

Extracts from this document...

Introduction

The user needs A Chief Constable wants to keep details about local soccer hooligans and their actions, this database will enable the user to go through the criminals and there incidents, the user should be able to search for records of a particular hooligan or search for hooligans who have previously been involved in a particular type of crime. The data needed Criminal personal details: ID, name, age, date of birth, address, post code, telephone number and crime code Records of incidents: ID, incident, date of incident, crime code The data that I have got it not real it is made up information that I will be using for my database. ...read more.

Middle

How I put my plan for tables and relationships onto access Here are screenshots of what I did to set up my tables, similar to a step by step. I set up the primary key by choosing the field "ID" because it I unique key, I right clicked and selected "primary key". Setting up a relationship These are some screenshots of what I did to set up my relationships I went of "tools" then "relationships" A new window called the Show Table appeared on the screen then I Selected each table name in turn, clicking on Add after each one. I did this with both tables then I clicked on close Then I Clicked and held on the field name "ID" in ...read more.

Conclusion

How I entered data into my tables Here are some screenshots of the forms I have designed and used, I have designed 2 forms, criminal details and records of incidents form To go with my database I also made a form which shows the information that was needed, this form shows the criminals personal details This form shows the records of incidents Here are some screenshots of my query Printout of my reports Safety To make sure I don't loose my work I have kept back-up copies of my work on floppy disk, if my floppy was to get lost I would still have a back up on my home hard drive, so this is how I kept my work safe. Also in my work there was no errors that occurred. ...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. I have been given the task to design a database for a company called ...

    I tested this validation rule by trying to input values for the width as 200 cm, length as 150 cm and height as 40 cm which would cause the total dimensions to be greater than the specified amount because 200 + 150 + 40 = 390 cm.

  2. Video Club Database Project

    Main Menu must appear on the screen. OK Module: Customer File TEST NO. TEST EXPECTED RESULT REMARKS 1 Click on 'Add' command button. Must be able to add a record. OK 2 Click on 'Save' command button Must be able to save a record.

  1. Spare Parts Database Project

    Wong has requested that it should be done in MS Access. This is the package that must be used. It would probably be possible to implement the system using MS Access or another programming language but it would take longer time and would involve the owner having to buy more

  2. Purposes and Features of a Relational Database

    First Nm. Last nm. DoB Age Address Postcode Date Add Bill Gates 8/12/65 50 1 Micro 46284 4/2/08 Steve Jobs 5/11/80 30 1 Apple 37594 12/7/07 Nick Hutchins 6/5/92 16 161 StRd. RG26 20/12/08 This setup in some form or another is used in every kind of datbase.

  1. VHD tools. The VHD tools database was constructed to aid the staff in their ...

    * Each transaction has more than one product. It is assumed that when a customer comes to the business, they are able to buy more than one item at any one time. * Each employee has a unique ID code.

  2. I have been given the task of creating a system for a hospital to ...

    collect the data on the requirements of the new system and the problems with the old one, I would use the following four techniques: 1. Interviewing staff at different levels about the present system and what they would like to see from the new system.

  1. Basic Database Building

    The database works on the principles of one to one relationships, the one to one being because the individual members can only use any one piece of sports equipment at any one time. This is the same for their ID, as only one of these can be possessed.

  2. UKAB Remarking Database.

    It should take very little time to find a record, which is already on file. 2. Data Entry should be as fast and efficient as possible to save time. 3. There should be allowances for Candidates requesting remarks of more than one paper.

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