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.
- 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.