Task 7

Design a test plan that will allow you to test the full functionality of your database, including validation, error capture, error messages, and successful entry and manipulation of normal data. Create test data that can be used to test your database functions.

Carry out the tests you have planned and show the resulting screenshots

(P7) Deadline 6^th December

LO(P7): Explore ways of testing a relational database.

Task 6

Create a query that will show film reviews that have been written for the months of January, February, March and April. The result must show:

• Who wrote the review
• Their comments
• The star rating they gave
• Film information

Show the query as screenshot of the design view.

Create a report based on the query that shows the results in an easy to read format

(part P5)(part M3) Deadline 20^th November

LO(P5): Understand how you perform queries using multiple tables and multiple criteria.
LO(M3): Learn how to export data to an external source.

Export the reviews to a Microsoft Word document. (part M3)

LO(M3): Learn how to export data to an external source.

in this i am making a new query for the form so i will be able to have the information go to the correct places



this is the queries that will take the information from multiple tables and will show the selected fields so we will be able to get the information that we require 

this shows the selected fields from the tables and how i was able to choose the fields from the tables with the information that i required

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 that data that i was able to export to word so it will be easier to move and can be reviewed on word so people will not need to use access

Task 5

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 14^th 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.

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

i have the buttons added so i can quickly and easily add the information to my database and this is the information that i added to my form and so i will be able to see if if an error message pops up

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

task 4

Create a form to allow new members to register by entering their personal details (name, address, DOB). The form should not show other members personal details. (P4) Deadline 9^th October.

LO(P4): Learn how to create features in data entry forms to ensure validity and integrity of data.

Generate a username for the new members and display it on the form. The username consists of: the first three letters of the first name, the first two of the last name, and a sequential number one higher than the last number assigned. (part P6) Deadline 12^th October.

LO(P6): Explore ways to include an advanced feature in a database design.

this is me starting to make my form for the database this will be what people see and what is the face to the data base so this will need to be easy to navigate and simple so people will know were to put the information that will be added to my database

i opened the field list so i would be able to see the fields that i wanted on my form

i selected the fields for my form from this list i double clicked them so they would be added to my form

after they were all selected they were now on my form so this will be the way people put the information into my database

i unbound the boxes so the information can be put in them and go to the correct place

i added the rule for username this made it so it would take the first 3 letters from the left of the first name and the first 2 letters from the left on the last name and then it adds a number thats numerical value goes up by one each time

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

Task 3

Having designed your database structure, populate the tables by entering example data that satisfies the validation rules.Provide annotated screenshots to show how you have done this. (P3) Deadline 5th October

LO(P3): Understand how to create and populate a database.

You have been provided with data in the form of text files containing details of members, payments, films and reviews.

Import this data and populate you database tables using append queries. Show that you have done this successfully by providing annotated screenshots of the steps you take, and of the populated tables in datasheet view. (M2) Deadline 8^thOctober.

LO(M2): Learn how to import data from an external source into your database.

this is creating a query for films in this section i will pick the fields that correspond to the table



with the query created the data is linked to the matching fields so now i have the information needed in the table

for this query i am taking the information from the members_exam table to append the data to the members table

this is the query with the chosen fields selected now i will append this data to the members table

this is a validation rule on microsoft access that wants me to confirm that appending the data is what i want to do

this is the members table with all of the information in it now i have both the films and members tables with the data in them