Explain the advantage of creating a form with a subform.

What will be an ideal response?


When you use the Form tool to create a form, Access analyzes the table relationships in the database. If the table that the form is based upon is related to another table, Access automatically adds a subform to the main form. The subform displays records in the related table, generally organized in a datasheet format. For example, assume you have sales representatives stored in a Sales Reps table and related customer information stored in a Customers table. In this case, if you create a new form based on the Sales Reps table using the Form tool, Access will add a Customers subform to the bottom of the main form, displaying all customers assigned to each sales representative. You can modify records in both the main form and the subform.

Computer Science & Information Technology

You might also like to view...

The Internet does not currently offer any resource reservation or quality of service management facilities. How do the existing Internet-based audio and video streaming applications achieve acceptable quality? What limitations do the solutions they adopt place on multimedia applications?

What will be an ideal response?

Computer Science & Information Technology

Each template has guides already in place, depending on the type of template you are using, including all of the following EXCEPT ____.

A. margin guides B. baseline guides C. status guides D. column guides

Computer Science & Information Technology

The most common types of boards that hold memory chips are called SIMMs, DIMMs, and PIMMs.

a. true b. false

Computer Science & Information Technology

If the order of the sort is not specified, it is assumed to be descending.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology