Microsoft Access
Learn by constructing a fully-functioning and user-friendly
database, which works in the way you want it to..
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