Snapshots of forms from our
templates database examples are listed below. You will see that a majority of the screen captures show a
consistent look and feel from database to database.
Microsoft Access is a fully capable database and it's primary limitations is the number of concurrent users it will support. The number of users supported depends on the transaction load and the amount of data but generally we recommend a limit of 10 to 15 users.
We create databases large and small. Some of our databases help run entire small businesses including travel agencies and airline reservation systems. We also handle unique businesses such as fly rod manufacturing. Did you know there are 11 steps in the making of a fly rod?
Some data has been obscured to protect privacy and confidentiality. Each database example employs the techniques detailed in our
Programming Tutorials. Many of the
Access databases are part of a full database case study and some are examples of
which are for sale.
There are links to several of the more popular Access case studies listed on the
right side of this page.
Click an image below to view the Access sample database:
Or, choose from the Access examples listed below:
Equipment Inventory Tracking Example
Tracking the who, what, when, and where of expensive corporate assets is the design
goal of this Access database system. The design includes tracing of assets moved into and out
of storage locations and inventory calculations. Specifically design for
tracking cable and satellite equipment installation. Never lose track of a
Preventive Maintenance Management Example
maintenance (PM) are designed to track and schedule
equipment maintenance requirements. This system is critical to prevent
excessive wear and malfunction of equipment in a wide variety of industries.
Medical Patient Registration & Check-in
This form example highlights a medical office patient registration system.
The database is design to provide rapid user friendly input of data during
Work Order Management Access Database Example
Efficient and accurate service request management can make or break your
business. If your work request software drops a service order request then
you could lose a customer to your competitor. As a service to you, we have
compiled a list of popular service management software systems. This
database was originally designed in Access 2003 but has been tested with
Access 2007 and Access 2010.
Shipping & Receiving Manifest Order Processing
This screen highlights a complex inventory system in which the inventory items
grow over time (tropical plants). Along with the growth comes increase in
value. A further complication is that plants get 'sick' and must be
transferred to the plant hospital. Tracking all of this data can be a
ODBC Front End
Interface to MAS90/Oracle
Many large corporate databases are nearly impossible for the average user to
perform ad hoc queries. Most IT departments have a six-month or year lead
time to provide customized reports. This screen demonstrates a highly
flexible ODBC interface to a huge government database to with EPA data.
The ODBC front end is an Access database (of course).
Product Production & Installation Management
This Access example for tracking the production process for construction of furniture and
other structures used in a school environment. Production phase tracking
include component ordering, delivery, construction phases through final
Environmental Compliance Monitoring & Data Analysis
This database supports all records management for a company's compliance with
EPA regulation for maintenance and monitoring of chemical storage and
distribution equipment. The system supports archive of photographs and cad
drawings of equipment and facilities.
Custodial Financial Account Management
Financial account management database is
design to manage the distribution of
funds for individuals deemed wards of the court. Features include
distribution and payment frequency management. Pharmaceutical Prescription Medication Tracking
Example system for assisting patients in monitoring their compliance to
prescription drug prescription instructions including frequency and dosage
EPA Tri-Data Analysis Access Example
Example of an Access database system designed to mange EPA's Toxics Release Inventory
data. The EPA Toxic Release Inventory data system contains information on listed toxic
chemical and waste reduction activities reported annually by companies
throughout the USA.