Function | Page | Activity File | LO | Support | Video |
---|---|---|---|---|---|
Database tables | 110-111 | Database tables | 5.1.2.a | DatabaseTables Data types |
|
Relationships | 111-112 | Relationships | 5.1.2.a | Relationships | |
Data validation techniques | 112 | DataValidationTechniques | 5.1.2.c | Validation techniques | |
Presence check | 112 | PresenceCheck | 5.1.2.c.i | Presence Check | |
Length Check | 112 | LengthCheck | 5.1.2.c.ii | Length Check | |
Range Check | 112 | RangeCheck | 5.1.2.c.v | Range Check | |
Format Check | 112 | FormatCheck | 5.1.2.c.iii | Format Check | |
Input Masks | 112 | InputMasks | 5.1.2.c.vi | Input Masks | |
Input forms | 113-114 | InputForms | 5.1.2.d.i | Input Forms | |
Controls | 114 | Controls | 5.1.2.c.ii | Controls | |
Querying a database | 115 | QueryingAdatabase | 5.1.2.e | Querying a database | |
Crosstab | 115 | Crosstab | 5.1.2.e.iv | Crosstab query | |
Criterion | 115 | Criterion | 5.1.2.e.iv | Criteria Query | |
Parameters | 115 | Parameters | 5.1.2.e.iii | Parameter Query | |
Complex | 115-117 | Complex | 5.1.2.e.vi | Create a query based on multiple tables | |
Calculation queries | 117 | Calculation queries | 5.1.2.e.v | Sum Calculation Query | |
Grouping information in Access | 117 | GroupingInformationInAccess | 5.1.2.e.v | Grouping data | |
Database Security | 117 | DatabaseSecurity | 5.1.2.g | User level Access | |
Importing data | 117-118 | ImportingData | 5.1.2.b | Importing Data | |
Exporting data | 117-118 | ExportingData | 5.1.2.h | Exporting Data |