Table setup

E

explore2005

Hi all,
I am trying to build an access database for early intervention on preventing
child abuse. I have setup my tables, can someone tell me if my tables are
correct are correct? Or how to analyse them? I have access 2003

Thank you
 
J

Jeff Boyce

Without some idea of the tables and structure, it would be tough to tell you
.... please post back with more information.
 
V

Vincent Johns

explore2005 said:
Hi all,
I am trying to build an access database for early intervention on preventing
child abuse. I have setup my tables, can someone tell me if my tables are
correct are correct? Or how to analyse them? I have access 2003

Thank you
Click to expand...

Yes; what you can do is to describe what kinds of fields each Table
contains and what kinds of information you expect to include in the
Reports you wish to produce.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.
 
J

John Vinson

Hi all,
I am trying to build an access database for early intervention on preventing
child abuse. I have setup my tables, can someone tell me if my tables are
correct are correct?
Click to expand...

Yes... but they would have to see the table structure and definitions,
and an explanation of what real-life Entities you're dealing with. Are
you asking if it's ok to post them here and get free advice? If so,
sure; go right ahead. Or are you soliciting commercial consulting
support? That's a bit touchier, but you can ask; include a MUNGED (to
prevent spammers from harvesting it) valid email address. No
guarantees but one of the volunteers here (many of whom are freelance
consultants) may well respond.


John W. Vinson[MVP]
 
E

explore2005

Hi John,
I have volunteered to do this I am not soliciting. Please bare with me. I
tried to look up what MUNGED meant, could you please explain. I have six
tables set up, I just did not know if or how to submit them since I did not
see anywhere for an attachment. I thought the tables would be too much.
 
E

explore2005

Here are my tables
Here are my tables. My PK’ s are all autonumbers. Should I have a City
table.? Thank you.
Mother'sTbl
MOBID (PK), MOB LastName, MOB FirstName, Date of Delivery, Address, City,
ZipCode, Phone Number, MOBDate of Birth, Ethnicity/Race, Education level,
Medical Coverage, Type of Delivery

Baby's Tbl
Baby'sID(PK), Baby's Name, MOBID(FK), Primary Male Influence, Primary
Medical Care, Feeding type, 2nd month Immunizations, HospitalID (FK)

Hospital Tbl
HospitalID (PK), HospitalName, Address, City, ZipCode, Phone Number

ProviderTbl
ProviderID (PK), ProviderName, HospitalID(FK), Phone Number, Contact Date

Referral Tbl
ReferralID(PK), ProviderID(FK), BreastFeeding/Lactation Spec., Health Care,
Parenting classes, Postnatal classes, WIC (Eligibility), 1-800 number, Other

ScreeningResultTbl
ResultsID(PK),MOBID(FK),ProviderID (FK), Initial Screening, Positive Screen,
Negative Screen, Referrals given, Helpful, Recommend to a friend
 
J

John Vinson

I have volunteered to do this I am not soliciting. Please bare with me. I
tried to look up what MUNGED meant, could you please explain. I have six
tables set up, I just did not know if or how to submit them since I did not
see anywhere for an attachment. I thought the tables would be too much.
Click to expand...

Sorry... should have explained. It's unwise to post your real email
address on newsgroups, as spammers routinely run programs to harvest
them. So if you do want to post your address, conceal it from
automated systems in a way that a human can translate: e.g.

My Email Address <at> mydomain <dot> com

in place of [email protected].

You're right about submitting attachments: not considered appropriate
here. I'll look at your table structure, thank you for posting them as
text!

John W. Vinson[MVP]
 
J

John Vinson

Here are my tables
Here are my tables. My PK’ s are all autonumbers. Should I have a City
table.? Thank you.
Mother'sTbl
MOBID (PK), MOB LastName, MOB FirstName, Date of Delivery, Address, City,
ZipCode, Phone Number, MOBDate of Birth, Ethnicity/Race, Education level,
Medical Coverage, Type of Delivery
Click to expand...

Don't use ' in tablenames: and there's probably no benefit to
including the string 'tbl' in all tables (though some of my colleagues
would disagree). I'd just call this table Mothers.

It's also best to avoid blanks and special characters in fieldnames.
You can use "CamelCase" - run words together but capitalize each, as
in DateOfDelivery, PhoneNumber.
Baby's Tbl
Baby'sID(PK), Baby's Name, MOBID(FK), Primary Male Influence, Primary
Medical Care, Feeding type, 2nd month Immunizations, HospitalID (FK)
Click to expand...

What's in "Primary Male Influence"? a name, a link to some other table
(of men), or what? Might some children have two or more male
influences?
Hospital Tbl
HospitalID (PK), HospitalName, Address, City, ZipCode, Phone Number

ProviderTbl
ProviderID (PK), ProviderName, HospitalID(FK), Phone Number, Contact Date

Referral Tbl
ReferralID(PK), ProviderID(FK), BreastFeeding/Lactation Spec., Health Care,
Parenting classes, Postnatal classes, WIC (Eligibility), 1-800 number, Other
Click to expand...

This looks uncomfortably "spreadsheetish" to me: it looks like you're
storing data (types of referrals) in fieldnames. You might instead
want to consider a table of ReferralTypes (with values such as
Breastfeeding, Health Care, Parenting Classes etc.), and have your
Referrals table contain a foreign key to the BabyID or the MOBID
(depending on who's getting referred, I'd guess the baby but I'm not
certain), and another foreign key to the ReferralTypes table.
ScreeningResultTbl
ResultsID(PK),MOBID(FK),ProviderID (FK), Initial Screening, Positive Screen,
Negative Screen, Referrals given, Helpful, Recommend to a friend
Click to expand...

Probably ditto my concerns about Referrals.


Hope this helps - don't hesitate to post back!

John W. Vinson[MVP]
 
E

explore2005

Your question: What's in "Primary Male Influence"? In my form I put a
combo-box. I have about 10 options, such as, Biological
father,Stepfather,Paternal Grandfather,MOB boyfriend/partner etc. Would it be
too much on my form to put check boxes for all that apply?
--
the Referral Tbl : This looks uncomfortably "spreadsheetish"
True, I will work on this, thank you.

You mentions "Probably ditto my concerns about Referrals" I am not clearly
understanding.

I will work on my cleaning up my tables and forms.
You have been a great help. I believe to be on the right track.
 
J

John Vinson

Your question: What's in "Primary Male Influence"? In my form I put a
combo-box. I have about 10 options, such as, Biological
father,Stepfather,Paternal Grandfather,MOB boyfriend/partner etc. Would it be
too much on my form to put check boxes for all that apply?
Click to expand...

The Combo Box would almost certainly be preferable. If it's the
"primary" I presume it's thereby just ONE male influence.
the Referral Tbl : This looks uncomfortably "spreadsheetish"
True, I will work on this, thank you.

You mentions "Probably ditto my concerns about Referrals" I am not clearly
understanding.
Click to expand...

The ScreeningResultTable is also perhaps (like the Referrals table)
"spreadsheetish", with data stored in fieldnames. You may want a table
of result categories, and a "resolver" table with one record per
screening result per child (or family).
I will work on my cleaning up my tables and forms.
You have been a great help. I believe to be on the right track.
Click to expand...

Looks pretty good to me... and I'll send some prayers the way of the
kids you're helping!

John W. Vinson[MVP]
 
Top