Forms

     

  • We can Create forms in 3 ways

    •  

  • Form:

    Creates form with all the fields of table

    •  

  • Form Design:

    design the form as per our requirement

    •  

    Blank Form

     

     

     

    Data Classification - to insert into combobox:

     

    We can Classify the data into 3 ways

  • Select "value list" option if you are inserting manually

    •  

     

    OnLoad Event

     

  • Select the "Row Source Type" as Value List
  • OnLoad Event of form executes the program before the form displays on window

    •  

Hi Everyone,
Welcome to Access Tutorial. In this tutorial i explained:
(i) How to insert the data into Access Database
(ii) how to extract the Data from Aceess Database to Excel
(iii) How to insert the data into Database by using FORMS by using VBA Macros.
This Tutorial provides comprehensive knowledge on the procedure how to connect\interact with Access Database. Hope it enhances your coding skills. If you like this web page kindly Share this to your near and dear. I Prepared this content as per my level of knowledge, if any changes required kindly bring to my notice. Thanks for visiting this web page

Thanks,
Pavan Kumar Gundlapalli