OCR+Nats+U1+-+AO6


 * AO6 - Database **

Unit 1
In your word report you should provide screenshots/explanations under the AO6 section. The italics in this section show you what to add as evidence

Your teacher will tell you where you can access the database from.

**Pass **

//Add a screenshot of the table before you make any changes. Explain that this is the original table before you made any changes //


 * 1) Enter the following details for a new customer – the customer number is generated automatically


 * **Surname ** ||  **Forename **  ||  **Title **  ||  **Address1 **  ||  **Address2 **  ||  **Town **  ||  **County **  ||  **Postcode **  ||  **TelephoneNo **  ||  **<span style="color: black; font-family: 'Arial','sans-serif'; font-size: 13px;">BookingType **  ||
 * <span style="color: black; font-family: 'Arial','sans-serif'; font-size: 13px;">Rose || <span style="font-family: 'Arial','sans-serif'; font-size: 13px;">Simon || <span style="font-family: 'Arial','sans-serif'; font-size: 13px;">Dr || <span style="color: black; font-family: 'Arial','sans-serif'; font-size: 13px;">346 Royal Avenue ||  || <span style="color: black; font-family: 'Arial','sans-serif'; font-size: 13px;">Billericay || <span style="color: black; font-family: 'Arial','sans-serif'; font-size: 13px;">Essex || <span style="color: black; font-family: 'Arial','sans-serif'; font-size: 13px;">CM13 8CW || <span style="color: black; font-family: 'Arial','sans-serif'; font-size: 13px;">01277 836463 || <span style="color: black; font-family: 'Arial','sans-serif'; font-size: 13px;">Weekend ||


 * 1) <span style="font-family: 'Arial','sans-serif'; font-size: 13px;">Delete the record for Andrew Cosgrove
 * 2) <span style="font-family: 'Arial','sans-serif'; font-size: 13px;">Jill Brown has recently married – change her details to Mrs Jill Ormorod

//<span style="font-family: 'Arial','sans-serif'; font-size: 13px;">Add a screenshot of your changed table explaining the three changes you have made. //

<span style="font-family: 'Arial','sans-serif'; font-size: 13px;">Create one query showing all of the customers that live in Billericay

//<span style="font-family: 'Arial','sans-serif'; font-size: 13px;">Add a screenshot of the query in design view and a screenshot of the query results and an explanation of what the query shows. //

**<span style="color: fuchsia; font-family: 'Arial','sans-serif';">Merit ** =<span style="font-family: 'Arial','sans-serif'; font-size: 13px;">Create a query showing customers who live in Basildon, sort this into alphabetical order on the Surname field. Only include sensible fields. = //<span style="font-family: 'Arial','sans-serif'; font-size: 13px;">Add a screenshot of the query in design view and a screenshot of the query results and an explanation of what the query shows. //

<span style="font-family: 'Arial','sans-serif'; font-size: 13px;">Create a report from your Basildon query. This report should be in the format of a list.

//<span style="font-family: 'Arial','sans-serif'; font-size: 13px;">Printout this report to include when you hand in your work. Annotate this report to make it clear what it shows. //

**<span style="color: lime; font-family: 'Arial','sans-serif';">Distinction ** =<span style="font-family: 'Arial','sans-serif'; font-size: 13px;">Create a query showing all the customers who live in Basildon and have made a Weekend booking, sort this into alphabetical order on the Surname filed. Only include sensible fields = //<span style="font-family: 'Arial','sans-serif'; font-size: 13px;">Add a screenshot of the query in design view and a screenshot of the query results and an explanation of what the query shows. // =<span style="font-family: 'Arial','sans-serif'; font-size: 13px;">Create a report from your new query. This report should be in the format of address labels. = <span style="font-family: 'Arial','sans-serif'; font-size: 13px;">Printout this report to include when you hand in your work. Annotate this report to make it clear what it shows.