Home  Fees/Services  Access Templates  Tutorials  Tutorial Downloads  Articles  Search  Contact  Privacy  Links

Reservations Management Software Template

 Home > MS Access Template > Rx Assistance Application Management 






Access Database Templates:

Inventory Software Access Templates
Inventory Systems. Review our custom Inventory Software. Barcode Asset Tracking & Control Microsoft Access database.

Interior Design Project Access Software Template
Manage Interior Design projects with this simple and powerful Access database system.

Contact Management Access Templates
Contact Management, Custom Contact Management Software, Organize Contacts & Communications.

Construction Project Management Access Template
Construction Project Management designed to help you keep on budget and on time.

Lease Contract Management Software
Create lease contracts & Rental agreement for equipment. Analysis lease performance & cash flow.

Livestock Feed Inventory Database
Management feed usage and feed cost with this simple flexible database system.

CRM/Customer Relationship Management Access Templates
Customer Management Tools. Custom CRM Software Solutions.
Manage Customer & Client Relations Microsoft Access software.

Order Management Database Software for Customer Orders

Order Processing Pre-built Software Template
Order Processing System Order Management Software. Custom Database Design Solutions

PM/Preventive Maintenance Access Template
Custom PM Management Databases. Maintenance Management Systems.

Work Order Software
Service Request Software Installation, Repair & Maintenance. Work Order Systems & Solutions.

Real Estate Marketing Template Database
Real Estate Marketing
Select Property by Attributes: Location, Zoning, Value & More.

Reservations Management Access Template Database
Reservations Software Reservations & Booking Software by Custom Database Design Experts.

Asbestos Survey Project Management Access Templates
Asbestos Survey Software, Asbestos Material Survey Custom Data Analysis Software System.

Document Revision Management Database Templates
Document Revision Control & Document Distribution Control & Tracking

HOA/Homeowner Association Management Microsoft Access Templates
HOA Management - Community Association Management, Home Owners Association Software.

Loan Process Management Access Templates
Mortgage Management,
Loan Processing Software &  Mortgage Process Tracking.

Student Loan/Grant Management Access Templates
Pell Grant Management Software.

Personnel Agency Access Template Database
Placement Agency Software, Custom Personnel Agency Management for Contractors and Consultants.

Rx/Prescription Assistance Plan Management Database Template
Rx Plan Software. Software for the Generation  & Tracking of Applications for Assistance Plans

Subscription Order Management Database Template
Subscription Manager - Custom Subscription Management Tool for Subscription Order Process Control.

Corporate Document Management Access Templates
Document Management Custom Document Search & Retrieval Software


Prescription Assistance Program Software

Automatically Generate Prescription Assistance Forms

Pharmaceutical companies provide free drugs for low income individuals through their prescription assistance programs.  These programs are typically not advertised and not well known by the general public.

However, over the last few years the public relations benefits of these programs has come to the attention of senior management at many drug companies.  Now you see some TV advertisements as well as more prominent displays of these prescription assistance programs on company's websites.

Acceptance to the prescription assistance programs is often simply based on income.  However, the assistance plan forms are diverse and rarely give a clue for the qualifications for assistance plan acceptance.  Some of these programs ask more than 100 detailed questions about your personal finances.  Re-enrollment is usually required at varying periods, from 3 months to 1 year.

This software takes care of the drug plan paperwork that patients need to complete to get the free drugs, and they fill out the forms again when the patients' supplies run out - companies usually send patients a 90-day or 180-day supply of the drug, and require them to reapply and again prove financial need before they ship more.

We were asked to create a database to manage the process, determine preliminary eligibility, and produce the prescription assistance program application.
 


The primary data entry screen for the prescription aid database is show below.  The top half of the screen contains fields for the demographic information for the client.  The lower half contains areas for:

  • Allergies

  • Income

  • Expenses

  • Other Income

  • Prescriptions



After all the client data is entered the user goes to the prescription plan match screen to determine preliminary eligibility to the particular pharmaceutical assistance program depending on each prescription held by the client.  In this example the user has pressed the 'Check Approval' button and the database displays a popup message indicating approval or indicating why the application was not approved.  Since this is just a preliminary approval the user may still printout the prescription assistance plan application form by pressing the 'Print Form' button.  Below is a snapshot of a completed application form.


Here is a completed application form ready for submission to the pharmaceutical company (along with supporting documents).  This particular form for Pfizer's Connection to Care program is one of the more simple forms - others have up to 100 fields of data.


Where appropriate we always try to make the database appear simple to the user.  In this case we have a single review tab that replaces 3 tabs in a standard-designed database.  Note the radio buttons for views of Clients, Doctors, and Client Charts - these three different forms a dynamically overlaid when a radio button is pressed.


The reports menu is as simple as can be.  There is a facility for users to create custom reports and add them to the list.


Key to all of our databases is nearly infinite expandability and customization by the user.  Below is the List Maintenance screen.  Where ever possible data fields are derived from a lookup list - this form allows the user to maintain all of these lists.









This Rx Assistance Plan Management Database is not for sale.  It is a sample of the software development capabilities.

Get a Free Quote for your custom database template Today! (410) 708 1417 or E-Mail us.




Contact Information

Copyright 2000-2017 Blue Claw Database Design