LO5: 5.1.2 Database Software (Microsoft Access)

Book Activities

FunctionPageActivity FileLOSupportVideo
Database tables110-111 Database tables 5.1.2.a DatabaseTables
Data types
Relationships111-112 Relationships 5.1.2.a Relationships
Data validation techniques112 DataValidationTechniques 5.1.2.c Validation techniques
Presence check112 PresenceCheck 5.1.2.c.i Presence Check
Length Check112 LengthCheck 5.1.2.c.ii Length Check
Range Check112 RangeCheck 5.1.2.c.v Range Check
Format Check112 FormatCheck 5.1.2.c.iii Format Check
Input Masks112 InputMasks 5.1.2.c.vi Input Masks
Input forms113-114 InputForms 5.1.2.d.i Input Forms
Controls114 Controls 5.1.2.c.ii Controls
Querying a database115 QueryingAdatabase 5.1.2.e Querying a database
Crosstab115 Crosstab 5.1.2.e.iv Crosstab query
Criterion115 Criterion 5.1.2.e.iv Criteria Query
Parameters115 Parameters 5.1.2.e.iii Parameter Query
Complex115-117 Complex 5.1.2.e.vi Create a query based on multiple tables
Calculation queries117 Calculation queries 5.1.2.e.v Sum Calculation Query
Grouping information in Access117 GroupingInformationInAccess 5.1.2.e.v Grouping data
Database Security117 DatabaseSecurity 5.1.2.g User level Access
Importing data117-118 ImportingData 5.1.2.b Importing Data
Exporting data117-118 ExportingData 5.1.2.h Exporting Data
Cambridge National Level 1/2 Information Technologies - Hodder Education - Sonia Stuart & Brian Gillinder