Don't Delete! Marking Records Inactive.
In this Microsoft Access tutorial, I will teach you when you should and should NOT delete data from your Access databases. We will "soft" delete customer records by marking them "inactive." We'll prevent users from deleting them by setting the Allow Deletions property to NO. I'll show you how to open your customer form to show either Active or Inactive customers. You'll learn how to create a list of only Active customers to select from in a combo box to add a new contact.
Ben from Jamestown PA (a Silver Member) asks: I've got a lot of customers in my database that I know will no longer be buying from me. Some have retired. Some are deceased. I need to keep their records in my table for accounting purposes, but I don't want them cluttering up my reports and combo boxes. How can I remove them without deleting them? Same thing goes with discontinued products.
BONUS FOR CHANNEL MEMBERS:
Silver Members and up get access to an EXTENDED CUT of this video which covers additional examples. That video will show you how to Archive data to a different table after a customer is marked inactive for 30 days. We will create a Contact Archive table, move the information to that table using an append and delete query, and then create a Union query to see how to put it back together again into one set of data, if we need to.
MEMBERS ONLY VIDEO:
BECOME A MEMBER:
LINKS TO TOPICS MENTIONED:
Splitting Your Database: https://599cd.com/split
Relational Combo Box: https://599cd.com/RelationalCombo
Union Query Expert 16: https://599cd.com/acx16
Cascade Deletes: https://599cd.com/cascade
Append Query: https://599cd.com/append
Union Query: https://599cd.com/union
FREE Access Level 1: https://599cd.com/Free1
FREE Customer Template Database: https://599cd.com/XCDT
$1 Access Level 2: https://599cd.com/1Dollar
Your Questions Answered: https://599cd.com/TechHelp
Learning Connection 50% OFF: https://599cd.com/Connection
Richard's Blog: https://599cd.com/blog
Access Forum: https://599cd.com/AccessForum
Email Me: firstname.lastname@example.org
microsoft access, ms access, #msaccess, #microsoftaccess, should we delete data, flag as not in use, mark inactive, mark as deleted, archive data, soft delete, hard delete, discontinued, terminated, delete best practices
Please feel free to post your questions or comments below. Thanks.