Unit 18 D2 (screenshots)

Unit 18 D2

The original intention of the database was to create an electronic system for keeping all records for each member of the school film club. My database holds all of the records for members, each film shown for each month, each member’s payments, and all of the members’ reviews. I have also added a form which allows new members to sign up to the film club and there is an age generator to restrict people who aren’t at a suitable age from signing up. From the functionality tests you can see that all of these features work properly in my database and makes information easier to add and to store.  I could improve the database by adding more features to it as it doesn’t cover everything it has to, for example, a form for members payments, this would allow more of the records to be transferred from paper to an electronic system.

 I could also add a switchboard which would make it easier to navigate around the database. The switchboard would be made up of buttons that can lead you to forms, reports, queries etc. by adding these two features to the database it means less information will be stored on paper making it more secure and it will also make the database more efficient as it will be quicker and easier to find what you’re looking for.

Adding a form for members payments would be done the same way as the members table was, adding the information necessary then adding the data to the payment table in the database. This could be improved further by allowing members to pay through an online service such as PayPal which would be more secure than just paying by hand. This way there would be a more reliable record of which members have made payments each month.