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.