graphic1

Exam 77-424: Microsoft Access 2013
5.0 Create Reports
5.3 Format a Report: Add Calculated Fields

Add the Calculated Controls

7. Try it: Add the Calculated Controls

Go to Report Design Tools ->Design->Tools.

Click on Add Existing Fields, again.

Drag the following Fields to the Report:
ReceiptID
CountofMovies
SumofPrice

Try This, as Well: Edit the Fields
Select a Field: ReceiptID.

Edit the label: Receipt.

 

Select another Field: CountofMovies.

Edit the label: No of Movies.

 

Select a Field: SumOfPrice.

Edit the label: Total Due.

 

Try This, Too: Format the Field Outline

Select all of the Fields in the Detail Section.

Go to Report Design Tools ->Format.

Go to Control Formatting-> Shape Outline.

Choose an Outline Color: Transparent.

Please resize and position the Fields as needed.

Keep going...

Report Design Tools ->Format->Control Formatting

graphic2