|
Session 1
Introduction to the course
Discussion of needs
Session 2
| Setting
datatype of fields and consequences of same
|
| Lookup
values
|
| Validation
rules
|
| Input
masks
|
| Default
values
|
| Mandatory
fields
|
| Creating
and applying relationships to simulate real life situations
|
| Modifying
relationships and using referential integrity
|
| Inner.
Outer and self joins
|
| Deleting
related records automatically
|
Session 3
| Select,
update, make-table, delete and append queries.
|
| Relating/joining
queries
|
| Grouping
data in a query result
|
| Parameter
query / Crosstab query
|
| Using
SUM, AVERAGE, MIN, MAX and COUNT in queries
|
| Arithmetic
and logical (including NULL NOT) expressions in queries
& Wildcards
|
| Show
duplicates/unmatched values
|
| Highest
lowest range of values in a query
|
|
 |
Session 4
| Creating
forms with bound and unbound controls
|
| Create
and edit list boxes, combo boxes, check boxes and option
groups
|
| Create
arithmetic and logical expression controls on a form/report
|
| Set
sequential order of controls on the form
|
| Insert/Move
a date field to any part of a form/report design
|
| Create/Modify
a subform linked to a parent form
|
Session 5
| Create
logical or arithmetic calculated controls on a report
|
| Use
simple standard formulas on a report to calculate
|
| Create
running report summaries
|
| Force
page breaks where required on a report
|
| Record,
run or assign a macro to a form, report or control
|
| Import/Export
data in xls, csv, dBase, or Paradox format
|
| Link
external data
|
Session 6
Revision
Advanced ECDL sample Exam Examination
|
|
