On Tue, 19 Oct 2004 15:49:05 -0700, "Incident Manager" <Incident
I would like to create a database that would allow me to collate and group
incidents by nature and by date. I am not familiar with Access 2000 which I
am presently using. Any help would be grateful.
This could be a small, medium, or large project depending on the
details. I would start by identifying all classes of "entities" -
real-life people, things, or events - of importance to you. Since I
have no notion what *you* mean by an "incident" - industrial accident?
Personal encounter? Alien space invasion? - nor who or what might be
affected by the incidents, I can't immediately suggest what those
might be; but at the least you would have a table of Incidents with
fields:
IncidentID Autonumber (Primary Key) - unique identifier for each
incident
IncidentDateTime Date/Time
You would probably also have another table of Categories to indicate
the "nature" of the incident; if a given incident might be of several
"natures" you'll need a third IncidentNature table with fields for the
IncidentID and the CategoryID, if not then just put a CategoryID field
in the Incidents table.
If you need to keep track of (say) people involved in the incident,
you'll need a table of People; if you have locations, you may need a
table of locations, or of cities, or fields for addrsses, etc.
Once you get the tables set up, identify their Relationships; only
then should you start looking at Forms for data entry and display, and
at Reports for printing.
John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps