SQLConfiguration SQLConfiguration

Creating Forms «Prev 

Create a Form using the Form Wizard

  1. To start the Form Wizard display the Form view of the database window (shown here). Then double-click the "Create Form By Using Wizard" option.
  2. This window should look familiar since Access uses it every time it allows you to pick fields from multiple tables and queries.
    Select all the fields from the Clients table by clicking the double right arrow button.
  3. Now use the Tables/Queries drop-down list to select the Projects table.
  4. We need the Project Description, Start Date and Due Date from the Projects table. Double-click Project Description in the Available Fields box to select it. I’ll select the other two fields for you.
  5. You have now selected fields from the Clients and the Projects table. Proceed to the next window of the wizard by clicking the Next button.
  6. This window asks you how you want to arrange fields on the form. It suggests grouping by Clients. That means that all data from the Projects table for one client will be displayed with the client data for the same client. The alternative is to group by the data in the Projects table, which means that the client data would be repeated for each project--stick with grouping by Clients. Also stick with Form with subform(s), the option that displays all the data on one form. The Linked form option creates a second form with a button on the first form to link them. The box on the right shows the layout of the form with the selected options. Click the Next button accept the selected options and move to the next window.
  7. This window asks you to choose the layout for the subform (the data from the Projects table). The choices are Datasheet, which you saw in the form created in the AutoForm simulation, and Tabular. Choose Tabular, since you haven’t seen a form in a tabular layout yet.
  8. Notice the box now shows the layout with the subform in Tabular format. Click the Next button to move to the next window.
  9. This window asks you to choose a style for your form. When you use the Form Wizard in Access, you can click each style name to see an example of the style in the box. However (believe me) none of the styles is gorgeous. So stick with the Industrial style and click the Next button.
  10. The last window of the wizard asks you to name the form and any subforms. Name the form Client and Project Data by typing over the name currently displayed (We’ll do it for you in this Simulation). There is no need to change the name of the Subform. And since you haven't learned anything yet about form design view, you can leave the other option as it is (Open the form to view or enter information). Click the Finish button to see the form.
  11. I have reduced the size of this window so that you can get a feel of the form that the wizard created. You may notice immediately that not all the fields fit, particularly in the subform--that's why you need to learn how to manipulate the form design. But you do have a form and subform with all the fields you need, so the Form Wizard has given you a good start.