Track Account Balances & Transactions, Part 3

This is part 3 of my Microsoft Access Account Balances tutorial series. In this series we will build a database to track your account balances and daily transactions.

Today we're going to split the database into front-end and back-end (table) files to make it easy to switch which "company" of data you're working with. I'm mostly doing this for me so I can switch between my actual data and the class sample data, but you can use it as well if you want to keep data for multiple companies, people, etc. We're also going to pretty up the Main Menu. 

Members

Members will learn how to relink the tables automatically with some VBA by simply having the user select the company name from a combo box on the main menu. The code will handle all the magic.

•  01. Free Video
•  02. Extended Cut Video - Silver Members
•  Database Download - Gold Members

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Prerequisites

• Account Balances 1: https://599cd.com/AccountBalances1
• Account Balances 2: https://599cd.com/AccountBalances2
• Split Your Database: https://599cd.com/Split

Suggested Template

• Account Balances Template: https://599cd.com/Balances

Links

• Relink Tables: https://599cd.com/Relink

Recommended Courses

• Relink with VBA: https://599cd.com/ACD33

Next Video

• Account Balances 4: https://599cd.com/AccountBalances4

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Diamond Sponsors - Information on our Sponsors Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

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, split database, relink tables automatically with vba, select backend file from list