Access 2016 Advanced

Lesson 1 - Using Subforms/Subreports

Access 2016

Steps

Practice Data

3. On the sub-menu, select Datasheet . The form appears in Datasheet view. 4. Select the plus sign next to the desired records. The subform data for the desired record appears.

Click Datasheet view

Click for record 3

Close the form.

D ISPLAYING A S UBFORM /S UBREPORT T OTAL



Discussion

Forms and reports often include totals for the information they contain. Totals are easily created by adding a calculated control to the form or report that contains an expression to find the desired total. Expressions are used to obtain information you cannot obtain directly from the tables in your database. For example, if you have a table that contains the quantity and cost of various items, you could use an expression to multiply the quantity and the cost to obtain the current inventory value. Every time you use a form/report, Access calculates any expressions contained in the form/report, helping you keep your information as accurate as possible.

Some examples of expressions are listed in the following table:

Control Name

Expression

Result

Adds the value of the Cost field, the value of the Shipping field, and the value of the Markup field of an item to produce the Total field. Multiplies the Price field of an item by a constant discount of 0.15. Provides the current date.

Total

=[Cost]+[Shipping]+[Markup]

Discount

=[Price]*.15

Date

=Date()

Page 10

OFFICEPRO, Inc.