The
Accounting Ledger Database Template for Access 2003 allows you to create a basic chart of accounts and transaction ledger. It's available for free from the Microsoft Access Templates library.
Download the
Accounting Ledger Database Template.
You can use SQL JOIN statements to combine data from three or more tables. In an earlier article, we took a look at using
inner joins and
outer joins to combine data from two different tables. In many cases, you’ll want to take this a step further and combine data from three or more tables. In
Joining Multiple Tables with SQL Inner Join Statements, we look at the SQL statements that allow you to accomplish this goal for an inner join.
Read the full article:
Joining Multiple Tables with SQL Inner Join Statements