Training in database construction using MS Access

Learn by constructing a fully-functioning 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 queries
• Simple reports

Improving

• Simple subforms
• Combo (drop-down) boxes
• Making a database user-friendly (menu buttons, simple macros)
• Using queries in association with forms and reports
• Using queries in association with dialog boxes

Advanced

• 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
• Writing simple code
• Useful functions: sum, avg, dlookup, dsum, dcount