field properties in table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am a new Access user and don't use code, just the wizards & design view. I
am trying to create some large tables that will have multiple fields that
have the same properties (e.g. field size, format, validation rules) and
wanted to know if there was a way of doing this without using code and
without entering each one by hand. Any ideas? Thanks!
 
Why would you have a large number of fields with the same properties?
Sounds like you may not be building a properly "normalized" database. What
will your table structure be? If each field will contain the same type of
data, then you should probably be building more than one table and using a
one-to-many relationship. Not only will that make your setup easier and
more correct, but it will end up saving you tons of effort down the road
when you start working with this data.

Before you commit "spreadsheet" on your database, post back with more
details about your data structure.
 
I am essentially using Access for data entry into forms that will result in
data tables. The data input will be things like questionnaires, where
multiple items may have the same response options and properties. I want to
use Access because of the validation rules which will keep data entry more
accurate and the flexibility to export to other programs. Do you have
suggestions for how I can do this?
 
Again, we need some details. Give me some specific field names and
descriptions. Sounds like you are not following database normalization
rulles. Sounds like you are trying to build a spreadsheet in Access. That
is not waht Access is for.

If you have a questionaire situation, there are already a few good templates
out there that will probably do what you want. If you need to build one
from scratch though, you would most likely need a handful of tables with a
handful of fields. Your original question implies that you are building one
table with hundreds of fields.

In short, I bet your structure is flawed. Give us some specifics.
 
Back
Top