UNIT 18 D2

for this task I will be concluding and the effectiveness of y database this will be in comparison to its original intention.

Some of the features that I have included in my database are simple queries, macros, reports,task dedicated forms like the payments form the registration form and able to create a new member into the database as these are the major aspects of a database. 

Also this includes validations which basically stops people from accessing data if they had spelt critical information incorrectly and an error message will appear, saying a phrase to the effect of "your too young to enter" these are present in most aspects of my database.

http://milney95.blogspot.co.uk/2012/11/unit-18-p7.html, this link takes you to a page where I tasted all aspects of my database and shows the effective testing of various components like the macros and input masks. 

one of the features in my database was a query, this is basically when you can search manually for a film or review. Then all of films or star ratings that you have searched will appear in a single table with all of the available data like the title, star rating, comments,particular film/ star rating. It is like the search engine of the database.
The screenshot below shows an Query in action and the overall process, that someone uses it to search for aspects of a film.

Macros have been induced into my database. 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. This helps to stop false inforation being produced and to stop members being created for illegitimate reasons.          

The screenshot above shows the macro in use and how it stops users leaving critical fields out in the signing up process. 

It was noted that the addition of a simple switchboard would greatly help so that a new member can navigate the database more easily, this includes a payments form for when a member wished to get a film. 

The above screenshot shows an switchboard into the database which is integrated to a database and these are just some of the improvements that I could make to my database 

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

Overall, my database works effectively because I have imported and exported data into tables such as when new members are being added to the system. 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 when there is a registration the correct input masks and protocols are properly in place so that no information can be left out and that the correct error messages show up. so to round it off overall my database is effective and shows a correct way of operating and runs to spec