Final answer:
To create a custom form with fields from one or more tables presented in a different order, the Form Design Wizard is used. It allows flexibility in arranging data for user-friendly forms and can group data from multiple tables in an effective way.
Step-by-step explanation:
To create a form using some of the fields in one or more tables and display them in a different order than they are defined in the table, you would use the Form Design Wizard. This tool allows you to select different fields from various tables, arrange them in the order you prefer, and create a user-friendly form for data entry or display. It's not about one table being more correct than the other; rather, it's about the flexibility to present data in the most useful way for the user.
Regarding how data can be grouped, it can be beneficial to group data in a form according to how users will interact with it. For instance, grouping related fields together can make a form more intuitive. An advantage of using the Form Design Wizard is that it provides a guided approach to form creation, ensuring that data from multiple sources can be effectively organized and utilized in a custom form.
The reason for switching between tables when using the Form Design Wizard is to pull in the necessary fields from different tables to create a cohesive and comprehensive form that meets the end-users' requirements. The wizard facilitates this process, ensuring that relevant data from across the database can be consolidated as needed in the form layout.