Integrating Excel and Access

Expense Entry

Because one of the requirements from the client is to produce income statements, you need to track expenses and put them in general ledger accounts. This means that you need a table to hold general ledger accounts; it would also hold the income accounts used in the services and charges table. Have a form that allows you to put in an effective date, a general ledger account, a description, and an amount. Depending on what the client wants, you might also create asset and liability accounts if they use double-entry accounting. For this project, I would just use income and expense. This section obviously requires some accounting knowledge; look at how this is implemented in the sample database if this section is confusing.