Task 5
Calculate the age of the new member and display it on the form.
Create an automated method of saving the new member’s details that is operated by clicking a “register new member” button.
The record should only be saved if:
- The member is 15 years of age or older (this year)
- They have included all details on the from
Error messages should be produced if they are too young, or leave any fields blank.
Show your code or macros in design view as a screenshot. Show the error messages that are generated.
(part p5)(part P6) (P4)(M4) Deadline 14th November
LO(P4): Learn how to create features in data entry forms to ensure validity and integrity of data.
LO(P5): Understand how you perform queries using multiple tables and multiple criteria.LO(P6): Explore ways to include an advanced feature in a database design.LO(M4): Explore ways of implementing an automated function to your database.
LO(P5): Understand how you perform queries using multiple tables and multiple criteria.LO(P6): Explore ways to include an advanced feature in a database design.LO(M4): Explore ways of implementing an automated function to your database.
this box has the code that will make my table recognize the age of someone so this means that my append query will know if someone is under the required age this will make the database rejects or accept someone depending on there age
this is the error message that popped up when i put the information into the log in form and it says sorry you are too young and this shows that the formula to check the users age works
this is what happened after i ran the querie this shows all of the fields that were required so now you can see all the information for a selected movie so you can see everything that could help you decide if you want to get that movie
this is the macro i did this helps make the database automated and it makes it so it can check inputs without human interaction this can not only make the process faster but it can also remover the factor of human error because the macro has been checked and i know that it works so this will help me make sure that everyone is over the age of 15
this is the macro i did this helps make the database automated and it makes it so it can check inputs without human interaction this can not only make the process faster but it can also remover the factor of human error because the macro has been checked and i know that it works so this will help me make sure that everyone is over the age of 15
www: the validation of 'too young' members shows you have learnt how to create features in data entry forms to ensure validity and integrity of data. M4 achieved.
ReplyDelete