| |
MS
ACCESS TRAINING
Learn
by constructing a fully-functioning and user-friendly
database, which works in the way you want it to..
Learning
takes place by
taking the client through the construction of a relational database that
functions in the way the client chooses.
This training usally
operates on a one-to-one basis, but up to four delegates may may be
trained as a group if the same database is constructed. Techniques are
taught as the need arises. A workshop instruction booklet, reflecting
the stages of operation, is compiled as the session is in progress,
and then supplied to delegates afterwards. A broad sequence of progression
is given below.
Basics
- Database concepts
with reference to Access terminology: entity, record, field, data types,
table, form, query, report.
- Planning the structure
of a relational database
- Simple form construction
- Simple subforms
- Combo (drop-down)
boxes
- Simple queries
- Simple reports
- Making a database
user-friendly (menu buttons, simple macros)
Improving
- Using queries in
association with forms and reports
- More complex queries:
series of queries, delete queries, make-table queries, append and amend
queries
- More complex reporting:
using grouping levels, calculating totals and subtotals, subreports
- Using queries in
association with dialog boxes
- Writing simple
code
- Useful functions:
sum, avg, dlookup, dsum, dcount
|
|
