Recent Database projects.
Paint
mixing station: MS Access
2003 database for paint mixing stations (at the painting location) for major
paint manufacturer.
-
Electronic scale
interface for real time mixing display on PC.
-
Touch screen
interface.
-
Formula storage,
retrieval, and calculation by volume to mix.
-
Formula correction
for mixing errors.
-
Inventory tracking
with reorder reports.
-
VOC reports.
-
Label printing on
Dymo printer.
Production
Status: MS Access 2003 database for
tracking production status from order entry to order shipping for a major paint
manufacturer.
-
Tracks work hours
for each step of the production process for three production cells.
-
Tracks batches and
gallons produced.
-
Tracks quality
control data.
-
Provides graph of
work hours per month by production step.
-
Provides graph of
work hours per production step by month.
-
Produces reports of
batches produced, gallons produced, and average work hours per batch by month
for any 12 month period and current year to date.
-
Includes custom
work calendar for specifying daily work hours for each of the 3 production
cells
Paint
mixing station: MS Access
2003 database for mixing paint at the painting location for major paint
manufacturer.
-
Electronic scale
interface for real time mixing display on PC.
-
Touch screen
interface.
-
Formula storage,
retrieval, and calculation by volume to mix.
-
Formula correction
for mixing errors.
-
Inventory tracking
with reorder reports.
-
VOC reports.
MedWatch
Database: MS Access 2000 database for
recording and reporting adverse events.
Includes an interface to
your MedDra database with an easy to use term lookup browser.
Freezer
Inventory Control Database: MS Access 2000 database for
inventory management of materials that are required to be stored in a freezer.
-
Records time in and
out of the freezer and calculates remaining shelf life.
-
Records materials
used by job number.
-
Calculates
materials remaining and materials to be ordered.
-
Scale interface to
allow weighing of materials.
Clinical
Trials Database: MS Access 2000 database for management of
clinical trials including serious adverse event reporting. Key design elements.
-
Clinical
investigator database.
-
Drug and device
database.
-
Patient database.
-
Serious Adverse
Event reporting.
Flexible Spending
Account Database (Flexible Spending Account Software) (Cafeteria Plan Software): MS Access 2000 database for management
of employee flexible spending accounts. Key design elements.
-
Management of all six
flexible spending accounts.
-
Medical
Reimbursement
-
Dependent Care
-
Individual Owned
Medical Insurance
-
Disability
-
Group Medical,
Dental, Vision
-
Group Term Life
-
Company deposits.
-
Employee contributions, supporting 5 pay periods
-
Weekly
-
Bi-Weekly
-
Semi-Monthly
-
Monthly
-
Annual
-
Company and
Employee Disbursement check printing.
-
Check register.
-
Mailing label
printing including United States Postal service (USPS) Postnet barcodes.
Document
Tracking Database: MS Access 97 database for major pharmaceutical
company used in standards and specs department for tracking of document changes.
Key design elements.
-
Active document
database.
-
Archived document
database.
-
Barcoded report
printing.
-
Statistics on
documents processed and department throughput.
Publication
Reader Response Card Processing Database: MS Access 97 database for
major pharmaceutical company used in technical publication department for
tracking and processing of reader response cards. Key design elements.
-
Multiple
publications database.
-
Subscriber database
by publication.
-
Sales rep. database
by geographical region.
-
Reader response
processing and reply automation.
-
Statistical
analysis and reporting of responses.
|