Home  Fees/Services  Access Examples  Tutorials  Access Download  Articles  Search  Contact  Privacy  Links

Microsoft Access Samples
Access Database Examples

Example Microsoft Access Software  

Programming Tutorials> > Microsoft Access Examples

Download Access Examples >

 


Microsoft Access Examples

We have been developing Access databases since 1994 and have done original designs for over 200 clients.  We have also reworked and debugged as many as 250 additional databases for 150 clients located throughout the world.

Below are listed several Microsoft Access example databases.  You will see that a majority of the screen capture show a consistent look and feel from database to database.   Some data has been obscured to protect privacy and confidentiality.

Each database example employs the techniques detailed in our Tutorial & Tips.  Many of the databases are part of a full database case study.  There are links to several of the more popular Access case studies listed on the right side of this page.

We have about 20 different case studies and are highlighting more programs each month. Our most viewed database case studies are Inventory Management, Customer Relationship Management and Business Contact Software.

Access Contact Manager
Convert Act! to Microsoft Access

Equipment PM Management
Machinery Preventive Maintenance Database Software

Patient Check-in
Patient Check-in Doctor's Office

Work Order Management
Work Order Management

Client Stock Accounts
Investment, Client Account

Membership Example DB
Membership Management

Shipping & Receiving
Shipping and Receiving

Trucking - Driver Hours
Truck Driver Time Analysis

Inventory Tracking Analysis
Inventory - Flexible Reports

Form Overlays/Dynamic SQL
Dynamic SQL Generation

Front End to MAS90/Oracle
ODBC FrontEnd to Oracle

Inventory Control/Order Tracking
Equipment Inventory Control & Tracking

Group Membership Database
Professional Organization Membership with Requirements Analysis

Product Management
Order Tracking, Product Deliver and Installation Management

Environmental Data Analysis
Environment Information Management

Financial Accounts Analysis
Custodial Accounts Management

EPA Tri-Data Analysis
Environmental Issues Management

Or, choose from the Microsoft Access examples listed below: -

Equipment Inventory Tracking & Management Microsoft Access Example
Tracking the who what when andMicrosoft Access Examples 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.
 

Preventive Maintenance Management Database
Equipment preventative Equipment PM Systemsmaintenance (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-inPatient Registration Medical Office
This form example highlights a medical office patient registration system.  The database is design to provide rapid user friendly input of data during patient admission.
 

Contact Manager- A CRM Software SolutionContact Management Software
Customers, clients and vendors are all contacts which a business must track.  This custom database design provides advances features beyond off the shelf packages such as Act!


Work Order Management System Work Order Tracking Systems
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.


Client Stock Account & Investment Portfolio Management
This system is designed to analyze Stock Bond Investment Trackingthe large printout of stock and bond trading for individual accounts.  Analysis includes profit and loss as well as year end tax optimization sales.


Shipping & Receiving Manifest Order Processing
This screen highlights a complex inventoryShipping Receiving Manifest 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 daunting task. 
 

Trucking - Truck Driver Hours Driving Time AnalysisTruck Driver Hours
Companies must track and analyze truck driver driving time in detail and accurately in order the determine future schedules for each truck driver.  This system manages and analyses the driving time data.


Analysis of Chemical Constituents within Sediment Core SChemical Constituent Analysisamples Database
NOAA has millions upon millions of data points detailing off-shore sediment analysis.  This databases highlights the first system design to facilitate rapid and user friendly retrieval and analysis of the data.

ODBC Front End Interface to MAS90/Oracle
Many large corporate databases are nearlyODBC Front End System 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).
 

Organization Membership Software Access Database ExampleOrganization Membership Management Software
This screen snapshot highlights a membership management database for a professional organization. Features include event management, dues payment tracking, announcements and much more.
 

Product Production & Installation Management
This software tracking the productionProduct Production Management process for construction of furniture and other structures used in a school environment.  Production phase tracking include component ordering, delivery, construction phases through final installation.
 

Environmental Compliance Monitoring & Data AnalysisEnvironmental Compliance Management Software
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 Custodial Account Managementdesign to manage the distribution of funds for individuals deemed wards of the court.  Features include distribution and payment frequency management.
 

Drug Administration TrackingPharmaceutical Prescription Medication Tracking
Example system for assisting patients in monitoring their compliance to prescription drug prescription instructions including frequency and dosage requirements.


EPA Tri-Data Analysis Microsoft Access ExampleEPA Tri Data Analysis Software
Example of a 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.

See 22 Complete Microsoft Access Templates

Form Layout & Design Guidelines



In-Depth Case Studies:

Service Request Tracking Software
Maintenance Management Example Software

 

Contact Management Software
Contact Management Example

 

Inventory Tracking System
Inventory Management Example

 

Preventive Maintenance Schedule
Preventive Maintenance Example Software


 ADO Connections
 Application Objects
 Combo Box Help
 Docmd Action Method
 Domain Aggregate Fx
 Download Example Code
 Form Event Examples
 Form Programming
 Query Examples SQL
 Report Programming
 RunCommand Method
 Security Alternative
 Security Overview
 Table Management DDL
 Table Design Guide
 Visual Basic Code VBA

 Access on the Internet

 Database Snapshots

Contact Information

Microsoft Access Examples
Microsoft Access 2007 2003 2000 All Windows Versions