Me.Access

Master table for company identities is related to company data. It is not about a company image related with its vision, tagline, or some kind like that. Instead, the company identities consist of company name, address, website, phone number, etc. One of the functions is for exchange letters or correspondence purposes. Usually, the identities are placed on the header and caption of a report or form.

In our accounting database, we have two subaccounts that are part of the primary accounts. They are some sort of derivative accounts for the primary accounts. The two subaccounts may serve as profit center, cost center, organization unit, vendor, customer, tax, etc. The subaccounts are stored in two tables, one for subaccounts 1 and the other for subaccounts 2. Following are the explanation for both two tables.

We create a table for chart of primary accounts, a chart of accounts to be used as a basis for making financial reports. Chart of primary accounts is the list of account codes and names applied to record transaction into journal entries.