Now you have some experience with an Access table you may be wondering how you can move and rearrange fields within a table. If you’ve tried and failed to move a column, there are a few ways to move them with ease in Access.

Watch the video and ask yourself a few questions and discuss your answers to them.

https://www.youtube.com/watch?v=VyZ234TaxcI

You can view the transcript for “Access 2016 Field Order and Size” here (opens in new window).

Discussion Questions

• If there are a few different ways to rearrange fields, which way do you prefer and why?
• What are some common mistakes made to move fields or records in an Access table?
• What do you consider the best view (Design View, Datasheet View) for rearranging fields? Why?

Share your opinions below and respond to two of your classmates’ thoughts.