|
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 - Simple database used in our
beginning classes, especially AIN102 Access Queries.
ProductSales
- Sales Application case. Used in our beginning VBA classes.
Sample
Databases
Bookstore - Database used in
Jan Harrington's SQL Clearly Explained. Our SQL classes use this database.
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.
Northwind 2007 - The
classic Northwind sample database from Microsoft. In accdb format.
Submit the form below to be notified of new databases or PowerPoint slides.
We are looking for referrals. Click below to learn more about cash
payments for referrals.
 |
