|
This page
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 small
demonstration databases used to illustrate various points - i.e. how
to do a recursive join, how to import a spreadsheet with a macro, or whatever.
Basic
Class Starter Database(s)
These are
starter kits. Generally they will have only tables and, when
appropriate, the other database objects being illustrated.
Factory2000
- Factory Cost Accounting
Admissions
- Hospital Patient Admissions
ProductSales
- Sales Application case. Used in our beginning VBA classes.
Sample
Databases
Factory
2000 Sample Access 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.
Access Sample 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.
Factory 2000
Sample Access Spell Check - VBA code after databasedev.co.uk.
Shows how to automatically spell check field entries in Microsoft
Access Forms. |
