View Single Post
  #4  
Old November 13th, 2009, 09:41 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default Table design help!

In addition to Fred's observations, consider whether you need to reinvent
the wheel.

If this is a survey/questionnaire, perhaps work already done by Duane H.
could get you started:

http://www.rogersaccesslibrary.com/O...p#Hookom,Duane

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.


"Hannah" wrote in message
...
I'm a bit of an access novice (training on basics, searching for help on
the
rest) building a database for a research project. I've tried having a wee
look for this question but I can't spot it anywhere (probably because it's
obvious to everyone else).

I'm designing my tables and what to put in them and I've hit on something
I'm not very sure about. For some questions there's a yes or no question
(e.g. "do you eat cheese?) and a follow up if they say yes, theres an "if
yes, which of these types..." follow up question. I'm not sure whether I
need
to structure these into two different tables or whether I can use one
table
for both? I was planning to use tick boxes for these but if there's a
better
way, please let me know! Thanks very much for help in advance - I don't
know
where I'd be without these groups (well I do, somewhere not very good!)