label

Tuesday, 6 November 2012

P7


TEST
EXPECTATION
ACTUAL
VALIDATIONS
Should stop certain actions being entered or happening
AN ERROR MESSAGE APPEARS SAYING “SORRY TOO YOUNG” AFTER THEY HAVE ENTERED THEIR DATA.
Error capture
It should find any errors that might appear in the database and tell you if one with either a sound or a message has. 
My database finds and shows any errors by showing an error message
Error message
If the person should enter incorrect data then a message should appear telling you there is an error
The database that I created shows a message if there is an error by using the error capture
Successful entry
Macros and queries should be to their standard and therefore you should be able to create a new member.
I can successfully enter new members and their details without fault.
Manipulation of normal data
Search a movie title then the movie that you have entered will appear by using an append query to move the data into the selected tables.
I managed to transfer all of the necessary data to the right location (via Queries) and I can also search for certain star ratings or films.

1 comment: