Wednesday, June 4, 2014

Design a form filling database using Microsoft access



We all need to fill a form in our day to day work, but it is little bit difficult to fill a form everyday if you are doing a business, or provide a service. If you need to fill a form with same format like bank slips, invoices, TT or PO it is very easy to create a database using MS office. 

Now I will give you the step by step instructions to create a form filling database to fill a bank Telegraph transfer (TT). For this job I used HSBC TT form. This is common form given HSBC in Asian countries.

                                                     


        First take a scan copy of your form and identify how many field you have to fill in the form. In this form there are 21 fields to fill.

2Open the MS access program and create a database given a name.

   
     Now create a database main table called “TT” as below. 

  

      We can give a ref No to identify our TT form. Create other all fields according to manual form.
     
      In this form beneficiary name is common and we can create a separate database for beneficiaries. Once we create a name we not need to type again and again, because we can select it form the database. So create a table call “bank” for Beneficiary name.

     


     

     Create a database form for TT.
     This is the data entry form for main table TT.

    



    




     6). Create database form for beneficiary details.
    







     7). Now you can create a quarry to find a TT you entered.
    





     8). Create a report and insert the scan copy of TT form.
           you can link the scan copy of TT form and set the details you need to fill.


     9) Now select the main table and link the each field to scan copy and save.
        Now you are ready to print the TT form. First enter all the beneficiaries name and after that start to fill the   form. When you enter the form give the ref number continuously as 1,2,3,4 act.

  

     10). you can create database main window as below. Then it will easy to select each option easily.



        After you create the database, open and click Fill TT , enter your ref no / bank/amount and city of bank , just select the beneficiary name , then address and details will auto link and print the form with laser printer.

        you can download my sample file here
       
      if you need to create a like this database i can do it with few dollars.