Create a form by using the Form tool

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
is entitled to one free licence for MS Access Connolly, Begg: Database Systems A Practical Approach to Design, Implementation and. Access Forms are customisable design objects allowing you to provide Whilst we are here, feel free to drag and drop form fields to suit. Forms Design Properties in MS Access. The Forms Design view provides a way to alter all of the properties of form canvas and fields.
 
 

Microsoft access 2013 form design free.31+ Microsoft Access Templates

It should mirror the screenshot below. Press OK to import to our new database. Double-click to open member. Access Forms are customisable design objects allowing you to provide an accessible database experience for yourself and your database users.

A well designed form can aide efficiency and improve data entry accuracy, so it is worth learning the essentials like tables to save yourself time, editing costly errors.

Let’s move onto the fun bits. Our database is full. Our fingers are nimble. Select the Create tab followed by Form. Outlook will default to a basic form for our selected table, displayed in the aptly named layout view. You have created a very basic, visually unappealing form — but this forms the basis of our customisable database interface. Whilst we are here, feel free to drag and drop form fields to suit your database, or right-click for deletion options.

It is also worth taking note of the range of design options available in the Form Layout Tools context tab. This is where the design power tools are kept, ranging from:. Some of these outrageously exciting tools will come into play in a moment.

First, lets play around with the formatting of our Senators Contact Information Form. Our Form Layout Tools tab contains the form customisation fields. Selecting it will deliver you to a similar screen to ours. At this point, feel free to play around with some of the settings to understand their role in form design and the aesthetic options available to you.

You may also want an Ainsley Harriot background with green fill, bold italic underlined green text and green outlines. If that isn’t the visually appealing, engaging design you were interested in, you could choose some sensible options, too.

Head back up to the Home tab where you can find the view option. Here you can cycle through the available Form views. Congratulations, you have just made your first customised Access Form. Your database users will rush to thank you! Microsoft have been exceptionally kind in their Office release. Understanding our societal desires to continually improve efficiency, they have included a rather handy Form Wizard to enable the skipping of the grubby, hands-on detail.

The Access Form Wizard is a useful, rapid form development tool that puts you in the driving seat for design, whilst speeding you through the nomenclature, providing you with presets for columns, rows, table sizes, styles and themes. You can use the wizard to quickly decide which form style suits your database and user requirements.

Of course you might not always need to import a database and set up a basic form. There are several other form formats, depending on your data, as well as design controls to aid user navigation. Let’s examine some of these now. One of these four form formats will be found in almost every Access database form you encounter, so take some time to familiarise yourself with their appearance, strengths, weaknesses and where they should be applied.

It contains reams of useful information about your Form and you can use it to quickly edit, modify and toggle numerous options. Not sure what an option does? Access provides a handy tooltip in the bottom left of your screen. Access and later versions create the form first and then apply themes later on.

To change the theme of the current form, click on the Home tab on the ribbon bar, then click on the View menu and finally Design View. This will change the display of the current form to the Design View as shown below:.

With the Forms Design View activated, the ribbon bar adds three new entries at the top under the heading Forms Design Tools :. To change the theme of the form, click on the Design tab on the ribbon bar and pull down the Theme menu. In a similar fashion the color scheme of the form can be changed using the Colors menu and the font used for the labels and text boxes can be set using the fonts menu.

For this exercise, we will create a data entry form for the Accounts table. Select the Accounts table and all of the available fields and click on the Next button. Choose a Tabular layout and click on the Next button. For Access only choose the Office style and click on the Next button. Name the form: AccountsDataEntry Then click on the Finish button to create, save and view the new form.

Note that if you had already created this form during the prior tutorial, you will be asked to over-write the form with this new one. The new form is shown in the figure below: 2. This will change the display of the current form to the Design View as shown below: With the Forms Design View activated, the ribbon bar adds three new entries at the top under the heading Forms Design Tools : Design — Change colors and themes. Add buttons, fields, labels and other objects to the form.

A Quick Tutorial On Forms In Microsoft Access

Select the Accounts table and all of the available fields and click on the Next button. Choose a Tabular layout and click on the Next button. For Access only choose the Office style and click on the Next button.

Name the form: AccountsDataEntry Then click on the Finish button to create, save and view the new form. Note that if you had already created this form during the prior tutorial, you will be asked to over-write the form with this new one. The new form is shown in the figure below: 2. This will change the display of the current form to the Design View as shown below: With the Forms Design View activated, the ribbon bar adds three new entries at the top under the heading Forms Design Tools : Design — Change colors and themes.

Tip: Use a message in the On failure box to tell users what to do if they cannot submit their form. For example, you can suggest that users save their form and contact someone for further instructions.

If you do not want to display a message after the user submits a form, clear the Show success and failure messages check box. InfoPath InfoPath More Need more help? Expand your skills. Get new features first. Was this information helpful? Yes No. Thank you! Any more feedback? The more you tell us the more we can help. Can you help us improve?

Resolved my issue. Clear instructions. Easy to follow. No jargon. Pictures helped. Didn’t match my screen. Incorrect instructions. Too technical. Not enough information. Not enough pictures. Any additional feedback?

Find out how to move and size controls independently. Move and resize controls independently. Forms and reports. Need more help? Expand your skills. Get new features first. Was this information helpful? Yes No. Thank you! Any more feedback? The more you tell us the more we can help. Can you help us improve? Resolved my issue.

Clear instructions. Easy to follow. No jargon. Pictures helped. Didn’t match my screen. Incorrect instructions. Access provides a handy tooltip in the bottom left of your screen.

We cannot stress how useful the properties sheet can be for making changes on the fly. However, the options are too numerous to detail each one, so we’ll cover two you might require immediately:. Want to ensure your users don’t access a certain field? Access allows you to hide individual field entries. Select the field you want to hide. We’ve chosen party , from our existing database form.

When you select the field, the properties sheet should update and you’ll be able to toggle field visibility through a drop-down box. Your database may well need to be accessed by other users — but you don’t want them to meddle with the finely tuned inner-workings of your tables and queries, and especially not any of your VBA code. Head back to the properties sheet. Scroll through the pictured drop-box to find Form — the properties we’ll be editing will apply to the entire form, as opposed to the single field isolation we covered above.

Next, switch to design view and in the properties sheet drop-down box, find Form once again. Toggle Allow Layout View to no. This stops any additional users accessing the layout view, where they could directly edit the Form. We’ve made our Form, we’ve meddled with formatting, we’ve played with properties and we’ve restricted editorial access. Now we need to save our Form for distribution.

Before distributing our database, we need to convert the file from. Save the current database to a memorable location.