Create Tables Relationship

After creating and identifying the necessary tables in an accounting system, the next step is to create a relationship. Relationship describes the relations among tables in MS Access database. Once this relationship is finished, then you can design forms, reports, and queries.

A relationship works by matching data in primary key fields, usually fields with the same name in both tables. In most cases, the relationship matches the primary key from one table, which provides a unique identifier for each row, with an entry in the foreign key in the other table.

Create Tables in MS Access - Transaction Table

In the accounting system, transaction table is a table containing the financial events that are recorded each time a transaction occurred based on valid evidences or documents.

The process of recording in a journal is stored in the transaction table. Generally, journals of transactions that will be created consist of two tables:

1. Parent table: contains information that is global and is a summary, for example, the ID number of the journal, the journal type, journal name maker, name of the verifier/approver
2. Child table: contains information that is details such as account codes, references, debits, credits, and descriptions of the transactions.

Create Tables in MS Access - Master Table

After identifying a glimpse of things related to the accounting system, now is the time for us to learn how MS Access works. As a starting point, we will create a very simple accounting system, the objective is that we know better what it is MS Access. Slowly but surely, we will add a variety of features that will benefit us.