Database Development and Maintenance
Do you need a database for your web site or in-house? If yes, then Lannen will be more than happy to create a database for you.
It is not possible to quote a flat rate for a database. There are always items that are thought of afterwards that need to be incorporated. The hourly rate for database development is $70.00.
A few items that need to be taken into consideration are:
- Is this a single user database?
- Will multiple users be accessing the database on a network?
- Do you have existing data that may need to be cleaned?
- Do you require security?
- Will you be using the database for internet marketing
Lannen Designs can also maintain your existing MS Access database, including creating new reports for you, and help you take advantage of the built-in features.
Databases Developed
(click on each link to view screenshots)
Developed For: Southwest Missouri State University (Admissions and Recruitment)
Purpose: To schedule recruitment counselor visits to high schools, college fairs, and junior colleges.
Features: Schedule appoiments, including rescheduling, prepare letters and labels (merged with Microsoft Word), track historical activity, add new schools, and many other features.
Cardiovascular Medicine Conference Scheduling 
Developed For: UC Davis Cardiovascular Medicine
Purpose: To schedule talks and seminars, and produce monthly calendars.
Features: Schedule talks, add speakers and produce monthly calendars and flyers. Eliminated the need to hand create the schedule to automating the process.
Developed For: UC Davis Cardiovascular Medicine
Purpose: To track patients in the Women’s Cardiovascular Health Clinic.
Features: Ability to quickly locate information about patients in the clinic.
Developed For: Tropico Management
Purpose: To provide their clients with detailed information on their clients and contacts.
Features: Ability to enter detailed information on clients and contacts.
Developed For: UC Davis Cardiovascular Medicine
Purpose: To track patient success or failure in a smoking cessation program.
Features: Tracks a patient’s smoking history and progress through the program.
Developed For: UC Davis Cardiovascular Medicine
Purpose: To track patients enrolled in a 2-year program on preventive cardiology.
Features: Staff enters information on each enrollee every 3 months and will be able analyze progress and success at the end of the two years.
Developed For: UC Davis Police Department
Purpose: To track employee absences due to on-the-job injuries.
Features: Schedule talks, add speakers and produce monthly calendars. Enabled them to go from creating the schedule by hand to automating the process.
Developed For: UC Davis Police Department
Purpose: To enter lost and found property, and quickly search upon receiving an inquiry.
Features: Ability to enter by category and provide details on property and where it was found or lost. Prepare reports for purging and proper disposal of property.
Developed For: UC Davis Police Department
Purpose: Track reported violence against hospital personnel.
Features: Enter information about the incident and produce reports.
Developed For: UC Davis Police Department
Purpose: To track bike thefts on campus.
Features: This was a preliminary design.
To find out more or get started, please contact me.
