Don't Delete! Marking Records Inactive. When and When NOT to Hard Delete Data in Microsoft Access

Share this & earn $10
Computer Learning Zone
Published at : 02 Jan 2021
1755 views
55
0

Learn when you should and should NOT delete data from your Microsoft 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:
https://youtu.be/CZnVcSrjfKw

BECOME A MEMBER:
https://youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join

LINKS TO TOPICS MENTIONED:
Get on my Mailing List: https://599cd.com/YTML
Splitting Your Database: https://599cd.com/split
Relationships: https://599cd.com/relationships
Relational Combo Box: https://599cd.com/RelationalCombo
Concatenation: https://599cd.com/concat
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

ADDITIONAL RESOURCES:
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
Survey: https://599cd.com/survey
Richard's Blog: https://599cd.com/blog
Access Forum: https://599cd.com/AccessForum
Twitter: https://twitter.com/LearningAccess
https://en.wikipedia.org/wiki/Microsoft_Access
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft-365/blog/access/
Email Me: amicron@gmail.com

KEYWORDS:
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

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
microsoft accessms access#msaccess

Sword Art Online IN 5 MINUTES | Anime in Minutes

Sword Art Online IN 5 MINUTES | Anime in Minutes

A Geographic Park That Features Amazing Rock Formations

A Geographic Park That Features Amazing Rock Formations

Pocket Ants - Fire Ants Nest Completed!

Pocket Ants - Fire Ants Nest Completed!

Category Theory 1.2 : Examples of Categories and Clarification

Category Theory 1.2 : Examples of Categories and Clarification

Specialist - Persona 4 Reincarnation Extended

Specialist - Persona 4 Reincarnation Extended

Being A Professional: Dale Atkins at TEDxYouth@EHS

Being A Professional: Dale Atkins at TEDxYouth@EHS

ON THIS DAY by David Pomeranz with lyrics

ON THIS DAY by David Pomeranz with lyrics

Local Love Girls and boys Jangale #meeting Video new

Local Love Girls and boys Jangale #meeting Video new

reimbursement meaning in Hindi | reimbursement का हिंदी में अर्थ | explained reimbursement in Hindi

reimbursement meaning in Hindi | reimbursement का हिंदी में अर्थ | explained reimbursement in Hindi

Galaxy S21 - BIG PRICE CUTS

Galaxy S21 - BIG PRICE CUTS

What people would offer for SPRING HALO 2020 *Did i accept?*

What people would offer for SPRING HALO 2020 *Did i accept?*

A Gentle Wind

A Gentle Wind

stevie wonder's idol jake simpson.flv

stevie wonder's idol jake simpson.flv

Trying To Find Diamond | Minecraft Hardcore | Minecraft Hindi

Trying To Find Diamond | Minecraft Hardcore | Minecraft Hindi

INTERLOPER - Aaron Stechauner - An Emerald Flame (OFFICIAL DRUM PLAYTHROUGH)

INTERLOPER - Aaron Stechauner - An Emerald Flame (OFFICIAL DRUM PLAYTHROUGH)

“The Greatest of these is Charity”

“The Greatest of these is Charity”

Types of Brides: Lady and Tomboy / 14 Funny and Awkward Moments

Types of Brides: Lady and Tomboy / 14 Funny and Awkward Moments

Huthwaite's Focus on the Buyer

Huthwaite's Focus on the Buyer

U2 - With Or Without You Live from Paris

U2 - With Or Without You Live from Paris

Back to School Homeschool Room Makeover | Javlogs

Back to School Homeschool Room Makeover | Javlogs

Insta Heat Reusable Hand Warmers VERSUS HotHands Air Activated Hand Warmers

Insta Heat Reusable Hand Warmers VERSUS HotHands Air Activated Hand Warmers

MYGLAMM LIT LIQUID MATTE LIPSTICK + SWATCHES || KARA ANISHA

MYGLAMM LIT LIQUID MATTE LIPSTICK + SWATCHES || KARA ANISHA

Lil Peep - Haunt u (Extended+Lyrics)

Lil Peep - Haunt u (Extended+Lyrics)

Why You Never Mess With the Most Protected President in the World

Why You Never Mess With the Most Protected President in the World

Fastest Sniper Reacts to FACEIT LEVEL 10 VS CS:GO CHEATER!

Fastest Sniper Reacts to FACEIT LEVEL 10 VS CS:GO CHEATER!

$5,000 Live Premiere Stream From Las Vegas - Up To $75 A Spins ! High Limit Slot Play At Casino

$5,000 Live Premiere Stream From Las Vegas - Up To $75 A Spins ! High Limit Slot Play At Casino

World's Smallest Bluetooth Speaker!

World's Smallest Bluetooth Speaker!

Leetcode 1702. Maximum Binary String After Change

Leetcode 1702. Maximum Binary String After Change

Mariana Trench - The Life Challenges at the Deepest Sea Floor (10KM Below Water Level)

Mariana Trench - The Life Challenges at the Deepest Sea Floor (10KM Below Water Level)

Fastest Skillful Workers Never Seen Before! Amazing Machines and Ingenious Tools #31

Fastest Skillful Workers Never Seen Before! Amazing Machines and Ingenious Tools #31

How to Check Laptop or PC Serial number or Product ID (No Software)

How to Check Laptop or PC Serial number or Product ID (No Software)

6of7 The Proven History & Facts Against The Bible

6of7 The Proven History & Facts Against The Bible

How to regulate a mechanical watch - watch repair tutorial

How to regulate a mechanical watch - watch repair tutorial

Twenty-ninth Sunday in Ordinary Time

Twenty-ninth Sunday in Ordinary Time

Special Bulletin (1983)

Special Bulletin (1983)

Extremely GUSTY Crosswind LANDING Boeing 737-400 Milan | Cockpit View | Life Of An Airline Pilot

Extremely GUSTY Crosswind LANDING Boeing 737-400 Milan | Cockpit View | Life Of An Airline Pilot

Declan McKenna - The Key to Life on Earth (Official Video)

Declan McKenna - The Key to Life on Earth (Official Video)

Shahzad Cattle Farm in Shiekhupura|Top Quality Katta Farming|Business talks official

Shahzad Cattle Farm in Shiekhupura|Top Quality Katta Farming|Business talks official

Facing The Consequences Of Binge Drinking

Facing The Consequences Of Binge Drinking

Words you should not miss in 2021/New English Words Trending In 2021

Words you should not miss in 2021/New English Words Trending In 2021

IDEA: Individuals with Disabilities Education Act: History and Summary

IDEA: Individuals with Disabilities Education Act: History and Summary

PXSL Semifinal Vikendi Match Chicken | Qualified For Final 🔥 | 4K

PXSL Semifinal Vikendi Match Chicken | Qualified For Final 🔥 | 4K

COST OF LIVING IN DALLAS   TEXAS, WHAT A ONE ADULT WOULD NEED TO GET BY

COST OF LIVING IN DALLAS TEXAS, WHAT A ONE ADULT WOULD NEED TO GET BY

Hell To Your Doorstep

Hell To Your Doorstep

KAGUM SAMPE NANGIS MAIN INI GAME | A WAY OUT #11

KAGUM SAMPE NANGIS MAIN INI GAME | A WAY OUT #11

Hill Climb Racing - NEW MAP Prognosis 1.44.0 GamePlay

Hill Climb Racing - NEW MAP Prognosis 1.44.0 GamePlay

Inverted Conditionals & Even if, Only if, Unless - English Grammar with JenniferESL

Inverted Conditionals & Even if, Only if, Unless - English Grammar with JenniferESL

Junagadhના 8 સિંહને Uttar Pradesh લઈ જવાશ, Central Authority of Indiaએ  આપી મંજૂરી

Junagadhના 8 સિંહને Uttar Pradesh લઈ જવાશ, Central Authority of Indiaએ આપી મંજૂરી

Trendline Trading CHEAT SHEET For Beginners (10 Rules to Make Money Trading Price Action)

Trendline Trading CHEAT SHEET For Beginners (10 Rules to Make Money Trading Price Action)