- Residential Market
- Light Commercial Market
- Commercial Market
- Indoor Air Quality
- Components & Accessories
- Residential Controls
- Commercial Controls
- Testing, Monitoring, Tools
- Services, Apps & Software
- Standards & Legislation
- EXTRA EDITION
1. Are your systems integrated? (The various modules should talk to each other. If they talk to each other there is no redundant data entry. Customer master files, item master files, vendor master files, etc., are used across all modules of an integrated system.)
2. Are you generally happy with your systems except for the reporting functionality?
3. Do you think that you need a new system in order to get the type of information reports you need to run your business?
If you answered yes to these questions, consider this:
1. The initial cost of purchasing a new system can be very expensive.
2. The effort required to convert, import, and verify current data in existing systems to a new system can be expensive and time consuming.
3. New systems require training. Lack of training will almost surely result in under utilization of a new system. Training is generally expensive and time consuming.
4. Employee knowledge of existing systems is generally of little value in learning and operating a new system.
5. No out of the box system will provide all the information reports you need to manage your business. That system doesn't exist and never will.
6. Any system you purchase will require unique report writing in order to get the management information you need. Most systems include a report writer. In many cases the report writer is just a simplified version of a database manager that has been incorporated into the system to give it the appearance of a total integrated system.
The AlternativeThe alternative to purchasing a new system is to add a custom Microsoft Access integrated information system that gets its raw data from your existing computer systems.
Critic's arguments against using Access for your management information reporting system:
Responses to arguments against Access and arguments for using Access for your management information reporting system:
SolutionsSome suggested solutions for developing improved management reporting that is also cost-efficient:
1. Design an Access database information system that automatically imports raw data each night. This provides data that is up-to-date as of the close of business the prior day and is available for reports without competition from other data entry individuals.
2. With Microsoft Access, an integrated management information system can be developed with more functionality than virtually any modern accounting or inventory control system that comes with its own report writer.
3. Microsoft Access is the perfect solution for virtually any system. It is a robust database manager that is the most popular in the world.
4. Microsoft Access is very inexpensive and allows employees to write some of their own applications without risking data integrity of basic systems. For those more familiar with spreadsheets, data from Access tables can be easily downloaded into Microsoft Excel.
5. Most reports can be run in just a few seconds or minutes. They can be printed to an Adobe Acrobat file and stored in a shared folder or e-mailed to appropriate personnel. Management can then access the reports at their leisure and view them or print them in seconds.
6. It is generally a good rule of thumb to not make any modifications to your basic systems. Modifications are not only expensive, but each time a revision to a basic system is installed, the modifications will have to be reprogrammed. Tables in most systems are changed less frequently than the functionality of the application. As a result, modifications to the Access management information system are required very infrequently.
Do A Little ResearchLook at user groups for the software you are considering purchasing. Chances are, there are relatively few groups with relatively few discussions on items of your interest. This is a good indication of how many programmers will be available to write reports. It is also an indication of how many resources the software company has allocated to the design and improvement of the software.
Investigate Microsoft Access user groups. See how many there are and how much discussion occurs in these groups.
Microsoft Access is the most widely used database manager in the world. Each upgrade includes better and better wizards to help novices write their own applications.
Microsoft spends far more on development of this database manager than is spent on any competing products.
ConclusionThe cost of developing a management information system in Microsoft Access is generally a fraction of the cost of purchasing a complete new system.
If all that is needed is a more robust management information system, an Access reporting system is quick and easy to install.
A Microsoft Access information system is a low-cost, high-return solution that offers superior results.
Peter Koehl, president, Peter Koehl Associates, Tustin, Calif., is a consultant to small and large companies in the areas of financial operations and systems design. Prior to consulting, he held an executive position with a Fortune 200 company. He obtained his CPA while working for a major CPA firm and received his MBA from the Advanced Management Program at Michigan State University. For more information, call 714-832-6100, e-mail firstname.lastname@example.org, or visit www.4pka.com.
Publication date: 05/17/2004