- Student table – containing personal information such as name and address.
- Course details – containing details on the type of course studied and possibly information on the course tutor.
- Attendance records – containing information on how often the student attends their specific courses.
Sources available to obtain relevant information:
Due to the exemptions of the data protection act 1998, personal information on any student would need to be accessed by a certain individual of authority or given consent by the actual students themselves. Thus, such data would need to be protected e.g. by means of placing a password on the database for extra security.
Since the data in question is only relevant to details on the students, it is not possible to obtain such information without their consent. For this particular exercise, I have disclosed my own personal information in the database as an example of how it should work.
Choosing appropriate layouts for purpose:
Since my purpose is to store personal information regarding college students, it would be appropriate to produce a database to display my intentions.
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:
COURSE_DETAILS:
ATTENDANCE_RECORDS:
Find:
Relevant information obtained from Mr Leeming in the form of exchanging Emails on what was required for the database.
Using automated routines
Automated routines were used in this project to help calculate the percentage attendances of each pupil.
The formula…
“=[Actual Attendances] / [Possible Attendances]”
…Was entered during the design of the form; the screenshots below show how and where the formula was entered…
Structures
This database is designed to store personal information on college students, to be used and accessed by an individual of high authority, i.e. a tutor.
The database can also be sent and received via e-mail and also the data can be printed out as a form in access…
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 refineChanges 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.
DatabasesThe 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.