P7

M4/P5/ Part P6

We first opened a design view of the query. We then appended first name, last name , dob ,address line , town, county and postcode. 

One run is clicked this appeared and we then went to query design selected the specific information and created the query.

I then designed it to my personal tastes then exported the query data to Microsoft word. 

M4 / P5

In the first shot we can see that the code I have entered into my macro stopped the user from sending off null data to the database. Below we can see the code I have entered , plus the error message box to stop the user from doing this! "IsNull" states that if the field name is empty then the error message I set up will pop up and data will not be appended to my tables.

Below we can see a validation rule I have entered for age. This is the error message I have set in place for underage users and older age users to stop them from entering the database. 

P4/ Part P6

Forms allow users to sign up for the database or allow users to enter data into the database.

P3

M2

P2