The Ms Access database is known for its overall ease of use. You can create tables and queries in it through the Wizard functionality with minimum effort. Similarly the Form Wizard can be used to create forms in quick time. However the Wizard has certain limitations and at certain point of time you may wish to design forms manually. Especially when you are looking to create custom forms or nested sub-forms; using the design view is a more apt choice. Let’s look at how you can quickly create forms in the design view.
Working with the Form Design View in Ms Access
- Launch the Ms Access application and head to the Form tab on the left pane
- Next click on the option Create Form in Design View
- You would find a blank design view screen coming into the picture
- Next you need to right click and choose properties from the drop down list
- A property sheet panel would come up in the right pane
- Of the tabs present in the property sheet, you need to head to Data tab
- Next you need to choose the table from where you wish to add fields to the form. This can be achieved by using the Add existing field option
- From the list of fields that come up in the picture, choose the one you wish to include and drag it to the preferred location on the form. Repeat the process for as many fields you wish to include.
- Next you need to modify the label tag and associated elements for each field.
- Once you have completed the form design, save the changes.
With the design view you can add controls of your choice, make segmented placements, and add validation rules with ease. Moreover it also has a host of associated options that can be set. At any point if you have a query with respect to a specific property you can always use the Help menu to gain further information.
All data in an Ms Access Database can get compromised in case of an MDB corruption issue
Most advanced Access users are aware of the fact that any corruption in the MDB file can lead to potential data loss. This includes all data from forms and records to indexes and saved queries. Now if you are looking avoid a scenario where your valuable data goes up for a toss, installing an access repair tool like DataNumen Access Repair would be the ideal choice. As opposed to run of the mill recovery applications that can only retrieve few data elements, this versatile application can get back all your data including OLE fields and indexes with ease. Moreover if you are unable to locate a compromised MDB file, the tool can do that for you with ease. It also has the capacity to tackle ACCDB format files and is not constrained by the storage media type where the files are located.
Alan Chen is President & Chairman of DataNumen, Inc., which is the world leader in data recovery technologies, including access repair and sql recovery software products. For more information visit www.datanumen.com