– Microsoft access 2013 form design tutorial free
Creating forms for your database can make entering data more convenient. When you create a form, you can design it in a way that works with your database and that makes sense to you. In this lesson, you will learn how to create and modify forms. You’ll also learn how to use form options like design controls and form properties to make sure your form works exactly the way you want.
Throughout this tutorial, we will be using a sample database. If you would like to follow along, you’ll need to download our Access sample database. You will need to have Access installed on your computer in order to open the example. Access makes it easy to create a form from any table in your database. Any form you create from a table will let you view the data that’s already in that table and add new data.
Once you’ve created a form, you can modify it by adding additional fields and design controls like combo boxes. If you created a form from a table whose records are linked to another table, your form probably includes a subform.
A subform is a datasheet form that displays linked records in a table-like format. For instance, the subform included in the Customers form we just created displays linked customer orders. We probably don’t need to include this subform because we just want to use the Customers form to enter and review contact information. If you find that you don’t need a subform, you can easily delete it.
To do this, simply click it and press the Delete key on your keyboard. However, subforms are often quite helpful. Depending on the content and source of your form, you might find that the subform contains useful information, like in the example below.
In our Orders form, the subform contains the name, quantity, and price of each item contained in the order, which is all useful information.
When you use the Form command on an existing table, all of the fields from the table are included in the form. However, if you later add additional fields to the table, these fields will not automatically show up in existing forms. In situations like this, you can add additional fields to a form. You can also use the above procedure to add fields to a totally blank form. Simply create a form by clicking the Blank Form command on the Create tab, then follow the above steps to add the desired fields.
Design controls set restrictions on the fields in your forms. This helps you better control how the data is entered into your forms, which in turn helps keep the database consistent. A combo box is a drop-down list you can use in your form in place of a field. Combo boxes limit the information users can enter by forcing them to select only the options you have specified.
Combo boxes are useful for fields that have a limited number of possible valid responses. For instance, you might use a combo box to make sure people only enter a valid U.
If you want to include a drop-down list with a long list of options and don’t want to type all of them out, create a combo box and choose the first option in the Combo Box Wizard, I want to get the values from another table or query. This will allow you to create a drop-down list from a table field. Some users report that Access malfunctions while working with forms.
If you have a problem performing any of these tasks in Layout view, try switching to Design view. The Property Sheet is a pane containing detailed information on your form and each of its components. From the Property Sheet, you can make changes to every part of your form, both in terms of function and appearance. The best way to familiarize yourself with the Property Sheet is to open it and select various options.
When you select an option, Access will display a brief description of the option on the bottom-left border of the program window. Pay close attention as you modify your form and its fields. It’s possible to make subtle changes with the Property Sheet.
Because there are so many options, it can sometimes be difficult to remember which one you used to modify each aspect of your form.
There are far too many options in the Property Sheet to discuss them all in detail. We’ll review two useful ones here: hiding fields, and setting fields with dates to automatically fill in the current date.
Practicing these procedures should also give you a sense of how to work with other Property Sheet settings. Access Creating Forms. Using the Form command to create a form using the Customers table. The new form. Naming and saving the form.
An unnecessary subform in our Customers form. Our Orders form, which includes a useful subform. Clicking the Add Existing Fields command. Selecting a field from the source table. The added field. Clicking the Blank Form command. Selecting a field from another table. Clicking the Combo Box command. Selecting the location of the new combo box. The Combo Box Wizard dialog box. Choosing how many columns to include in the combo box’s drop-down list and typing the options that will appear in that list.
Resizing the column that will appear in the combo box. Selecting the field that will be affected by the combo box—choices made while using the combo box will be recorded in this field. Naming the combo box. Deleting the field that the combo box will replace. Testing the combo box in Form view. A combo box that takes its values from a table.
Selecting a Property Sheet option to find out what it does. Clicking the Property Sheet command. Selecting the field we wish to hide. Selecting “No” from the drop-down list in the Visible option. Selecting the Pickup Date field. Clicking the Expression Builder button for the Default Value option. The Expression Builder dialog box. The Current Date expression.
The current date is automatically entered into the Pickup Date field when a new record is created. Next: Formatting Forms.
Microsoft access 2013 form design tutorial free –
If you are not able to add a field to the form, try selecting a different part of the form and then try adding the field again. Use the tools in the Controls group on the Form Layout Tools tab to add a logo, title, page numbers, or the date and time to the form.
If you want to add a wider variety of controls to the form, click Design and use the tools in the Controls group. A split form gives you two views of the data at the same time — a Form view and a Datasheet view.
Working with split forms gives you the benefits of both types of forms in a single form. For example, you can use the datasheet portion of the form to quickly locate a record, and then use the form portion to view or edit the record. The two views are connected to the same data source and are synchronized with each other at all times.
To create a new split form by using the Split Form tool, in the Navigation Pane, click the table or query that contains the data, and then on the Create tab, click More Forms , and then click Split Form. Access creates the form and you can make design changes to the form. For example, you can adjust the size of the text boxes to fit the data, if necessary.
For more information on working with a split form, see the article on creating a split form. A multiple item form, also known as a continuous form, and is useful if you want a form that displays multiple records but is more customizable than a datasheet, you can use the Multiple Items tool. In the Navigation Pane, click the table or query that contains the data you want to see on your form. Access creates the form and displays it in Layout view. In Layout view, you can make design changes to the form while it is displaying data.
For example, you can adjust the size of the text boxes to fit the data. For more details, see Create a form by using the Multiple Items tool. When you are working with related data that is stored in separate tables, you often need to view data from multiple tables or queries on the same form and subforms are a convenient way to do this.
Since there are several ways of adding a subform depending on your needs, for more information, see the article Create a form that contains a subform a one-to-many form. A navigation form is simply a form that contains a Navigation Control. Navigation forms are a great addition to any database, but creating a navigation form is particularly important if you plan to publish a database to the Web, because the Access Navigation Pane does not display in a browser. On the Create tab, in the Forms group, click Navigation , and then select the style of navigation form that you want.
Access creates the form, adds the Navigation Control to it, and displays the form in Layout view. For more information, see Create a navigation form. There are several options that you can use to customize your forms, see if some the following fit your needs:.
If you want to be able to select which fields appear on the form, use the Form Wizard to create your form. Create a form by using the Form Wizard. Adding tabs to a form can make the form appear more organized and easier to use, especially if the form contains many controls.
Create a tabbed form. A Web Browser Control lets you to display Web pages on a form. You can link the control to fields or controls in your database to dynamically determine which page is displayed.
Add Web browsing to a form. Access places controls in guides called layouts to help you align controls on a form. 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. 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. 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.
– Microsoft access 2013 form design tutorial free
Access video training. Access for Microsoft Access Access Access Access More. Mar 04, · Get a FREE Microsoft Access Introductory Course here In this video tutorial, discover how to . There are a few methods you can use to create forms in Access. For this, open your Database and go to the Create tab. In the Forms group, in the upper right-hand corner you will see the Form Wizard button. Click on that button to launch the Form Wizard.