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.

Silver members and up get access to an Extended Cut of this video. 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.

MEMBERS-ONLY EXTENDED CUT VIDEO:
[ Ссылка ]

BECOME A MEMBER:
YouTube: [ Ссылка ]
or My Site: [ Ссылка ]

LEARN MORE:
[ Ссылка ]

PREREQUISITES:
Account Balances 1: [ Ссылка ]
Account Balances 2: [ Ссылка ]
Split Your Database: [ Ссылка ]

SUGGESTED TEMPLATE:
Account Balances Template: [ Ссылка ]

LINKS:
Relink Tables: [ Ссылка ]

RECOMMENDED COURSE:
Relink with VBA: [ Ссылка ]

FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: [ Ссылка ]
Blank Template: [ Ссылка ]
Contact Management: [ Ссылка ]
Order Entry & Invoicing: [ Ссылка ]
More Access Templates: [ Ссылка ]

ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: [ Ссылка ]
How to Use Access in 30 Minutes: [ Ссылка ]
$1 Access Level 2: [ Ссылка ]
Donate to my Tip Jar: [ Ссылка ]
Get on my Mailing List: [ Ссылка ]
Contact Me: [ Ссылка ]
TechHelp: [ Ссылка ]
Consulting Help: [ Ссылка ]
Twitter: [ Ссылка ]
[ Ссылка ]
[ Ссылка ]
[ Ссылка ]

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

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

свернуть