All Tools






KE Database

Download KE Database (setupke.exe 1.2MB)

Database Overview:
A pure and simple design has been used to make this database easy to: understand, modify, and support in the future. The current eight(8) parts of the database take into account almost all functions associated with an organization. For example, the "Event" component can represent a project, meeting, or anything else that involves people gathered together at a location (program/organization). A "Program/Organization" represents the combination of a physical location with a function. Most often a single program will represent an entire organization, but multiple programs/organizations can be related to represent an entire company (various departments in a large company or different site locations).

The concept of a detail has also been used extensively to provide maximum flexibility, speed, and compatibility. For example, the "Person" component has the bare minimum number of fields common to all people on its main screen. Those pieces of information which vary for different types of people or which might require multiple entries are tracked as details. A person that is a volunteer has different details than a board member or employee or vendor or project leader. This design makes it simple to adapt to future unforeseen requirements and to develop a single set of reports that can be applied to all people (ex. a single label report that can be printed based on details instead of many different label reports for each different category associated with a person).

Why Microsoft Access:
Microsoft Access has been chosen because: it integrates well with MS Word and Excel; has widespread support in the business community; is easy to obtain (probably already installed); and will not become obsolete or incompatible with the Windows operating system in the future. User interface complications have been minimized by containing the user within a set of forms (so, no real knowledge of MS Access is required).

Integrated single source of comprehensive information:
All components are fully integrated. For example, if you select a person, you can view: interests; events participated in; finances contributed/spent; relationships to other people/organizations; notes; etc… By double clicking on the event/program/finance you can jump directly to it for full viewing of all related information.