Second normalised form
This selection table would enable students to do more then one course on the database.
Third normalised form.
You then have to link the tutors in with the courses. To do this you will create a totally different table but link the primary key in with the course table.
Original Table Design
1st Amended Table Design
The system I will be using
Constraints and limitations
As I will be doing work at home and at 6th form I may experience a few constraints. For example at home I have Microsoft word 2000 whereas at 6th form they have the 97 edition. This can prove to be a problem, as I cannot take work to and from 6th form to complete at home. This means that I will have to complete all word documents either at home or at 6th form. This is only a minor problem which I can overcome by selecting work to take home as I have access 97 the same as the 6th form. If I know I have to do a word document and I may have to take it home I will do it at 6th form rather than other work which I can take home. I will have to manage my time.
My second slight limitation is that other classes in the school often book the computer rooms at 6th form. This can mean that I am not able to work on a computer at certain times. This can be a problem but I can over come this by writing it up on paper in a study room and then type it up at a later date. This can be frustrating by something that you cannot do anything about so you have to live with it. Also if a student is away in another class then there may be the odd spare computer I can work on.
Apart from these there are not many other problems that I think I will encounter. Also these can be overcome with ease.
My ICT skills
I have studied ICT at GCSE level and gained a level ‘B’ at the subject. This helps as I have done pervious work with the programs at a high level. I also work on my home computer regularly and pick up skills.
Screenshots of my database
Screenshot 1: Bookings Table
Screenshot 2: Courses Table
Screenshot 3: Members table
Screenshot 4: Tutors table
Screenshot 5: Front page
Screenshot 6: Student link from front page
Screenshot 7: Tutors link from front page
Screenshot 8: Bookings link from front page
Screenshot 9: Application from for new members
Screenshot 11: Add new tutor form linked from tutor’s page
Screenshot 12: Change tutor details linked from tutor’s main page
Screenshot 13: New bookings linked from bookings main page
Screenshot 14: Delete booking linked from bookings main page
Screenshot 15: Check bookings query, linked from ‘check bookings for course’ button
Screenshot 16: Result of running query shown above
Screenshot 17: Macro needed for ‘add new member’
Screenshot 18: Macro needed for ‘add new tutor’
Screenshot 19: Macro needed for ‘new bookings’
Screenshot 20: Design of query for course query
Screenshot 21: Main relationship
Evaluation
- Data can be viewed, recalled and saved easily.
I have met this requirement as I can view and recall data through queries and forms and save data through my forms using macros. If I had a criticism it would be that more queries are needed to access all data easier than now. All records can be viewed using forms based off information tables. This means that I have all the information there is and that it is in a format which is easy to use and view. Also I can use my action and navigation buttons to move around easily.
- Data can be easily updated or changed, changing all data in database. For example a booking change in a members records would change a booking in the tutors records, with only putting the data in once.
I have fulfilled this requirement as I can do this. This is because I have my relationships between all tables, linking them so if I change a piece of information in one form then it will automatically changed in all other concerning the matter.
- Mistakes will be easily to spot, with database flagging up any un-normal inputted data.
I have tried to reduce the possibility of human error when imputing data or changing data. I have done this with input masks. I have added input masks to most date, time and telephone number fields in my forms so if it dopes not meet a certain criteria then it will flag it up and not accept it. An example of a input mask when ‘wrong’ data has been inputted.
- Must be able to print out which course tutors teach and when they are.
My query will help with this once you have searched for a course, it takes you to a screen which allows you to print out the data. I did add a query and from combo in which once the data is searched for it automatically prints the data. Once I had this in place realised that it may be a nuisance to the end user, as they may not want a print out all the time so I thought that I would leave it up to the. If it printed out automatically it may waste paper and ink therefore cost the business money.
User guide
Introduction
The database will open on the front page. When you want to do something the first place you need to go is the main page. This has access to all you will need to do. As you will see there are three buttons, ‘Students’, ‘Tutors’ and ‘Bookings’. Each will link you to the part of the database you need. For example if you wanted to make a booking then you will need to click on the bookings button.
Once you have clicked on anyone of these you will then get a specialised menu for each section. For example if I clicked on bookings I would get a list of options for bookings like this:
You then have a list for what you may want to do. When you click on these you will be linked to a form which will allow you to input or browse information easily. For example if I clicked on ‘New Booking’ in the bookings section I would get a form which allows you to input new information for a new booking. This is what it would look like;
That’s the basics I will now show you how to do some of the most common tasks.
- Adding a new student or tutor:
Open the database, as members are under the student section click on students, if you want to add a new tutor then just click on tutors. Both are the same, below are instructions for adding a new student but adding a new tutor is exactly the same so just follow the same instructions but just with ‘tutors’.
You will then need to click on the ‘New Student button’ this will link you to a form which will allow you to put in information so a new member is added. The from has a macro linked to it so you will always get a blank form when you click this button. If you want to browse other details then click on the 2 buttons, ‘Previous record’ or ‘Next record’. The page you get will look like this;
Once you have inputted all the information you want just click on ‘Save record’ and the information will be saved. Then click on close form and you will go back to the students menu, if you do not want to be here either then click on ‘Back to the main screen’ which is on every selection screen. This links you back to the main menu so you can choose what you want to do next.
- To change details of students or tutors:
Again changing students or tutors details are done is the same way. Below are a list of instructions for changing tutors details but again, if you want students then you will have to follow the same instructions but just with ‘Students’.
Click on the ‘Tutors’ button on the main page, this will link you to a tutors menu just like the ‘students’ one. Here you can add a new tutor or change a existing tutors details. To change details just click on the ‘Change Tutor Details’ button as shown below.