Exam 77-424: Microsoft Access 2013 2.0 Build Tables 2.3 Manage Records: Delete Records

Deleting Data: Consider This! 1. Consider This: Should You Delete Data? Deleting data is not a good idea in a relational database. When you create a Receipt in our database, you need information from five Tables. Consider this scenario.   Say you deleted the Movie, "Brave" from tblMovies. Say the Primary Key, MovieID, for this Movie was 407.   Now, you want to run a Report that looks up all of the Receipts. Any Receipt that had MovieID 407 will be incomplete. There is no data because that Key is missing.   This is not good.   The preferred method is to Archive a Record by marking it as Archived, Done or Obsolete. Microsoft Access: Example of the warning message when a Record is deleted