Three Methods for Creating Tables to Track Transactions in Microsoft Access

In this Microsoft Access tutorial, I'm going to show you my three different methods for tracking transactions: using a single field, using two fields, and using a single field with a transaction type field.

Ian from Columbus, Ohio (a Platinum Member) asks: I'm designing a database to track my bank transactions. Should I use separate tables for deposits and withdrawals?

Silver Members and up get access to an Extended Cut of this video. Members will learn how to setup the third, most advanced transaction table with the transaction types.

MEMBERS VIDEO:
   • Transaction Tables EXTENDED CUT MEMBE...  

BECOME A MEMBER:
YouTube:    / @599cd  
or My Site: https://599cd.com/THMember

LEARN MORE:
https://599cd.com/TransactionTables

PRE-REQUISITES:
Calculated Query Fields: https://599cd.com/Calculated

LINKS:
Check Register: https://599cd.com/CheckRegTH
Reddit Discussion: https://tinyurl.com/2zs26u3v

RECOMMENDED COURSES:
Running Balances: https://599cd.com/ACX29

FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: https://599cd.com/THFree
Blank Template: https://599cd.com/Blank
Contact Management: https://599cd.com/Contacts
Order Entry & Invoicing: https://599cd.com/Invoicing
More Access Templates: https://599cd.com/AccessTemplates

ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: https://599cd.com/Free1
$1 Access Level 2: https://599cd.com/1Dollar
Donate to my Tip Jar: https://599cd.com/TipJar
Get on my Mailing List: https://599cd.com/YTML
Contact Me: https://599cd.com/Contact
TechHelp: https://599cd.com/TechHelp
Consulting Help: https://599cd.com/DevNet
Twitter:   / learningaccess  
https://en.wikipedia.org/wiki/Microso...
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft...

KEYWORDS:
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Microsoft Access transaction tables, Create a Transaction Table, transaction processing, Managing transactions

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.