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.
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.
Our 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, business specific application 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 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
Please feel free to read these comments from some of our customers.