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 1 - Creating a Database & Table Structure in Database.
At the end ( after finishing this module) In this Module Students will learn how to -
  1. Assign appropriate field/data types, for example: text,
  2. Numeric, (integer, decimal, percentage, currency),
  3. Date/time,
  4. Boolean/ logical (yes/no, true/false, –1/0)
  5. Use meaningful file and field names
  6. Format fields and identify sub-types like:
  7. Specifying the number of decimal places or a particular currency to be use.
  8. Importing external file in to database.


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.


Learning Tasks.
Phase 1 Importing External Data in to Database for manipulation
Using Microsoft Assess , Create a database file in your folder.
Import the CSV file in to database for manipulation in to the database file as table.
Make sure the data types are exactly as per the requirements.

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.

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.



Phase 2 Entering New Records in to Database for manipulation.


Phase 3 Creating Query for filtering Data.

Phase 4 Creating Report As per the requirements. (CIE Standards)


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
https://support.office.com/en-us/article/Access-2013-videos-and-tutorials-a4bd10ea-d5f4-40c5-8b37-d254561f8bce?ui=en-US&rs=en-US&ad=US