Database Skills for Applied GCSE Unit 1

In Applied GCSE ICT you will need to use database software for part of the Unit 1 examination, and possibly for your Unit 2 project.

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