D2 evaluation of database

To conclude on this database and to finalize on this unit, I will be evaluating my database and comparing it to its original intention, and that intention was to create a new member and to enter new data into the database.

The features that I have included in my database are parameter queries, macros, reports, certain forms like the payments form, registration form and able to create a new member and these are the major aspects of a database. Also I have included validations (which basically stops people from accessing data if they had spelt     incorrectly and an error message will appear, saying "your too young") and I have included these forms, queries, macros and reports because they are what a database needs to work and run effectively for new members.

The screenshot above shows that I have planned to test how well my database works with a predicted outcome and the actual outcome and as you can see the actual outcome actually exceeded the predicted outcome from the possible tests that I carried out and successfully completed.

In the features of my database I included a parameter query, basically a parameter query is when you can search manually for a particular film or star rating, then all of films or star ratings that you have searched will appear in a single table with all of the necessary data like the film title, star rating, comments, the username and the genre, this query basically searches for this particular film/ star rating.

The screenshot above shows that i have included the parameter query just to make it easier for the members to search for the film that they want to search then they can put their own comments in.

Also I have included macros into my database and a macro is basically to stop a potential member from missing out any fields in the registration form and therefore making an error message appear saying to fill out the empty fields. Basically adding a macro helps to get all of the potential information that is necessary to create a new member like their first-name, last-name (which will generate an automatic username with a few numbers and 3 letters from your first name and 2 letters of your last name), your address, town, county, postcode and your date of birth and all of these are essential for creating an account and the macro helps to stop any necessary fields being missed out.            

The screenshot above shows that I have included the macro into my database and it works properly and it restricts people from missing out certain data.

The suggestions that I would suggest improvements to would be to add a switchboard so that a new member can navigate the database more easily, a payments form for when a member wished to get a film. Also I have added the basic features that are necessary for a database like selected queries.

The screenshot above shows that I have attempted to include a switchboard into the database and these are just some of the improvements that I could make to my database and the buttons that I have attempted to create leads to different parts of the database. A switchboard is basically a form that holds many buttons that  goes to different places in the database. 

The screen shot above that shows the payments table that shows that I have created a payments form and in this payments form I have included an 'append query' and basically this form allows the members to purchase certain items and it basically links with the members table that I was given to import into the database.  

In conclusion, my database works because I have imported and exported data into tables, Eg when I am adding in new members into the members table then when a new member is created then it would add to the members table, also I have managed to include a new members section for when I am creating a new member, also I have successfully imported data into the films table. Finally I have successfully created a register members form for when a new member wishes to sign up to this database.