CIE IGCSE - Cambridge International Examination - International General Certification of Secondary Education.Grade : For Age Group 14 to 16 ( ESL Students ) of Grade 10 ( Year 10 )
Subject Area : Information and Communication Technology - ( 0417 )
Section 11 : Topic - Data Manipulation.
After finishing this section student will learn,

  • Understand database structures.
  • Create a database from an existing data file
  • Define database structures.
  • Enter different forms of data into a database
  • Search for subsets of data
  • Produce a Report
  • Export data and reports for use within another package
  • Sort data within a database.

Module 4
At the end ( after finishing this module) In this Module Students will learn how to -
  • Create a calculated field, perform calculations at run time using formulae and functions, for example: addition, subtraction, multiplication, division, sum, average, maximum, minimum, count
  • Sort data using one criterion into ascending or descending order, using different field types, for example: alphanumeric, numeric, date
  • Perform searches using a single criterion and using multiple criteria, with different field types like alphanumeric, numeric, Boolean etc. and a variety of operators like: AND, OR, NOT, LIKE, >, <, =, >=, <=
  • Perform searches using wildcards
  • Produce reports to display all required data and labels in full
  • Set report titles,use headers and footers, align data and labels appropriately, produce different layouts, for example: labels
  • Format numeric data, for example: to display the number of decimal places, a variety of currencies, percentages
  • Show and hide data and labels within a report, show hidden fields, display calculations/formulae

Download Required Files.

Create A Folder on Your Desktop name it as Module 11 Your Name.
Download supporting files and instructions file from the following link, save these files in the folder you created.
Download for the Module supporting files by Click Hear the files are shared in Public Dirve from Public folder.

Learning Tasks.

Create a document to place the screenshot on to evidence document.
Make sure to place your name , number , class name as header for this document.
And in the footer File name with path, Page Number , Date & Time appear clearly.

Entering new data ( Adding New Records )
Add the three new records given in the instructions.

Making Query with criteria and adding new field.
Create Query with criteria ( Conditions ) , Adding New fields with Calculations.

Making Reports.
Create Report By Wizard basing on Query, Calculations at the bottom of the report.
Report header and footer need to be specially designed.
In reports page headers and page footers need to be designed.
Report by Grouping and Group totals. Setting up Sort orders.

Submission of Work.
Create A Folder called Module 11 in Your SkyDrive now (OneDrive) or DropBox.
Upload the screen shot document and share with me ravurupaul@hotmail.com

Watch the video for any kind of help






For further references :
1. https://www.udemy.com/igcse-ict - You can Join in Free Course .
2. https://www.sophia.org/groups/7957 - You can Join in the course by entering the code : b705bd
3. http://office.microsoft.com/en-us/training/get-to-know-access-RZ006118141.aspx
4. http://www.quackit.com/microsoft_access/tutorial/
5. http://www.freeofficetutorials.com/MSAccessTutorials/section1/lesson_1.html
6. http://www.tutorialspoint.com/listtutorials/ms-access/1