Tracking Changes to Data in Microsoft Access - Audit Trail - Log User Activity - Record Edits
Do you want to keep a log of any changes that are made to records in your database? In this video, I'll show you how.
Allison from Tennessee (a Gold Member) asks, "I've got a few different users who work with my database. Is there a way I can track what information they change?
LEARN MORE:
Append Query: https://599cd.com/append
SQL Basics: https://599cd.com/sql
Security Seminar: https://599cd.com/security
BONUS FOR CHANNEL MEMBERS:
Silver Members and up get access to an EXTENDED CUT of this video which covers additional examples. That video covers tracking changes to just sensitive fields, such as "Customer ID 4 credit limit changed from $5000 to $9000." We'll also build a simple user combo box on the Main Menu so you can track WHICH user made changes to records.
MEMBERS ONLY VIDEO:
https://youtu.be/5JMAJJtnXA4
BECOME A MEMBER:
https://youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join
MEMBERS TOPICS:
OldValue Property: https://599cd.com/oldvalue
Double-Double Quotes: https://599cd.com/XCQKJ
ADDITIONAL RESOURCES:
FREE Customer Template Database: https://599cd.com/XCDT
FREE Access Level 1: https://599cd.com/Free1
$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
Email Me: amicron@gmail.com
https://en.wikipedia.org/wiki/Microsoft_Access
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft-365/blog/access/
ADDITIONAL KEYWORDS:
log user activity
track changes in field data
audit trail
recording edits
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Видео Tracking Changes to Data in Microsoft Access - Audit Trail - Log User Activity - Record Edits канала Computer Learning Zone
Allison from Tennessee (a Gold Member) asks, "I've got a few different users who work with my database. Is there a way I can track what information they change?
LEARN MORE:
Append Query: https://599cd.com/append
SQL Basics: https://599cd.com/sql
Security Seminar: https://599cd.com/security
BONUS FOR CHANNEL MEMBERS:
Silver Members and up get access to an EXTENDED CUT of this video which covers additional examples. That video covers tracking changes to just sensitive fields, such as "Customer ID 4 credit limit changed from $5000 to $9000." We'll also build a simple user combo box on the Main Menu so you can track WHICH user made changes to records.
MEMBERS ONLY VIDEO:
https://youtu.be/5JMAJJtnXA4
BECOME A MEMBER:
https://youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join
MEMBERS TOPICS:
OldValue Property: https://599cd.com/oldvalue
Double-Double Quotes: https://599cd.com/XCQKJ
ADDITIONAL RESOURCES:
FREE Customer Template Database: https://599cd.com/XCDT
FREE Access Level 1: https://599cd.com/Free1
$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
Email Me: amicron@gmail.com
https://en.wikipedia.org/wiki/Microsoft_Access
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft-365/blog/access/
ADDITIONAL KEYWORDS:
log user activity
track changes in field data
audit trail
recording edits
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Видео Tracking Changes to Data in Microsoft Access - Audit Trail - Log User Activity - Record Edits канала Computer Learning Zone
Показать
Комментарии отсутствуют
Информация о видео
18 сентября 2020 г. 5:23:42
00:10:00
Другие видео канала
![How To Log User Activity In Access 2013 🎓](https://i.ytimg.com/vi/GgX8qRz3mpA/default.jpg)
![Microsoft Access Backup Record Before Edited, OnDirty, Append Query, TechHelp Q&A](https://i.ytimg.com/vi/AtfjqHoKo98/default.jpg)
![How and Why to Split Your Microsoft Access Database - Linked Table, Front End, Back End, Benefits](https://i.ytimg.com/vi/olj2aO-se8E/default.jpg)
![Simple Security for Microsoft Access Databases. Hide Tables. Disable Ribbon. Make ACCDE File.](https://i.ytimg.com/vi/8G7oqRVeVDs/default.jpg)
![Using the Slider ActiveX Control in Microsoft Access](https://i.ytimg.com/vi/Snpfw1gcVZw/default.jpg)
![Microsoft Access Inventory Management System - Tracking Product Inventory, Stock Quantity on Hand](https://i.ytimg.com/vi/UpReMO7ik3Y/default.jpg)
![Checklists in Microsoft Access. Keep History Archive. Recurring. Class Rosters. Safety Procedures.](https://i.ytimg.com/vi/UX0FxXVGwjY/default.jpg)
![Import New and Changed Records in Microsoft Access. Update Pricing from Vendor Excel Spreadsheet](https://i.ytimg.com/vi/RZk6eTJjhGY/default.jpg)
![How to use Microsoft Access - Beginner Tutorial](https://i.ytimg.com/vi/ubmwp8kbfPc/default.jpg)
![Microsoft Access 2010 Tables: Tracking Field Changes](https://i.ytimg.com/vi/xbkQXOdeBWU/default.jpg)
![Access - How to log the Windows Username](https://i.ytimg.com/vi/pJL1CCfvf7s/default.jpg)
![Record Locking: Preventing Multiple Users from Editing the Same Data in Microsoft Access.](https://i.ytimg.com/vi/_bstegbUBPA/default.jpg)
![Microsoft Access Beginner Full 3 Hour Tutorial Database Planning, Customer Table, Queries, Forms](https://i.ytimg.com/vi/hMuSHYfG7H8/default.jpg)
![Microsoft Access Cascading Combo Boxes - One Combo Box Selection Filters a Second Combo Box](https://i.ytimg.com/vi/TFFpQTOkR-A/default.jpg)
![Microsoft Access: Performing Calculations on Aggregate Query Results (aka Sum or Totals Queries)](https://i.ytimg.com/vi/4N5Pm_3DA64/default.jpg)
![Automatic Numbering of Records. Renumber Counter on Add, Delete. Row Numbers in Microsoft Access.](https://i.ytimg.com/vi/2yj6x5E4Z_0/default.jpg)
![How To Manage User Authorization and User Access in Access 2013 🎓](https://i.ytimg.com/vi/DxRpo496w_c/default.jpg)
![Introduction to Programming in Visual Basic for Applications (VBA) in Microsoft Access (Access VBA)](https://i.ytimg.com/vi/uvmtcjJeBe4/default.jpg)
![AfterUpdate Event & DLookup Function in Microsoft Access - How to Look Up Values from Table to Form](https://i.ytimg.com/vi/NXgomWH4BqI/default.jpg)
![Manage Rental Inventory in Microsoft Access. Check In/Out Items, Books, Videos, Tools. In Stock.](https://i.ytimg.com/vi/SH83sg3lMXc/default.jpg)