• 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 saves a lot of annoyance in having to find the 'correct spot'. Sky also comes with other forms of entertainment. It gives you interactivity via the red button with certain channels. This gives me the chance to win items and competitions and take part in something challenging.

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

    There are two main types of observation direct and participant. Direct observation is also known as overt which means that it is obvious and the observation is not hidden as every one knows that they are there watching, and identifies the reason why they are watching.

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

    * Reducing errors in the input through changes of the forms and display screens * Reducing redundant output * Reducing redundant storage * Improving the borrower's service. * Increasing the library assistant's morale. * Supporting the competitive strategy of the library.

  2. ICT Report 2b: ICT in Organisations

    Considering the whole computer is present and is up against a wall with the port on the rear end, it is a lot easier and more comfortable to plug in the socket to the port without looking directly at it.

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

    Recommendations for Development The first thing to decide is what software is required to make and run the database. The main two choices are: Word Advantages: If you are skilled in the use of a computer word processor, you can appreciate its many advantages.

  2. Database design.

    The line shows they are joined. Creating the forms To create the form you click new and this window will appear at this click form wizard and choose the table or query where the data comes from at the bottom of the window When you fill in the data's table or query this window will appear.

  1. Database Analysis and Database Design Project - DVD library for moving images.

    The management of Moving Images is requesting prototypes from different designers. Database will allow the user to enter new and view existing information in to the system using Microsoft Access. USER REQUIREMENTS These are the specification for the system, what the user needs to get from the system > Add

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

    tell a good book?s review we get excited and try to find the book in the library or try to search that book in a book store. With Search a Book the student can check whether the book is in the library or not if not then the person can see where they can buy the book.

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