A
Access Learner
Is the sequence of fields in a Microsoft Access database table important? Why?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gina Whipp
Since you shouldn't use the tables for data entry the answer is no.
U
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
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
J
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]