Forum home » Delegate support and help forum » Microsoft Access Training and help » Re-organising table fields
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Re-organising table fields
Resolved · Low Priority · Version Standard
Reply Sat 23 Feb 2008, 21:17Delegate Mark said...
Mark has attended:
Access Intermediate course
Access Advanced course
Access VBA course
Re-organising table fields
I would like to revise the order that fields appear withn the design view of the main data table of a database in use. I know I can do this by manually dragging the fields, this is what I want to do. Is there possibly going to be any problem with operation of any queries (and forms based on those queries) or any other problem if I do this. I have tried it on small test database with no problem but would like more confidence with the big one (even though I would make a copy of the table first). This is a split databse incase that makes any difference.
For upcoming training course dates see: Pricing & availability
RE: Re-organising table fields
Changing the order of the columns will not affect any queries. As long as you do not change the name of the column or table then you will be fine. Nothing will ever relate to the ordering of the columns. Its always good to take backups, but you will be fine to do this.
|