Slide 1

OCR Nationals ICT Unit 1Task 6 Grade ATask Overview.

In this task, you will update and use a database file called Hosts, which you will need to download and save. This database contains details of host families who are able to accommodate staff and students when they are in Paris. You will enter, edit and delete data appropriate to the needs of the French department. You will search for data relevant to the trip and for the higher levels you will also sort data and print report(s). Using the Booklet.

This booklet contains everything you will need to complete this task, divided up into 2 sections.

RED SECTIONS Explain exactly WHAT you have to do.GREEN SECTIONS - Give you the space to put your evidence

Task 6 U1T6S2 Unchanged databaseYou need a screenshot of your unchanged database TABLE here before you start.

OCR Nationals ICT Unit 1Task 6 Grade ATask 6 Part APart AUpdate the database as follows:

A new host family has just joined the exchange scheme. They live in the St Germain district and can accommodate 2 guests. They offer vegetarian cuisine, have 1 child and speak English. Their rating is excellent and they have been allocated Reference F1300. Add a new record for this host family. Edit the record for F1101 this family are now able to accommodate 2 guests. The host family with the reference F1909 has withdrawn from the scheme. Delete this entire record from the database.

Check your amendments carefully to ensure that you have not made any errors.

OCR Nationals ICT Unit 1Task 6 Grade A

Task 6 Part A1 U1T6S4 First changeUsing text and images, explain the first change you made to the database.

OCR Nationals ICT Unit 1Task 6 Grade ATask 6 Part A2 U1T6S5 Second changeUsing text and images, explain the second change you made to the database.

OCR Nationals ICT Unit 1Task 6 Grade ATask 6 Part A3 U1T6S6 Third changeUsing text and images, explain the third change you made to the database.

OCR Nationals ICT Unit 1Task 6 Grade ATask 6 Part BPart BThe trip organisers would prefer to place students with hosts who have an excellent rating. The trip organisers will need to know the host reference, the district where the hosts are located and how many guests the host is able to accommodate. You must create and save a query to find this information. You should display the data in alphabetical order of district.

OCR Nationals ICT Unit 1Task 6 Grade A

Task 6 Part B U1T6S8 Query designUsing text and images, show the design of the query you created.

OCR Nationals ICT Unit 1Task 6 Grade ATask 6 Part B U1T6S9 Query resultsUsing text and images, show the results of the query you created.

OCR Nationals ICT Unit 1Task 6 Grade ATask 6 Part CPart CPresent the results of this query in a suitable report.

Once you have created the report, you should save it as a PDF and send it to me.

OCR Nationals ICT Unit 1Task 6 Grade A

Task 6 Part C U1T6S11 ReportUsing text and images, show how you created the report.

OCR Nationals ICT Unit 1Task 6 Grade ATask 6 Part DPart DSome students have special dietary requirements. The trip organisers would like to find out which hosts offer Vegetarian, Vegan or Halal cuisine. The trip organisers will need to know all the information about each of these hosts. Create and save a query to find this information.

This query should display the data in numeric order of the number of guests that can be accommodated.

OCR Nationals ICT Unit 1Task 6 Grade A

Task 6 Part D U1T6S13 Query designUsing text and images, show the design of the query you created.

OCR Nationals ICT Unit 1Task 6 Grade ATask 6 Part D U1T6S14 Query resultsUsing text and images, show the results of the query you created.

OCR Nationals ICT Unit 1Task 6 Grade ATask 6 Part EPart EPresent the results of the query in Part D in a suitable report.

You must choose a different report format from the one that you used for your first query.

Once you have created the report, you should save it as a PDF and send it to me.

OCR Nationals ICT Unit 1Task 6 Grade A

Task 6 Part E U1T6S16 ReportUsing text and images, show how you created the report.

OCR Nationals ICT Unit 1Task 6 Grade Au1t6a-1null40620.28eng - iTunPGAP0eng - iTunNORM 000003B4 00000000 00002623 00000000 00005C8D 00000000 00005F9F 00000000 00002FDB 00000000eng - iTunSMPB 00000000 00000210 0000099C 00000000001B49D4 00000000 0004EEDC 00000000 00000000 00000000 00000000 00000000 00000000u1t6a-2null38765.684eng - iTunPGAP0eng - iTunNORM 000003B2 00000000 00001B05 00000000 0000535E 00000000 0000587C 00000000 00003CD0 00000000eng - iTunSMPB 00000000 00000210 0000089C 00000000001A0B54 00000000 0004B4E6 00000000 00000000 00000000 00000000 00000000 00000000u1t6a-3null20114.277eng - iTunPGAP0eng - iTunNORM 0000037D 00000000 0000169F 00000000 000029F0 00000000 00005A9A 00000000 00003700 00000000eng - iTunSMPB 00000000 00000210 00000788 00000000000D7F68 00000000 00026E0B 00000000 00000000 00000000 00000000 00000000 00000000u1t6a-4null8829.403eng - iTunPGAP0eng - iTunNORM 00000397 00000000 00001096 00000000 0000199C 00000000 00005AE1 00000000 00001DE5 00000000eng - iTunSMPB 00000000 00000210 00000B6E 000000000005E382 00000000 00010D64 00000000 00000000 00000000 00000000 00000000 00000000u1t6a-5null22413.105eng - iTunPGAP0eng - iTunNORM 0000039F 00000000 000017C1 00000000 000054CB 00000000 000057F8 00000000 00001053 00000000eng - iTunSMPB 00000000 00000210 00000852 00000000000F0A9E 00000000 0002B5E1 00000000 00000000 00000000 00000000 00000000 00000000u1t6a-6null13870.963eng - iTunPGAP0eng - iTunNORM 00000360 00000000 000012AA 00000000 000000EB 00000000 00005ABF 00000000 000031B1 00000000eng - iTunSMPB 00000000 00000210 00000960 0000000000094A10 00000000 0001AAF1 00000000 00000000 00000000 00000000 00000000 00000000