Custom Database Design & Development
Finance Experience
Key to I.T. has designed and developed many database applications with a Financial or Accounting purpose.
Leanne Benson, Key to I.T.'s
designer, has an Accounting Degree as well as Software Design
qualifications. She worked in the Finance and
Administration department of a large organisation for 12 years before
starting her own Database Design business in 2002.
User Friendly Programs
Most people I talk to say that it's reasonably quick and easy to create a simple database using Microsoft Access. They also say that it is not so quick and easy to make a user friendly application.
These applications are often destined for use by people with very little experience or knowledge of how a computer works. This means the user interface must be simple, self explanatory, and non-threatening.
The application also must leave little room for error to protect the integrity of the data going in. As the old saying goes 'garbage in, garbage out'.
At Key to I.T., we understand the user, because we've been there!!
User-Friendly Features Designed by Key to I.T.
Reporting
The ability to extract information from a database in a flexible way is
SO important for businesses. Designing a report in Access is quite
easy, but once you've made the report, you can't "filter" what
information appears on it.
Sometimes an inexperienced designer would be forced to create multiple reports to show different records with the same layout. eg. All Sales from Queensland, All Sales from NSW.
Key to I.T.'s flexible Report Criteria System offers choices to the user so they can select specific data from one report layout to print or export to Excel, Word, Text or PDF.
In the previous example, there would be a Sales Report which provides the choice to choose one State, or Selected States, or All States before the report is produced. This means if a report design needs changing, it only needs to be done once.
Online Help and Documentation
If you'd like, we can also provide an online help system within the program so that all the user needs to do is press F1 or click the help button to find out more about each screen or report in the system.
Productivity
There is often many areas of administration within an organisation which could benefit from a database application.
A little bit of money invested in developing a robust, application specifically designed for your needs can save your business time and money.
We want to help you be more productive, and make your users happy!
Contact Us if you would like more information.
Examples and Comments
Some examples of applications developed by Key to I.T. for businesses are:
- Coal Stockpile Movement Tracking and Accounting System
- Quotation Manager for Hot Water System Business - including creation of quotes from Microsoft Access in Word Format
- Timesheet and Quotation System for Consultants
- Budgeting System for Sugar Milling organisation
- Time & Distance Tracking for a Road Transport Business
- Health and Safety Management Data
- Share Register
- Personnel Database
- Document Management System for a Legal firm for accessing Procedures and Document Templates
- HR Database - including Staff Details, Key Register, System Permissions, Performance & Remuneration Reviews
Please feel free to read these comments from some of our customers.