Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 303
  • Last Modified:

Database field design assistance needed

Hi all,
I am trying to get a database together but it's getting a bit confusing.

Normally you have: Fieldname and Field type bit I need to get into a database table something like this:

  ---- Boolean, text1, text2, text3

What do I do when a field must contain different values (and more than one).

Hope someone can help.


1 Solution
What do you mean, the field contains a Boolean and Text?

What is the purpose of your field?

Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
<<What do I do when a field must contain different values (and more than one).>>

  You don't.  In a proper relational design, every field is "atomic"; that it is contains only one value.

  Second thing is that every field in a table belongs to whatever the table represents.  For example, a customer name should not be in an order table.  It's an attrbiute of a customer and belongs in the customer table.

  Last, don't store fields that depend on other fields.  For example, and extended cost field, which is Qty * Price.  You store qty and price and then calculate extended cost when needed.

  Describe more of what it is your trying to do and we'll help you out.

Jeffrey CoachmanMIS LiasonCommented:
<Describe more of what it is your trying to do and we'll help you out.>

Yes, please provide a specific example using real field names and values...
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

error77Author Commented:
OK, I'll be more specific.

I have a form that contains this:

Car   |  Y / N  |  Description | Colour |   Comments
Door |    N      |   4 door       |   Red  |  some comment  
Tyre !    Y      !   sports       |  Black |   some other coment

Anyway, you can see what I'm trying to do here....

How do I get this on a DB table ?

Jeffrey CoachmanMIS LiasonCommented:
Create a table

In design view create your 5 fields.
Set the appropriate Datatypes and properties of each filed.

But then what you are really asking is how to create a table...

If you are this new to MS Access, I suggest that you obtain a good reference book on MS Access basics:


those are 5 individual fields in the table. So 5 different field types...
Jeffrey CoachmanMIS LiasonCommented:
...Also note that you can press the F1 function key at any time to get help on the specific section your are in...



Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now