GCSE/IGCSE and AS/A Level ICT-Applied ICT

The skills you need to have learned for the exam are as follows:

• Know the difference between a record and field
• Use suitable field names
• Choose suitable data types
• Choose suitable field sizes
• Enter records
• Sort ascending in a table
• Sort descending in a table
• Search using =
• Search using <
• Search using >
• Print a table
• Print search results
• Print sort results
• Print landscape
• Print portrait
• Make sure data is visible
• Include header / footer
• Print certain fields
• Create a primary key
• Create forms
• Use forms
• Produce screen shots
• Produce reports
• Enter suitable titles on reports
• Print only certain fields in a report
• Add a report header / footer
• Make sure a report is fit for purpose
• Understand the purpose of validation rules
• Print to fit an A4 page
• Sort a date/time field in ascending order
• Sort a date/time field in descending order
• Use validation rules
• Use input masks
• Sort on two fields
• Search using <=
• Search using =>
• Search on more than one field
• Understand primary and foreign keys
• Set up a relationship
• Search on related tables
• Print selected fields from two tables