P7

Report

P6

validation rule

This is the validation rule to notify the user if they are to young to be accepted.

P5

This query takes the information we need from selected fields within multiple tables and organizes them into one table.

Screenshots

These slides show me creating the form.

We unbound the fields by clicking on them and deleting the text, this meant we could change what was inside. We put a code into the username field so the database generates a username for each user. It takes three from the first name and then continues to take two from the last name ,it does this by selecting the fields and then the

Screenshots

These are the tables each in design view. This shows the fields and the specific data types for each one. It also shows the validation rules that have been set in place.