D2

The media department at Kingswood school wanted us to help keep record of membership, payments and reviews as at the moment they are handwritten of their film club which has been running for 2 years. They show films every month, and students pay a small fee to become a club member.

I have successfully finished completed a database for their film club. I created forms, queries, macros, tables and the relationship between them.

I’ve followed the specification I wrote at the beginning of this project and I’ve recently just tested the database and it was successful as everything is running perfectly as a part of my P7.

The 4 points below featured in my spec have all been followed:

1. Take handwritten data and put in correct tables – I successfully appended the data into the newly created tables and so you can view all data in the set up that was simple and understandable.
2. Be able to add new member successfully – this was done by creating a registration form so new member can be put into the database.
3. I also created a query with this form so the data can be appended into the right table. After testing the form proved to work successfully so no improvements were made.
4. Report each month’s data – I created a report which allows me to view the data from a specific time period and open it in a word document so it’s easily printed.
5. Validation rules – as I was creating the form and tables I also included different types of validation rules, range check, presence check, list check, input mask and format checks. This was done because it has the data in a certain way that would be easier and a way that I’d prefer.  All the validations were also checked and it was successful.

Improvement

To make the database better and more organised there is a few improvements that I’ve made:

1. I made more forms, so there wasn’t just a member form I made a payment, film reviews form, this will help with the database as users will be able to make reviews etc. more advanced.
2.  I’ve made the database only editable to those with a password so that the database is never messed around with unexpectedly and only those with the password can access this. I did this by opening access office and opening the data base file by clicking the file tab using the open command, click the arrow next to the open button and then select open exclusive.
3. Adding a switch board will allow using the database easily like a website, I will do this so when the customers open up the database they will not have to looks through the database menus to find the form they need.
4. Disable menus will also help with securing the database so no one else can access the data.