The Ms Access application today is frequently used to run line of business applications which often have complicated data entry and access requirements. While you can design forms to perform such activities, placing too many fields or buttons on a form can clutter the user interface. So when you are looking to create detailed data entry and access forms, opting for tabbed forms would be a better choice. Take the example of a sales form where you include the details of a sale to a client. Instead entering all associated data through a single form, you can create separate tabbed forms to collect remarks, further leads, discount requests etc. Typically first form of a tabbed form would showcase the critical details that need to be filled while other tabs can be created to garner the associated information.
Creating a tabbed form in Ms Access
- Launch the Ms Access application and create a fresh form in the Design view
- Next you need to bring up the property sheet by right clicking on the form
- Find a table with which you which to relate the form and complete the association
- Once table has been linked, head to Form Design tab and hit the Tab Control option
- Next draw the tabbed area on the very top left section of the form detail area
- This will show up two regular tabs which you need to rename
- Just click on the tab title and place the name in Format tab of the Property sheet
- Once the tabbed forms are in place you add fields to them in the normal fashion. However before adding fields, it is important to make the specific tab active by clicking on it.
Advanced Access users can consider formatting the header and footer sections of the tabbed forms to their taste. This can be achieved by heading to the Auto format group option and then choosing a color and font scheme. For example you can tailor the design to correlate with your company’s logo colors.
An Access crash can mess up the intricate tabbed forms that you may have developed
It is not without a reason that Access crashes arising out of MDB errors are taken seriously by most advanced Access users. Not only are you at risk of losing your data, structures like indexes, reports and even tabbed forms can get compromised. Businesses need to always keep a failsafe option in place while using the Access database and this can be achieved by keeping an access repair tool like DataNumen Access Repair handy. Designed to draw out every possible data element from a compromised Access database, the tool has an illustrious record of recovering numerous MDB files with perfection. Moreover even if a MDB file does not show up under normal circumstances, the application can discover it in no time. In case you have encountered a password protected MDB file, the recovery process can still be completed without any hassles.
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