In this section, you must have 4 DIFFERENT techniques (you have have more but you only need to officially design 4).

When you write about them make sure you include all of these points:-

• TECHNIQUE used
• TABLE it is being used on
• FIELD it is being used on
• RULE being used
• ERROR MESSAGE to be generated

Example

Range Check - I am going to use a RANGE check on my ORDERS table with the field QUANTITY. On this field I will use the rule BETWEEN 1 and 8 as I only want to allow customers to purchase upto 8 tickets. If they exceed this amount I will produce an error message which will say "You are only able to buy upto 8 tickets, please select a number between 1 and 8".

A form can be hand drawn or designed with the word processing software. What it can't be is a screenshot of Access. You will need to design the following forms, keeping in mind, you should be abel to show them to me and I should be able to create them from your design exactly as you would want them i.e. they have all the information necessary for me including design features and what data:-

1. Main Menu - What buttons will go on here and where will they take you?

2. Structure diagram - Like Task 3 of your coursework last year, a map of all the forms and how they interlink from your menu menu forwards and then backwards,

3. Log-in box - what will it look like and how will it work

4. 2 x Forms - design only two of the forms you plan e.g. customer form and a stock form. Really important to think about the purpose of these forms, in order to decide what data will be put on the form and what buttons.

For this mark all the forms must have the following although anything that is the same throughout the forms can be put as a generic paragraph at the top underneath the main title. For example, if font style and size are the same or colour scheme of logo. Your designs must have the following:-

1. Clear Description - to show what the form is, what its purpose and its audience i.e. see paragraph on 2nd screenshot

2. What data? - Each design must have a drawing of the data which will be shown on the form and labelled to explain which TABLE and FIELD this data will come from

3. Example Data - each form must have example data in each box

4. Buttons - What buttons will be placed on the forms e.g. navigational and to quit, run a query, run a report etc

5. Formatting -Any colour or design features that are unique to that form or you haven't stated in a paragraph above.

Design of 8 different of queries. Each must have realistic reason/purpose and structure of the search criteria.

NB There must be 6 separate queries for 6 separate distinctive reasons. You cannot double up by saying a single query using a parameter counts as two marks. It is either a parameter query or a single table query and another would have to be done.

You could have three single table queries all controlled by a parameter if you wish but you must clearly indicate which are to be counted as the parameter query and which as the two single table queries. The same applies for multiple table queries.

Try and link these to your outputs. What are you going to OUTPUT - what will you need to search for.

1. Single table query with Search criteria - Searching ONE table in whatever way you want (this could be a parameter but can only count for this.

2. Single table query with logical operator AND, NOT, OR, LIKE and search criterion/criteria - The fieldname logical operator and search criteria must be clearly shown in the design.

3. Multiple table query using relational links - If you use these to create the calculated field. You will need to produce a separate calculation for calculation in report or form. NO SEARCH CRITERIA. This could be to select certain fields for a report, sort data, produce a calculation or a sales report for example.

4, Multiple table query using relational links with search criteria - More than ONE table, MUST have a search e.g. sales report between 2 dates, a specific order and its details, receipt.

5. Parameter query - Any amount of table and search but must have a box that appears {What surname do you need?}

6. Append or Delete or Update query - You only need to do ONE. APPEND - creates a new table with data, DELETE - deletes a customer or piece of stock for example. UPDATE - UPDATE - Changes all prices by 10% for example

7/8. - 2 x Queries using SQL code - Can create a new table, new fields or data.

You need to complete an overview of ALL the queries and then design each individual query in detail