Help

[Guest]

Is the sequence of fields in a Microsoft Access database table important? Why?

 

[Gina Whipp]

Since you shouldn't use the tables for data entry the answer is no.

 

[UpRider]

The only reason that I sequence fields in a table is to understand it
conceptually as I am creating it. It makes sense to have City, then State,
then Zip as you create the table. However, having created it that way, it
really makes no difference later. The order of fields during an update to
that table have no correlation whatsoever. In fact, queries based on the
table can reorder the fields in a "logical" or arbitrary manner. The table
doesn't care. Access doesn't care. The query doesn't care.
The user does care. Table data is presented to the user via forms. You
design your forms to present the data to your users in a logical way,
reorganizing the order that may happen to be in the underlying table or
query.

UpRider

 

[John W. Vinson]

Is the sequence of fields in a Microsoft Access database table important?
No.

Why?

Because you can present the fields in any desired order at any time, using a
Query and/or Form.

John W. Vinson [MVP]