16 September 2011

Create a Form Using Form Wizard



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.

How to create form using Form Wizard in MS Access

To create a form using Form Wizard, do the following steps:
  1. Highlight the table tblMainAccount
  2. Click Create tab, choose More Form on the Forms Group, and click Form Wizard.


    Click button to add all the Available Fields to Selected Fields. Click next button to continue.
  3. Choose option Columnar and click next to continue


  4. Choose Access 2007 and click next to continue. You may choose another style you would like, later.


  5. Type frmMainAccount as the form name, choose option Modify the form's design, and click Finish button  to edit the design.


  6. Form frmMainAccount has been created. The design will look like this:


  7. Highlight frmMainAccount label and double click to rename the title into Chart of Account - Main Account just like this:


  8. Highlight + symbol on the top left corner just like in the picture below:


    Inside the highlighted area, click right mouse to display the shortcut menu and choose Layout - Remove to remove the group layout to make individual layout. You may adjust the field width by dragging the border as per you like.

  9. If you click Views - Form View, finally, the form frmMainAccount will look like this:


  10. To save the format of the current form, so that you can apply this format to other forms, do the following steps:
    1. Switch the form to Layout View, click Format tab, 
    2. Choose more on the AutoFormat group, and click AutoFormat Wizard ... to Manage Auto Formats. 
    3. Click customize... button and 
    4. Choose Create a new AutoFormat based on the Form 'frmMainAccount'. 
    5. Type 'AutoFormat1' in the Style Name,  clik OK to confirm. 
    6. Click OK to finish. Your AutiFormat1 is ready to format other forms.


1 comment :