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

GNVQ intermediate ict unit 2 database

Extracts from this document...

Introduction

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.

Middle

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.

Conclusion

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

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

    It also shows where his biggest losses were, and his biggest gains. See page 17. 2) It will allow the staff to know where everyone is sitting, where there are free seats, and the cost of each of the seating arrangements according to whether the person is an adult, child

  2. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    Unfortunately, it will only let you have up to three conditions, but in my circumstance I only wanted to have three conditions, so this was not a problem. I added more conditional formatting through-out my spreadsheet, changing each one to suit shown in the steps above, but making sure I

  1. bookings database

    Presence check- this is a check to make sure that the required fields are filled in. This is effective for the user because if the details are not filled in then the user will not be able to book a room correctly.

  2. AQA GCSE ICT Specification B

    x �0.50 Total Cost = Net Cost + VAT Cost Output 2: Delivery Note Information on Output Inputs Required Processing Required Pre-Programmed Data Entered by User Company Name, Logo and Address Customer Title, Initial and Surname Delivery Address Date of Order Type of Order Order Details Project Dispatch Date Company

  1. 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

  2. Graphics Review - Unit 21 OCR

    Like AOL, to allow user to quickly choose the frequently used option. Suitability to purpose The red, ripe and clean apple emphasises a symbol of hygiene; the book symbolises educations/learning; and the green, ecstatic germ emphasises the fun to be explored.

  1. ICT BTEC UNIT 2 - REPORT

    For example windows XP only needs 1.5GB free HDD space so if the computer has a 80GB hard drive then it will have loads of space to install and download a lot of other programs. Windows vista premium and windows vista ultimate both require 15GB free HDD space this is

  2. Spreadsheet Report

    An example of a format that I used is date; this was to see all the dates in short term. The format of cell "B17" to "D17" has been changed to date as the cell is based on the Dates which the limos are booked on.

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