Download KE Database (setupke.exe
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
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.