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

The purpose of my assignment is to produce a database containing personal information of typical college students; information will be outputted as a form.

Extracts from this document...

Introduction

Contents Contents 1 Action Plan 2 Planning 3 Find: 4 Using automated routines 5 Structures 7 Exchange 9 Develop and refine...........................................................................10 Databases......................................................................................11 Action Plan Identify clearly your purpose: The purpose of my assignment is to produce a database containing personal information of typical college students; information will be outputted as a form. Identifying appropriate software: Because information of an individual would need to be stored in specific tables, it would be very logical to use software such as a database package (e.g. Microsoft access). Another main software package to use could be a word processing package (e.g. Microsoft word), used to document the work. Identify what is required to achieve success: In order to produce this database I will need information to be entered into the tables and what is required in certain tables. These could include: * Student table - containing personal information such as name and address. ...read more.

Middle

Justify reasons for choice of software and layout * Microsoft Access is a highly affective software package to use when you want to produce databases because of the useful features it possesses. * Since personal information such as name and address is required, a database would be appropriate, allowing users to enter and obtain the necessary information they require. * Databases are useful when you wish to store data; they help with file organisation. * Since the data entered and extracted are classified information, you can password protect data. Planning STUDENT_TABLE: Field name Data type Validation Student ID Text Input mask LLL99999999 Title Text Surname Text Maximum 25 characters First name Text Maximum 25 characters DOB Date/time Address line 1 Text Maximum 50 characters Address line 2 Text Maximum 50 characters Town/city Text Maximum 50 characters Post code Text Input mask LL0\_0LL Telephone number Text Maximum characters 11 Picture OLE jpg COURSE_DETAILS: Field name Data type Validation Student ID Text Input mask ...read more.

Conclusion

Explore and derive information: Information obtained and derived for purpose by using the following: Images captured using a digital camera. Information on field entries by Mr Leeming Skills developed included: Use of images incorporated within the database system. Attaching relevant images to particular fields in the database. Exchange As described in the design section, information was exchanged electronically through the use of e-mails. File attachments were received and the data obtained was inputted in the database. Develop and refine Changes that were made were not major and did not affect the overall running of the system. Such changes include: Adjustment of visual aids such as size of font and type of font. Modifications of images used e.g re-sizing etc. Rearrangements of the fields in the form for data to be entered. Databases The database produced successfully managed to meet its initial purpose. Data can be entered and multiple tables were created and a final form can be used and printed out or electronically exchanged through e-mails or any other storage devices. Steven Duong 1 ...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. Setting up a database in microsoft access.

    I could chose from 'columnar', 'tabular' or 'justified'. I could also chose the page orientation that I wanted - 'landscape' or 'portrait'. I could then chose the style I wanted for my report e.g. 'bold', 'casual', 'compact' etc. After I chose my style I had to give my report a title e.g.

  2. A presentation for use at information kiosks by the patients at the health centre.

    the health centre would have to produce thousands, which could be quite costly. Also, leaflets can sometimes just be too informative, and people don't like reading them. I don't think it would be suitable for the reader's because many would be unable to read small print, and it would be too informative for them to read.

  1. Database design for a games shop.

    Game information Last name Text Game information Address Text Home address Town Text Town of residence postcode text Postcode of member Contact number text Phone number Field name Data type description Membership id Number A foreign key from the members table.

  2. Publisher. My fathers friends name is Mr. Hussaini, as his restaurant has just opened ...

    for the logo then I am going to edit the picture in paint application and use Microsoft word so as to add the required title for the logo, this title will also be edited using word art so as to make it look attractive.

  1. What is a database?

    So you can get around that by typing 01345484950, but if you do then it will come up in the database as 1345484950, there's no 0 at the front. This makes sense we don't write 19 as 019, so if there is a zero at the front of the number then the database just gets rid of it.

  2. Description of a database and it's features!

    The field chosen as the Primary Key must contain unique data for each record in the table. Examples:- A field called Surname should not be used as a Primary Key because two people in the table might have the same surname!

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

    I the entered the cell range the 3 test results were. 2) I then divided the added amount by 300, which is the amount which all 3 tests collectively, were out of (300.) 3) I then copied this formula into the cells below, to prevent me from having to write the formula in every cell manually.

  2. bookings database

    Yes Guest number (output) Yes Desired outcomes (qualitative) 1. Easy to enter the data- the fields are spaced out and the names of the fields are joined on to the textboxes. Also, the textboxes are larger than the data being entered. This makes sure that they are apparent. The factors are effective fort the user as it easy to

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