![purpose of microsoft access purpose of microsoft access](https://s3.studylib.net/store/data/007867512_2-4c2c7763fc27429ab83b7c3c9ada3fd4-768x994.png)
The primary form is called the main form, and the form that is enclosed in form is called the subform. Another advantage to using a subform is that it is linked to a separate form which can be opened by itself.Ī subform is a form that is inserted in another form. This lets you display the most critical fields, while providing access to the others. When you place a subform, you can decide how much of the form you want to see, before having to use the scroll bars. Subsequently, one may also ask, what are the advantages of having the subform be a separate object? It doesn't happen often, but it does happen. After a year or two of use, an Access database can become vital to the organization. Select the Data Source to use for the SubForm. Occasionally, an Access database grows beyond its original purpose.In the left Navigation Pane, right-click on the form and select Design View from the contextual menu.
#PURPOSE OF MICROSOFT ACCESS HOW TO#
Subsequently, question is, how do you create a subform? How to Add a Subform to a Form in Access 2016 The form and subform concept can be illustrated with the "Company-Product" example. A form/ subform combination is sometimes referred to as a hierarchical form, a master/detail form, or a parent/child form.
![purpose of microsoft access purpose of microsoft access](https://support.content.office.net/en-us/media/2b3f79b2-7629-44f8-a0c5-2c6f72bfd935.gif)
The primary form is called the main form. Part of the Microsoft 365 suite, Access is programmable using Visual Basic for Applications (VBA). For example, you would use a subform if you wanted to display an order with the order details.Ī subform is a form that is inserted in another form. A database program for Windows from Microsoft. It is generally used whenever you want to display data from multiple tables where there is a one-to-many relationship.