How to Create Forms in Microsoft Access on Windows 11

Posted on 16th June 2023

Introduction

Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft Office suite of applications, included in the Professional and higher editions or sold separately.

Access stores data in its own format based on the Access Jet Database Engine. It can also import or link directly to data stored in other applications and databases. Software developers and data architects use Microsoft Access to develop application software.

Creating Forms in Access

Forms in Access are used to enter, edit, or display data from a table or query. You can use the Form Wizard to create a form based on all or part of a table or query. You can also create a form from scratch.

Creating a Form with the Form Wizard

To create a form with the Form Wizard:

  1. On the Database Tools tab, in the Forms group, click Form Wizard.
  2. In the Tables/Queries drop-down list, click the table or query that contains the data you want to use in your form.
  3. In the Available Fields list, double-click each field that you want to add to the form, or click the field, and then click the > button.
  4. Click Next.
  5. In the Form Type area, click the type of form layout that you want to use, and then click Next.
  6. In the Format area, click the format that you want to use, and then click Next.
  7. In the Style area, click the style that you want to use, and then click Next.
  8. In the Font area, click the font that you want to use, and then click Next.
  9. In the Layout area, click the layout that you want to use, and then click Next.
  10. In the Navigation area, click the method that you want to use to navigate the records in your form, and then click Finish.

Creating a Form from Scratch

To create a form from scratch:

  1. On the Database Tools tab, in the Forms group, click Form.
  2. In the New Form dialog box, click Blank Form.
  3. Click Design View.
  4. On the Design tab, in the Controls group, click the button or control that you want to add to the form.
  5. Click the form, and then drag to the size that you want.
  6. To add a label, on the Design tab, in the Controls group, click Label.
  7. Click the form, and then drag to create the label.
  8. Type the text that you want to display in the label.
  9. To add a text box, on the Design tab, in the Controls group, click Text Box.
  10. Click the form, and then drag to create the text box.
  11. In the Control Source property box, type the field name that you want to display in the text box. The field name must be enclosed in square brackets ([ ]).
  12. To add a command button, on the Design tab, in the Controls group, click Command Button.
  13. Click the form, and then drag to create the command button.
  14. In the Control Source property box, type the text that you want to display on the button.
  15. To add an image, on the Design tab, in the Controls group, click Image.
  16. Click the form, and then drag to create the image.
  17. In the Control Source property box, type the path and file name of the image that you want to display, or click the builder button (…) to select the image.
  18. To add a list box, on the Design tab, in the Controls group, click List Box.
  19. Click the form, and then drag to create the list box.
  20. In the Control Source property box, type the field name that you want to display in the list box. The field name must be enclosed in square brackets ([ ]).
  21. To add a combo box, on the Design tab, in the Controls group, click Combo Box.
  22. Click the form, and then drag to create the combo box.
  23. In the Control Source property box, type the field name that you want to display in the combo box. The field name must be enclosed in square brackets ([ ]).
  24. To add an option button, on the Design tab, in the Controls group, click Option Button.
  25. Click the form, and then drag to create the option button.
  26. In the Control Source property box, type the value that you want to display in the option button. The value must be enclosed in square brackets ([ ]).
  27. To add a check box, on the Design tab, in the Controls group, click Check Box.
  28. Click the form, and then drag to create the check box.
  29. In the Control Source property box, type the value that you want to display in the check box. The value must be enclosed in square brackets ([ ]).
  30. To add an option group, on the Design tab, in the Controls group, click Option Group.
  31. Click the form, and then drag to create the option group.
  32. In the Control Source property box, type the field name that you want to display in the option group. The field name must be enclosed in square brackets ([ ]).
  33. To add a bound object frame, on the Design tab, in the Controls group, click Bound Object Frame.
  34. Click the form, and then drag to create the object frame.
  35. In the Control Source property box, type the field name that you want to display in the object frame. The field name must be enclosed in square brackets ([ ]).
  36. To add an unbound object frame, on the Design tab, in the Controls group, click Unbound Object Frame.
  37. Click the form, and then drag to create the object frame.
  38. In the Control Source property box, type the path and file name of the object that you want to display, or click the builder button (…) to select the object.
  39. To add an ActiveX control, on the Design tab, in the Controls group, click ActiveX Control.
  40. Click the form, and then drag to create the control.
  41. In the Control Source property box, type the path and file name of the control that you want to display, or click the builder button (…) to select the control.

Conclusion

In this article, we have shown you how to create forms in Microsoft Access on Windows 11.

Copyright © 2024 The Gadget Gazette