• 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
  • Level: GCSE
  • Subject: ICT
  • Word count: 802

GNVQ intermediate ict unit 2 database

Extracts from this document...


Database Report User Needs I am going to create a database for a cinema organiser/manager to help them keep on task with the cinema club that the students go to, an up to date with their members. At the moment the data is held on a paper based document, this can cause problems because paper can easily be lost or damaged and back-ups are some times impossible or hard to deal with because to copy all the information out again will take a long time. My database will be electronic, which means I can save changes and make back-up copies of the data easily. My database will allow them to do searches and queries to find data. The database is going to include a list of names, genders, addresses and telephone files. This database will be professional, reliable and easy to use; particularly if the owner does not know the necessary ICT skills. ...read more.


After opening the design view the blank design form can be typed into so that you can create your own field names. Data types and field lengths. Relationships in my database To make the relationship database work I had to form relationship between the two tables by clicking on the relationship icon and dragged one key field to another to create it (shown below on the left of the screen shot). Because one school can have many pupils I chose a many to one relationship, between my tables. On the right hand side of the screen shot shows the relationship editing window which shows that I have created a one-to-many relationship which means one school in the schools table will relate to many schools in the card holders table. How I entered data into the database When entering data you should not enter data straight into the tables particular if you want someone to enter data for you. ...read more.


You can choose the data source, the style of the report, the layout, the fields you want to include and how to sort the report. I created two reports from my two queries. In the first one I chose one style for the report and in the second I chose a different one to look at the more suitable style. The two reports are shown below. One is landscape to get all the data in (even then I had to amend the formatting in design view because the first and last fields did not fit on the paper). The bottom one is much neater and professional looking and has fewer fields so that it can fit in a portrait orientation. Backing Up You need to back up your data regularly in case there is system rash or other data loss of some kind. Backing up ensure that you have another copy that you can refer to if you lose the original copy. ?? ?? ?? ?? Unit 2- Handling information 1 Jermaine Carthy/Ernest Bevin collage ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE Software 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 GCSE Software essays


    a lot but contains a lot more inbuilt programs and applications including firewalls and things that will need a lot of HDD space. When you buy an OS on Disc than depending on what the format of the disc is depends on what disc drive you have most up to

  2. AQA GCSE ICT Specification B

    Spreadsheets and manual files can be difficult to update as the company grows; a database is very flexible and simple with regard to imputing new information. It can change and adapt as the business expands because there is no extra difficulty in having a million records on file.

  1. The aim of my project is to make the task of the allocation of ...

    a's, c's, and n's and display them on the graph next to the plan. The first test done, was to see if all the seating numbers and their income on the table next to graph would be zero, this is done by simply deleting all entries on the plan.

  2. Project 1a. ICT

    This is an example of the picture I had to scan into my pc so that I had a non ICT source to hit the criteria. This alien is scanned out of my monthly magazine called NME. NME is a music magazine but regularly have a section for drawings and

  1. A Program for a Cinema Manager

    * The tickets worksheet will have a space where the boss can enter a price in a "what if" space. * In this what if space, the boss enters the price that he desires, and can see what happens to his income.

  2. Graphics Review - Unit 21 OCR

    Purpose To show icons which are relevant to subject, act user friendly... To use a symbol to reinforce the horoscope selected, to also link to the original website where the horoscope info. was derived from: www.tarot.com Use of icons to allow user to quickly choose their option w/out reading, to show it's the weather.

  1. GNVQ intermediate ict unit 4

    Task What I have to do Due date Deadline met? 1 Write project proposal 21.4.07 Yes 2 Agree proposal with teacher 21.4.07 Yes 3 Draw up plan of spreadsheet, including formulas and functions 22.04.07 Yes( had to re-draft) 4. Research how to do macros 23.04.07 Yes(printed out the instructions form Excel Help)

  2. A new IT system in a Dubai Marauders Rugby Football Club

    financial officer will be able to add more room if there is more space required for different types of incomes and expenditures. The spreadsheet could be saved as read-only and be used as a template. The input is to actually design the spreadsheet.

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