• 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
  16. 16
    16
  17. 17
    17
  18. 18
    18
  19. 19
    19
  20. 20
    20
  21. 21
    21
  22. 22
    22
  23. 23
    23
  24. 24
    24
  25. 25
    25
  26. 26
    26
  27. 27
    27
  28. 28
    28
  29. 29
    29
  30. 30
    30
  31. 31
    31
  • Level: GCSE
  • Subject: ICT
  • Word count: 8037

Database management

Extracts from this document...

Introduction

Now that I have proposed and decided what I will be doing so as to improve the database management of EMIRATES NATIONAL SCHOOL I will now decide how I will be using MS Access. All the data for EMIRATES NATIONAL SCHOOL will be stored in tables although the data will be entered through the use of forms. Each table has different fields depending on the type of data it is going to store. The design layout for the tables, which I will be creating for the new EMIRATES NATIONAL SCHOOL database, has been shown below. Along with the data entered there is always a chance of an error occurring. To reduce the risk of error occurring I have used validation rules and input masks with the fields for each table. Therefore along with the design layout for the table I have also shown the validation rules and input masks I have used. The validation rule in Access is used to detect errors made during data entry and immediately prompts the user to correct the error. The input masks on the other hand are used to restrict data entry to only one form. Table Name: Student Records Field Name Datatype Width Example Roll Number Text 4 N001 First Name Text Variable Nantie Last Name Text Variable Hayward Gender Text 6 Male Date Of Birth Date/Time 9 12-Mar-84 Residence Telephone Text 12 (DXB)3276878 Address Number 5 3564 Emirate Text Variable Dubai Current Class Text Variable Senior 5B Percentage For Year Number (Percent) 5 65.6% Grade Text 2 B Picture OLE Object - Bitmap Image Validation Rules: Field Name Validation Rule Validation Text Gender ="Female" Or "Male" "Only 'Female' and 'Male' can be entered into this field. Please re enter your data." Date Of Birth <=#01-Jan-95# And >#30-Dec-82# "Only a date between 30-Dec-90 and 01-Jan-95 can be entered. Please re enter" Grade ="A*" Or "A" or "B" or "C" or "D" or "F" "Only A*, A, B, C, D or F can be entered. ...read more.

Middle

Here again I would the two toggle buttons using the Option Group and the same coding will be applied in the Code Builder so as to select and store, either "Male" or "Female" * Here too for this form I will be using a number of command buttons so to increase the ease of use for the form. The same buttons are also used in this form as have been used in the previous forms and the events which these buttons perform remain the same. * This would complete the designing of the form, which is to be used to store teacher's records. Again the validation rules and input masks, which have been used for the table of teacher's records, also apply to the form as well. Also any changes or entries of data that are made in this form will also result in a similar change in the respective table as well. The design layout for this form can be seen below. TEACHER RECORDS Staff Records * I would open the Design View of the form and I would proceed to designing the form. The first step would be to design the header of the form. I would first enter the logo of the school which is a GIF image which has been created using Ulead Photoimpact. * For this staff records form I will be using the combo box which will be applied to the "Position Of Work" field where the user will have to select from a fixed list of data items. * The next control, which I will be using, is the toggle button, which will be used to select the gender. Here again I would the two toggle buttons using the Option Group and the same coding will be applied in the Code Builder so as to select and store, either "Male" or "Female" * For this form I will be using the same command buttons as in previous forms so to improve the ease of use for this form. ...read more.

Conclusion

Library Book List Book ID BP020 ACCEPTED 8. Staff Records Rate Of Pay 55 Validation Text: "Only a value less than 20 can be entered. Please re enter" 9. Student Records Date Of Birth 31/12/94 Validation Text: "Only a date between 30-Dec-84 and 01-Jan-95 can be entered. Please re enter" 10. Teacher Records Gender FEMALE ACCEPTED. Auto Corrected to 'Female'. 11. Senior Student Mark Register Grade A** Validation Text: "Only A*, A, B, C, D or Fail can be entered for the grade." 12. Junior Student Mark Register History 100.9 Validation Text: "Only a value less than or equal to 100 can be entered" Therefore from these entries of test data one can see that the validation rules and input masks which I have applied work as I have defined. This will be an asset when entering the actual data for the school since there is less risk of errors occurring during the entry of data. This will improve the accuracy of the entire database which means data does not have to be checked regularly. Along with these data validation rules and input masks which I have applied to improve the accuracy of data I have also set a database password so that the database can be selected only by those employees who know the password. This can greatly reduce the risk of fraud and malicious manipulation of data. Also some of the data contained within the database is sensitive and so the database password feature is an advantage. To set a password for the database I would click on the "Tools" menu and from the drop down menu I would click on the "Security" and I would select the "Set Database Password" feature. A window would open allowing me to enter the password, which would be required to access the database. So now whenever the school database file is opened the user will have to enter the password to access the database. The next step would to the actual design of the database that is the tables, forms and reports using MS Access' numerous features. This is shown in the next section. ...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 ICT Systems and Application 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 ICT Systems and Application essays

  1. Different types of technology How I use ICT at home and at school

    This is extremely useful for someone who watches a lot of TV or keeps up with a certain programme but can't be there at its running time. For someone like me who keeps up with weekly dramas which make the plot hard to understand if missed, it helps out a lot.

  2. GCSE Database Project ICT

    Access inputs this value Access inputs this value Title Lookup Mr General 1234567 Ms. 12 Patient Forename Text Jack Uppuguengue-Spencer-smiths 6756567575676756757655 A 1 Patient Address 1 Text 44 Manor Road Park View of a stream near a ruined building/House 3456789087654567890---------[';'/'/ A 1 Date Of Birth Date/Time 26/08/1993 01/01/1900 DD/MM/YYYY 02/01/1900

  1. ICT Report 2b: ICT in Organisations

    Furthermore the lead ends are rectangular and simple to insert (unlike the PS/2 port where visual aid is necessary) without even looking. In addition, it's designed with durability in mind and it is terribly difficult to damage and destroy the lead ends because there no loose I/O pins that could be bent and consequently damaged.

  2. Explain the difference between primary and secondary sources of data, with examples.

    Statistics give no indication of how the person feels and could not be accurate because it could not be how the person truly feels. The statistics give no individual meaning or interpretation. People may not understand the question or think it has I different meaning and interpret it in totally different ways.

  1. I will design a new video database for the video shop that will also ...

    on the actual database so it doesn't become too full and confusing. The system will have a large memory capacity as the video shop has to keep records of a large number of customers. Any documentation that is needed for the system will also be created, such as a user-guide and a technical manual.

  2. Planning a system to handle school records.

    * Every part of the system must be accessible to the user with minimum fuss. > Quantitative objective: * The system should able to store the data of ten course and 15 children per class. * The data must be record and available to view with in 10 second.

  1. In this (2b) report I am going to investigate software application, Input and Output ...

    A number of small, hand-held electronic devices are available that use small speakers to produce synthesised speech. They include language translators and small learning aids, for example to help children with arithmetic. PORTS AND CABLES PORTS SERIAL PORT- In computing, a serial port is a serial communication physical interface through

  2. Computer study project outline - library and book club database.

    To encourage students to read more. 9. To help them find people with similar book interest. PLANNING- Choosing the idea (Topic Planning)- Before choosing this topic I thought of making a database on a book club but after few days an idea struck me why not make a database

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