microsoft access 2013 tutorial 7 case 1 guide

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. Note: The order of the tables in the Field List pane can change, depending on which part of the form is currently selected.

To add several fields at once, hold down CTRL and click several fields, and then drag them onto the form at the same time. To add a field to the form, double-click it or drag it onto the form. In the Field List pane, click the plus sign ( +) next to the table or tables that contain the fields that you want to see on the form. Access opens a blank form in Layout view, and displays the Field List pane. To create a form with no controls or preformatted elements: On the Create tab, click Blank Form. For more information, see the article on using the form tool.

You can make design changes like adjusting the size of the text boxes to fit the data, if necessary. Īccess creates a form and displays it in Layout view. To create a form from a table or query in your database, in the Navigation Pane, click the table or query that contains the data for your form, and on the Create tab, click Form. What do you want to do?Ĭreate a form from an existing table or query in AccessĬreate a form that displays multiple records in AccessĬreate a form that contains a subform in Access Note: The information in this article does not apply to Access web databases or Access web apps.

Microsoft access 2013 tutorial 7 case 1 guide