Project a Cemetery Database

[JohnB762 via AccessMonster.com]

Hello to everybody,
I am trying to project a database for a local cemetery, but I am almost crazy
as I am not able to get a reasonable result mainly for my difficulties with
databases. So far everything is register with many Word files. (I am fairly
new with Access).
I start also to read Microsoft Access 2003 Inside out, but I need to many
mental adjustemt to fully understand how a database work.
I try to explain where I am:

TblNiche
NicheID, autonumber
Niche, text

TblCell
CellID
NicheID
CellNumber

TblFamilyVault
FamilyVaultID
FamilyName

TblAssignments
AssignmentsID
CellID
FamilyVaultID
Name (of defunct)
BirthDate
DeadDate

My problem is how to relate the table and how to put all together in a form
or with tab control (plus subform)
In addition for each niche, the "FamilyVault" has 2 or 3 name. Each name has
up to to 6/7 family component. And I don't know how to buil the relevant
table and relate with the others.
I can send what I have done so far, but without success.

Thanks for your help and time that I appreciate since now.
Kind Regards
John

 

[mnature]

It would help to know how your terms relate to each other. It looks like
several Cells form a Niche, and several Niches form a Family Vault. Is this
true? Is there one person per Cell, or several persons per cell?

 

[mnature]

Another question: How do you want to 'mine' this information? Will you want
to look at everyone in a family vault, a niche, a cell? Your end result
should be a large part of how to set up the tables.

 

[John]

Hello, and thaks for your interests
Your first question:
"It would help to know how your terms relate to each other. It looks like
several Cells form a Niche, and several Niches form a Family Vault. Is this
true? =>The Niche is formed:
- from several Cell, (like a table of 5 rows by 4 column) see below scheme
- plus a Family Vault (like a table of 6 rows and 3 colum) see below scheme

Is there one person per Cell, or several persons per cell? Yes, max 2

The second question
How do you want to 'mine' this information? Will you want
to look at everyone in a family vault, a niche, a cell? Your end result
should be a large part of how to set up the tables
=> well, if possibile I would like to "mine" everyone in a cell for the
defunct not in a Family Vaul and as a group for the other part of the Family
Vault

NICHE 1
| Name 1 | Name 6 | Name 11 | Name 16|
| .............................................. ........ ...|
|.............................................. .......... ..|
|............................................. ........... ..|
| Name 5| Name 10 | Name 15 | Name 20|

|-Family Vault |--Family Vault |- Family Vault |
| A | B | C |
| Fam. member | Fam. member | empty |
| Fam. member | Fam. member | empty |
| Fam. member | Fam. member | empty |
| Fam. member | Fam. member | empty |

I don't know if I have been clear enough. I hopo so.
Thanks again for your interests and help.
Regards
John

 

[mnature]

tbl_Niches
NicheID (PK)
NicheInfo

tbl_FamilyVaults
FamilyVaultID (PK)
FamilyVaultInfo

tbl_Defunct
DefunctID (PK)
DefunctInfo

tbl_Cells
CellID (PK)
CellInfo
NicheID
FamilyVaultID

tbl_RestingPlaces
RestingPlaceID (PK)
RestingPlaceInfo
DefunctID
CellID

This allows you to assign more than one defunct to a cell (in
tbl_RestingPlaces). Each cell is associated with a niche and, optionally, a
family vault (in tbl_Cells). Let me know if this looks feasible.

 

[John]

Hello, and thaks for your interests
Your first question:
"It would help to know how your terms relate to each other. It looks like
several Cells form a Niche, and several Niches form a Family Vault. Is this
true? =>The Niche is formed:
- from several Cell, (like a table of 5 rows by 4 column) see below scheme
- plus a Family Vault (like a table of 6 rows and 3 colum) see below scheme

Is there one person per Cell, or several persons per cell? Yes, max 2

The second question
How do you want to 'mine' this information? Will you want
to look at everyone in a family vault, a niche, a cell? Your end result
should be a large part of how to set up the tables
=> well, if possibile I would like to "mine" everyone in a cell for the
defunct not in a Family Vaul and as a group for the other part of the Family
Vault

NICHE 1
| Name 1 | Name 6 | Name 11 | Name 16|
| .............................................. ........ ...|
|.............................................. .......... ..|
|............................................. ........... ..|
| Name 5| Name 10 | Name 15 | Name 20|

|-Family Vault |--Family Vault |- Family Vault |
| A | B | C |
| Fam. member | Fam. member | empty |
| Fam. member | Fam. member | empty |
| Fam. member | Fam. member | empty |
| Fam. member | Fam. member | empty |

I don't know if I have been clear enough. I hopo so.
Thanks again for your interests and help.
Regards
John

 

[John]

First of all many many thanks for your time and cooperation.
I apologize for the double post, but I was unable to see any message for few
hours.

On more question, If am I allowed to ask,. Would you be so kind to help me
to build also the form?
I think the main form is based on the tbl_Defunct, but what about the other
infos?
I mean should I built combo based on the query ot the tbl_Niches,
tbl_FamlilyVaults, tbl_Cells and tbl_RestingPlaces?
And consequently add the fields to the tbl_Defunct if I want to store the
data in the record to fill correctly the database.
Again, thanks for all your support.
Regards
gbianchi

 

[mnature]

You need to build a query. Start with tbl_RestingPlaces, using all the
fields. Add all fields from tbl_Defunct except for DefunctID. Add all
fields from tbl_Cells except for CellID. Add all fields from tbl_Niches
except for NicheID. Add all fields from tbl_FamilyVaults except for
FamilyVaultID. Finish the query. Now start to create a form using the
wizard. Choose the query you have just made. When it asks you how you want
to view data, there should be five choices. These five choices give you the
ability to view information in a variety of ways. Most of these choices will
give you one or two subforms. If you select one with subforms, you can go in
later and modify the subform to better fit how you want to look at the data.

I would suggest using this same query to create several forms, using names
for the forms and subforms to indicate how the data is being presented, so
you can tell the difference between them.

 

[John]

Dear "mnature",
I really don't know how to THANK YOU for your help, support, and explanation
of the project.
Everything now, is fine and again thank you very much.
Regards
John