tag:blogger.com,1999:blog-31935369959438734282024-03-05T12:25:05.932+07:00Simple Access Visual Basic ApplicationAn application case study of accounting system design using Microsoft Access 2007 or Access 2010Unknownnoreply@blogger.comBlogger17125tag:blogger.com,1999:blog-3193536995943873428.post-76186386237338498402011-11-01T17:16:00.000+07:002016-02-26T15:42:10.709+07:00Modifying the Journal Entry FormIn the previous posting, you have known already, how to create journal entry
form using Form Wizard. But the result is a rough form of Journal Entry. We
should reformat and add additional function in it. Now open form frmOpenTransactionJournalParent
in design view, as depicted below:<br>
<a href="http://simple-access-vba.blogspot.com/2011/11/modifying-journal-entry-form.html#more">Read more »</a>Unknownnoreply@blogger.com2tag:blogger.com,1999:blog-3193536995943873428.post-26869215435538125732011-11-01T17:15:00.001+07:002011-11-02T09:14:57.392+07:00Why We Should Use Parent and Child Table to Make a Journal Entry FormThere are several ways to create a table for recording transaction journal. Several
software developers like to make a table that contains all the required fields in
a single table of the journal, some other divide the table in 2 parts: the parent table and the child table. In essence, these two
types of tables will give the same results. But in the process they are different.<br>
<a href="http://simple-access-vba.blogspot.com/2011/11/why-we-should-use-parent-and-child.html#more">Read more »</a>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-3193536995943873428.post-75191250070401746662011-10-10T13:26:00.000+07:002016-02-26T15:37:22.900+07:00Modify the Report Based on Control SettingIn previous posts, you already know how to
create simple reports using the Report Button provided in the Reports Group. This posting will modify the report that was created to be displayed according to our
settings like in the picture below.<br>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgpiMoynPeHzAVXpFuWew-rscz6RnrOSe0QoopyaBG0G6XU84PseW3QcQ2FbhGfEYfFjXRu5JBxrIEIzk6geZI0acDcug80D1E35w2PM_IR-rzdvoYhks6DAiDPt62OtvEZcWKtIWqEyNSw/s1600/preview-report-1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="156" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgpiMoynPeHzAVXpFuWew-rscz6RnrOSe0QoopyaBG0G6XU84PseW3QcQ2FbhGfEYfFjXRu5JBxrIEIzk6geZI0acDcug80D1E35w2PM_IR-rzdvoYhks6DAiDPt62OtvEZcWKtIWqEyNSw/s320/preview-report-1.jpg" width="320"></a></div>
<div class="separator" style="clear: both; text-align: left;">
</div>
<a href="http://simple-access-vba.blogspot.com/2011/10/modify-report-based-on-control-setting.html#more">Read more »</a>Unknownnoreply@blogger.com2tag:blogger.com,1999:blog-3193536995943873428.post-75659160293877325852011-09-21T13:41:00.003+07:002011-09-21T13:44:56.838+07:00Create a Report Using Report ButtonReport button in Create tab - Report groups can be used to create a basic report on the data in the current table or query, to which you can add features such as groups or totals. It is very easy to apply. Point your mouse to the table the report you want to create, and click Report button. Finish.<br>
<a href="http://simple-access-vba.blogspot.com/2011/09/create-report-using-report-button.html#more">Read more »</a>Unknownnoreply@blogger.com18tag:blogger.com,1999:blog-3193536995943873428.post-38796264805678920602011-09-21T10:28:00.000+07:002016-02-26T13:47:07.052+07:00Enter Record In the Tables Using FormAfter knowing how to create table and form in MS Access, the next step is create query and report.
Before doing that, you have to enter record in each table, especially
<a href="http://simple-access-vba.blogspot.com/2011/09/create-tables-in-ms-access-master-table.html">master
tables</a> in the form we have created. To enter such records, make sure that
you have add additional control, depicted below, on each form (put the on Form Header). If not yet,
please read
<a href="http://simple-access-vba.blogspot.com/2011/09/control-form-using-module.html">Control the Form Using Module</a>
and follow the steps provided there.<br>
<a href="http://simple-access-vba.blogspot.com/2011/09/enter-record-in-tables-using-form.html#more">Read more »</a>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-3193536995943873428.post-44323789194531327362011-09-19T11:49:00.000+07:002011-09-19T14:20:34.412+07:00Control the Form Using ModuleWe have created a form with a simple way in which the form has not been added
or installed any feature that will help us work quickly - such as print or view current form. On the other hand, we have created a module contains functions that
at any time we can call in such an easy
way in the objects we have created. Basically, MS Access has feature to run the function in the module we have created
but unfortunately, that function can only be applied in a predetermined form, namely through the class module. In contrast with the standard module, which is created as a separate object in
the Access Navigation Pane.<br>
<a href="http://simple-access-vba.blogspot.com/2011/09/control-form-using-module.html#more">Read more »</a>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-3193536995943873428.post-87294545290484177942011-09-18T13:54:00.000+07:002016-02-17T22:32:29.053+07:00Create Functions using Module<br>
In MS Access, modules contain declarations, statements, and procedures or functions
that are programmed in a structured and systematic manner as a single unified
entity. There are two types of MS Access module, class module and standard module. Class
module is on a form or report, and usually contains a specially programmed procedures for
its form or report. Standard module contains general procedures that are not associated with or can be used on other objects
- such as query, form, and report. Standard modules are listed under Modules in the Navigation Pane, while
a class module not.<br>
<br>
<a href="http://simple-access-vba.blogspot.com/2011/09/create-functions-using-module.html#more">Read more »</a>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-3193536995943873428.post-12558924085825877832011-09-18T07:00:00.002+07:002011-11-01T18:07:27.088+07:00Create a Form with Sub Form Using Form WizardCreating a form with a sub form in MS Access is best applied to the table that have the one-to-many relationship with another table. The objective is to eliminate redundancy in one or more fields in a table. <br>
<br>
In general, tables that will be the form is a parent table, while the table to be used as a sub form is a child table that is relevant to the parent table. For example, forms invoices, bills, purchase orders, and various other forms that have a number of details of more than one item. Of the tables we have created, table tblOpenTransactionJournalParent will become a form with table tblOpenTransactionJournalChild that will become its sub form; table tblPermTransactionJournalParent and tblPermTransactionJournalChild are as well.<br>
<a href="http://simple-access-vba.blogspot.com/2011/09/create-form-with-sub-form-using-form.html#more">Read more »</a>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-3193536995943873428.post-46246915694177736242011-09-17T05:44:00.000+07:002011-09-18T19:27:42.004+07:00Create a Form Using Blank Form
If you want to create a form based on your own customized style, then you can create it by using Blank Form. MS Access give much more flexibility on using Blank Form in designing a form. To create a form
using Blank Form, do the following steps:<br>
<ol>
<li>Click Create tab, on the Forms group click Blank Form icon. Access will
display a blank form viewed in Layout View and Field List on the right.</li>
<li>Choose tblDerivativeAccount1 in the Field List. Point the mouse to the
field DerivCode1. To put this field into the Layout View of the blank form,
double click this field or drag it into the blank form. Do the same thing
for field DerivName1.</li>
</ol><a href="http://simple-access-vba.blogspot.com/2011/09/create-form-using-blank-form.html#more">Read more »</a>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-3193536995943873428.post-28164944341633035412011-09-16T16:55:00.001+07:002011-09-17T05:48:18.187+07:00Create a Form Using Form Wizard<div class="separator" style="clear: both; text-align: left;">
Form is one of the user interface between users and database. In the case of MS Access
database, the form is user interface between the user and the table. To add, delete, edit, and save a record, a user is not allowed (forbidden) to do so directly through the table. Database management systems such as
MS Access, mySQL, SQL Server are an integrated database. So if we do edit a record
directly in a table, other table(s) may be disturbed, so that the database may corrupt,
become out of sync, or possibly be crashed. For that reasons, we should use form
to add, delete, edit, and save a record. Other than that, form can be used as a
navigation, guideline, even alert when an error occurred.</div>
<a href="http://simple-access-vba.blogspot.com/2011/09/create-form-using-form-wizard.html#more">Read more »</a>Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-3193536995943873428.post-15784941822892233422011-09-16T10:34:00.004+07:002011-09-17T09:03:20.923+07:00Create Tables RelationshipAfter 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.<br>
<br>
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.<br>
<a href="http://simple-access-vba.blogspot.com/2011/09/tables-relationship.html#more">Read more »</a>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-3193536995943873428.post-76905127024946474522011-09-16T09:08:00.000+07:002011-09-17T08:51:25.115+07:00Create Tables in MS Access - Transaction Table<br>
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.<br>
<br>
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: <br>
<ol>
<li>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
</li>
<li>Child table: contains information that is details such as account codes, references, debits, credits, and descriptions of the transactions.</li></ol><a href="http://simple-access-vba.blogspot.com/2011/09/create-tables-in-ms-access-transaction.html#more">Read more »</a>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-3193536995943873428.post-80834878106855751642011-09-15T10:34:00.002+07:002011-09-21T10:05:57.291+07:00Create Tables in MS Access - Master TableAfter 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.<br>
<a href="http://simple-access-vba.blogspot.com/2011/09/create-tables-in-ms-access-master-table.html#more">Read more »</a>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-3193536995943873428.post-2902397036074119282011-09-14T10:16:00.001+07:002011-11-01T03:52:17.843+07:00Chart of AccountChart of account is account codes and account names to be used to record transaction journal. This blog does not discuss various types of chart of accounts theory. This blog will only explain an ideal chart of account based on experience or practice and is very useful for user at the clerical level. As you know, day to day activities related with chart of account mostly used by user, in this case, employee at the clerical or staff level. At the supervisory or managerial level, chart of account is very important also, but they never involved directly in the daily recording transaction journal as the clerical staffs do. In addition, at the supervisory level and above, user usually are able to understand accounting system easily so that they can remember the account code without using any supporting tool.<br>
<a href="http://simple-access-vba.blogspot.com/2011/09/chart-of-account.html#more">Read more »</a>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-3193536995943873428.post-524349577257886252011-09-14T09:03:00.000+07:002011-09-21T10:34:28.917+07:00The Fundamental Accounting EquationAs a rule of thumb, work in the field of accounting ranging from the knowledge base called “the fundamental accounting equation”. The fundamental accounting equation is as follows:
<br>
<br>
Assets = Liabilities + Owner’s Equities
<br>
<div>
<br>
If Owner’s Equities = Preferred Stocks + Common Stocks + Additions Paid in Capital + Translation FX currency + Retained Earnings
<br>
<i>and</i><br>
Equities = Preferred stocks + Common Stocks + Additions Paid in Capital + Translation FX Currency
<br>
<i>then </i><br>
Asset = Liabilities + Equities + Retained Earnings
<br>
Assets = Liabilities + Equities + Revenues – Expenses
<br>
Assets + Expenses = Liabilities + Equities + Revenues
<br>
<br></div>
Assets, liabilities, equities, expense, and revenues are called the elements
of financial statement. The first three are the elements of balance sheet and
the last two are the elements of income statement.<br>
<a href="http://simple-access-vba.blogspot.com/2011/09/fundamental-accounting-equation.html#more">Read more »</a>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-3193536995943873428.post-65748497066057640162011-09-13T20:00:00.000+07:002011-09-13T20:03:37.128+07:00Accounting CycleAccounting cycle define as stages in the process of recording accounting transaction. It started from recognition of a valid document or transaction evidence and finished when accounting period is closed.<br>
<br>
The stages of transaction recording process are as follow:<br>
<a href="http://simple-access-vba.blogspot.com/2011/09/accounting-cycle.html#more">Read more »</a>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-3193536995943873428.post-60793164128986148642011-09-13T19:45:00.000+07:002016-11-25T14:16:57.554+07:00Accounting System at a GlanceAs part of the information science related, today’s accounting practices can not be untied from using of information technology – mainly computer – that is used to input, process, and blend accounting data to become information that is used for decision making.<br>
In the information concept, we know the term Input -> Process -> Output, or known as I-P-O. There is term like that also in accounting information system.<br>
<a href="http://simple-access-vba.blogspot.com/2011/09/accounting-system-at-glance.html#more">Read more »</a>Unknownnoreply@blogger.com0