D2 Updated

Database Evaluation

For this assignment I had to create a database that can store records for a film club. I have created a database that does so.

Tables

Firstly the data I used fro the database were in two notebook documents, I had to export the information into a members, payments, reviews and films table that I had to create. Then I created forms so the users of the database can put their own details in the database.

Forms

I created a members and payments form, I created a members form so the users can put in their own information and be registered into the form. A query I created runs to append the data into the database. I created a payments form so the users can put in their payments details into the database. Also a query runs to append the data into the database.

Validation rules and Macros

I put validation rules into my database, by doing this I had to create a macro so all my validation rules worked and so error messages pop up. I checked to see if all my validation rules in my forms all work. For this I missed out fields of my form and clicked ‘enter’ an error message came up telling me I need to fill in all the fields.  Also I checked put my age as 12 to see if my other validation rule is working. When I clicked ‘enter’ again an error message came up saying I am too young to join.

Buttons and Queries

I have put a buttons in my forms so when you type in all the correct information you click on it and a query runs to append all your data into the members table. I also checked all of my buttons in my switchboard work as well, by doing this I simply clicked on them and seen if they took me to the correct table or not. Also I checked my button in my payments form worked  which one takes you back to my switchboard. I needed to check if my button works in my payments table, when I click on it all my payments details append into my payments table. When I did this I checked in my payments table to see if all the information has appended into the table in the database. 

Reports

A report is used to show data from a certain area from the database. I created a report to show all the film reviews that the members have written. a report is very useful in this situation because you do not need a large amount of information from your database.

Improvements

I have been suggested to make a couple improvements to my database, these were to create a switchboard so the users will b able to get to the forms a lot quicker. The other improvement was to create a payments form so it would allow users to put in their payments into the database.  I have put screenshots to show that I have done this. Also i could put passwords to restrict certain parts of the database for users. i would do this so the users will not be able access the tables of the database and be able to mess up the database.