Загрузка страницы

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
Показать
Комментарии отсутствуют
Введите заголовок:

Введите адрес ссылки:

Введите адрес видео с YouTube:

Зарегистрируйтесь или войдите с
Информация о видео
18 сентября 2020 г. 5:23:42
00:10:00
Другие видео канала
How To Log User Activity In Access 2013 🎓How To Log User Activity In Access 2013 🎓Microsoft Access Backup Record Before Edited, OnDirty, Append Query, TechHelp Q&AMicrosoft Access Backup Record Before Edited, OnDirty, Append Query, TechHelp Q&AHow and Why to Split Your Microsoft Access Database - Linked Table, Front End, Back End, BenefitsHow and Why to Split Your Microsoft Access Database - Linked Table, Front End, Back End, BenefitsSimple Security for Microsoft Access Databases. Hide Tables. Disable Ribbon. Make ACCDE File.Simple Security for Microsoft Access Databases. Hide Tables. Disable Ribbon. Make ACCDE File.Using the Slider ActiveX Control in Microsoft AccessUsing the Slider ActiveX Control in Microsoft AccessMicrosoft Access Inventory Management System - Tracking Product Inventory, Stock Quantity on HandMicrosoft Access Inventory Management System - Tracking Product Inventory, Stock Quantity on HandChecklists in Microsoft Access. Keep History Archive. Recurring. Class Rosters. Safety Procedures.Checklists in Microsoft Access. Keep History Archive. Recurring. Class Rosters. Safety Procedures.Import New and Changed Records in Microsoft Access. Update Pricing from Vendor Excel SpreadsheetImport New and Changed Records in Microsoft Access. Update Pricing from Vendor Excel SpreadsheetHow to use Microsoft Access - Beginner TutorialHow to use Microsoft Access - Beginner TutorialMicrosoft Access 2010 Tables: Tracking Field ChangesMicrosoft Access 2010 Tables: Tracking Field ChangesAccess - How to log the Windows UsernameAccess - How to log the Windows UsernameRecord Locking: Preventing Multiple Users from Editing the Same Data in Microsoft Access.Record Locking: Preventing Multiple Users from Editing the Same Data in Microsoft Access.Microsoft Access Beginner Full 3 Hour Tutorial Database Planning, Customer Table, Queries, FormsMicrosoft Access Beginner Full 3 Hour Tutorial Database Planning, Customer Table, Queries, FormsMicrosoft Access Cascading Combo Boxes - One Combo Box Selection Filters a Second Combo BoxMicrosoft Access Cascading Combo Boxes - One Combo Box Selection Filters a Second Combo BoxMicrosoft Access: Performing Calculations on Aggregate Query Results (aka Sum or Totals Queries)Microsoft Access: Performing Calculations on Aggregate Query Results (aka Sum or Totals Queries)Automatic Numbering of Records. Renumber Counter on Add, Delete. Row Numbers in Microsoft Access.Automatic Numbering of Records. Renumber Counter on Add, Delete. Row Numbers in Microsoft Access.How To Manage User Authorization and User Access in Access 2013 🎓How To Manage User Authorization and User Access in Access 2013 🎓Introduction to Programming in Visual Basic for Applications (VBA) in Microsoft Access (Access VBA)Introduction to Programming in Visual Basic for Applications (VBA) in Microsoft Access (Access VBA)AfterUpdate Event & DLookup Function in Microsoft Access - How to Look Up Values from Table to FormAfterUpdate Event & DLookup Function in Microsoft Access - How to Look Up Values from Table to FormManage Rental Inventory in Microsoft Access. Check In/Out Items, Books, Videos, Tools. In Stock.Manage Rental Inventory in Microsoft Access. Check In/Out Items, Books, Videos, Tools. In Stock.
Яндекс.Метрика