• September 21, 2021


Bring Technology Ideas with you

By the definition from Microsoft Access helps: FORM in Microsoft Access is a database object that you can use to create a user interface for a database application. A “bound” form is one that is directly connected to a data source such as a table or query, and can be used to enter, edit, or display data from that data source. There are many way to display your data using Form such as Form Design, Form Wizard, Split Form, Modal Dialog, etc.

    Creating Form in Microsoft Access

    However, our project will using the Modal Dialog Form for our data display. Why we choose this form? Modal Dialog is much more easy for us by auto pop up and customizable in the property setting. Form Property is the place where we can customize the form based on what you want such as title, color, header, footer, etc.

      Property Sheet for Form

      In the property there are main categories such as Format, Data, Event, Other, and All. The All is the place where all the categories are being collected in one place. Format Tab is using for creating or formatting any tools or objects in the form. Data Tab is using to customize data sources which you want to store in on the form while the Event Tab tells you what the object is doing on the form. For instance, the Command Button is using as close tab.

      To get back to our project, we are using Modal Dialog Form as our tools. To create Modal Dialog, please follow our steps:

      —> Go to Create Menu, Then in the Form Option Group, please select More Forms. You will see the drop down list of form, then select Modal Dialog

        Create Modal Dialog Form

        After selecting or clicking on it, you will see the form will create as image below:

          Modal Dialog Form After Creating

          To save Form, Please right Click on the Form1 Tab then choose Save. With the save Wizard, please name your form. You can put any name as your wishes. For example, I have named as Dashboard

            Save the form

            By rename as Dashboard, then click Ok

              Save Form as
                Result from Save As

                The next tutorial, we will show you how to Design Form Dashboard for the project, please keep in touch in our tutorials.

                Related post