• 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. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    This icon is used to represent formulas; formulas are often very useful as they work out specific calculations which speed up certain tasks which are required in your job for example, an if statement allows you to type in the criteria you want so that it can say a certain

  2. bookings database

    This is effective because sometimes, as many guests stay, the residing times can overrun into other guests residing time. 10. Cant leave fields empty- if a field is left empty, an error message is displayed and informs the user that the fields have to be filled in with the guest details.

  1. AQA GCSE ICT Specification B

    Processing Required Pre-Programmed Data Entered by User Company Name, Logo and Address Customer Names, Order Details: * Date of sale * Customer * Order * Personalization * Prices Two Dates Company Name, Logo and Address Specify Dates Customer Names, Order Details: * Date of sale * Customer * Order *

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

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

  1. Spreadsheet Report

    Cell Function used Reason 1 H5 =AVERAGE('Hirer details'!B14:D14) See the average cost 2 B14 =B12*B13 Work out the total 3 B15 =IF(B14<100,IF(B14>50,B14*0.95,"-"),"-") If they paid over �50 then they will get a 5% discount on their total price 4 D16 =IF(D14>=100,D14*0.9,"-") If they have spent over �100 then they will get a 10% discount on their total price

  2. Analyse - Database

    However as the user does not have this software package, FlexiDATA cannot be used. Furthermore, Mr Browne and his employees have basic skills of using Access compared to FlexiDATA therefore it is better suited. Date Collection: Data will need to be collected from certain people so the system can be implemented successfully.

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