• 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. Peer reviewed

    Verification, validation and input masks

    4 star(s)

    For example when filling in a form, if the question "what sex are you" was asked, there are only two possible answers, male or female, so we know that the maximum number of letters that could be entered into this field would be 6.

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

    The satellite dish receiving channels outside is vulnerable to weather and other interruptions. This can cause your service to be temporarily stopped. This is usually hard to fix as it's often out of your control. The weather is something natural and the satellite aerial is usually on the roof.

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

    Method : Direct observation Describe this method Direct observation is when you study what people do and how they behave by watching them in their everyday life. The observer would observe from a distance and will not become involved in what the group is doing.

  2. This project is designed to help non-computerized library to easily keep track of their ...

    the librarian * E-mail can be used to flag themembers when the books are available * CD-ROM, internet and external-database searches will add to the considerable arsenal of available methods of search. DISCRIPTION OF OTHER POSSIBLE SOLUTIONS AND THEIR EVALUATION * Employ more employees.

  1. Access Database

    diagram * The database will be 'normalised' so each table has its 'appropriate' data I will check that each table has its own headings so that it is user friendly and will check it in design view * Create Forms to gather data/reduce mistakes I will open the forms and

  2. Ict Unit 2b

    able to run multiple peripherals on their computers without the hassle of physically installing boards, manually allocating system resources, individually configuring devices, and powering the computer up and down every time equipment needs change. With USB cable, up to 127 individual peripheral devices can be connected to a host computer using a single interface and a system of USB hubs.

  1. task2-report-template 3

    3 DESIGN [TOTAL: 12 MARKS] 3.1 Produce Designs for the Data Structure [3 marks] 3.1.1 Data Structure [1] Field Name Field Type Field Length Model Text String Brand Text String Processor Type Text String Memory Size Number Integer Hard Drive Capacity Number Integer New or old Text 3 Price Currency

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

    2. It will allow students and teachers to see what their friends are reading or already read.

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