How to Design a Form Filling Database Using Microsoft Access
Note that this article uses the HSBC TT form for an example., Scan a copy of your form., Open the MS access program., Create all fields according to manual form., Create a table., Create a database form for the form., Create database form for the...
Step-by-Step Guide
-
Step 1: Note that this article uses the HSBC TT form for an example.
This is a common form provided by HSBC in Asian countries. -
Step 2: Scan a copy of your form.
Identify how many fields you have to fill in the form.
In this example, there are 21 fields to fill. , Create a database, and name it appropriately.
If needed, you can give a reference number to identify your specific form.
Here it will termed "TT". , For the example form, a beneficiary name is commonplace.
You could therefore create a separate database for beneficiaries.
Once you create a name, you don't need to type multiple times because you can select it from the database. , In this case it is called “Bank” for the beneficiary's name. , This is the data entry form for the main table on the TT form. ,,, Insert the scan copy of the TT form. You can link the scanned copy of the TT form and set the details you need to fill. ,, Enter all the beneficiaries' names and start to fill the form.
When you enter the form, give the ref number continuously as 1, 2, 3, 4, etc. , Enter your reference number and any other details such as bank, amount and city of bank, etc.
Select the beneficiary's name, and the address and details will auto link and print the form with your laser printer. -
Step 3: Open the MS access program.
-
Step 4: Create all fields according to manual form.
-
Step 5: Create a table.
-
Step 6: Create a database form for the form.
-
Step 7: Create database form for the beneficiary's details.
-
Step 8: Create a query to find a TT that you entered.
-
Step 9: Create a report.
-
Step 10: Select the main table and link each field to scan
-
Step 11: and save.
-
Step 12: Print the TT form.
-
Step 13: After you create the database
-
Step 14: open and click "Fill TT".
Detailed Guide
This is a common form provided by HSBC in Asian countries.
Identify how many fields you have to fill in the form.
In this example, there are 21 fields to fill. , Create a database, and name it appropriately.
If needed, you can give a reference number to identify your specific form.
Here it will termed "TT". , For the example form, a beneficiary name is commonplace.
You could therefore create a separate database for beneficiaries.
Once you create a name, you don't need to type multiple times because you can select it from the database. , In this case it is called “Bank” for the beneficiary's name. , This is the data entry form for the main table on the TT form. ,,, Insert the scan copy of the TT form. You can link the scanned copy of the TT form and set the details you need to fill. ,, Enter all the beneficiaries' names and start to fill the form.
When you enter the form, give the ref number continuously as 1, 2, 3, 4, etc. , Enter your reference number and any other details such as bank, amount and city of bank, etc.
Select the beneficiary's name, and the address and details will auto link and print the form with your laser printer.
About the Author
Thomas Mendoza
Enthusiastic about teaching cooking techniques through clear, step-by-step guides.
Rate This Guide
How helpful was this guide? Click to rate: