The Producers

Most businesses are date driven. For example, these movies are rented for 1, 3, or 5 days. If the movies are not returned as agreed, the customer could be notified which movies are overdue. These business rules can be programmed into our Mighty Access database. A Query can calculate the difference between the date the movie was rented and the current date.

This lesson begins by creating the Record Source for the Overdue Movie Report, a Query that calculates the numbers of days that each movie is overdue.

 

The Report will be Grouped by Customer and formatted so that there is only one customer per page.

 

So, our tardy customers get an Overdue Movie Report that is formatted like a letter. 

 

Microsoft Office Access 2010: Example of the completed Overdue Movie Letter