lists small, very simple Microsoft Access Databases that can be
downloaded. They are basically "starter" databases that are
used in our classes. It is from these databases that students can
construct their queries, forms, macros, etc. There will also be
demonstration databases used to illustrate various points - i.e. how
to do a recursive join, how to import a spreadsheet with a macro, how
to use date functions, etc.
Class Starter Databases
starter kits. Generally they will have only tables and, when
appropriate, the other database objects being illustrated.
- Factory Cost Accounting
- Hospital Patient Admissions
- Sales Application case. Used in our beginning VBA classes.
2000 Sample Macros
- A large and growing set of sample macros.
Illustrates many Microsoft Access Macros as applied to the Factory
2000 case. Our goal is to eventually illustrate nearly all macros.
Date and String Functions - Over 35 Microsoft Access Queries
illustrating Microsoft Access Date Functions and String Functions.
Uses the Admissions case. Supports both the Query and SQL Views in
the PowerPoint slides.
- Additional databases on dhdurso.org