Administrator: Receipts Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26

Fundamental Changes

Tables are fundamental. Database designs begins with the tables. If it isn't in the tables, then it cannot be stored and used.

 

Take care if you need to modify tables when you already have users and data!! A good developer works on a copy of the software, and leaves the production database--the one with active users-alone. There will be more on database deployment in the next lesson.

 

Plan for Improvement

Here are the goals for the upgrade:

1. Add the DateReturned to tblMovieRented.

 

2. Add the DateReturned control to the ReceiptSubform.

 

3. Edit the Overdue Rental query to filter out the movies that were returned.