Note:

Create a database Structure IGCSE ICT Topic Questions

18.1 Create a database structure Candidates should be able to: Create an appropriate database structure Notes and Guidance Import data from existing files (including .csv, .txt) using specified field names to create tables Set appropriate data types to fields including text, numeric (integer, decimal, currency), date/time, Boolean/logical Set sub-types of numeric data including percentage, number of decimal places Set display format of Boolean/logical field (yes/no, true/false, checkbox) Set display format of date/time data Create and edit primary and foreign keys Create relationships between tables Create and use a data entry form Create a data entry form including specified fields, appropriate font styles and sizes, appropriate spacing between fields, character spacing of individual fields, use of white space, radio buttons, check boxes, drop down menus Candidates should know and understand: Types of database Characteristics, uses, advantages and disadvantages of a flat file and a relational database Primary and foreign keys Characteristics of primary key and foreign keys Form design Characteristics of good form design

18.2 Manipulate data Candidates should be able to: Perform calculations Notes and Guidance Use arithmetic operations or numeric functions to perform calculations including calculated fields, calculated controls Use formulae and functions to perform calculations at run time including addition, subtraction, multiplication, division, sum, average, maximum, minimum, count Sort data Use a single criterion, or multiple criteria to sort data into ascending or descending order Search and select data Use a single criterion, or multiple criteria to select subsets of data using a query perform searches using a variety of operators including AND, OR, NOT, LIKE, >, <, =, >=, <=, <> perform searches using wildcards 

18.3 Present data Candidates should be able to: Display data Notes and Guidance Produce reports to display data including displaying all the required data and labels in full Use appropriate headers and footers within a database report including report header, report footer, page header, page footer Set report titles Produce different output layouts including controlling the display of data, labels, tabular or columnar format Align data and labels appropriately including right aligning numeric data and decimal alignment Control the display format of numeric data including number of decimal places, currency symbol, percentage