![]() In the Navigation Pane, click the table or query that contains the data that you want on your form. To create a split form by using the Split Form tool: 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. Working with split forms gives you the benefits of both kinds of forms in a single form. ![]() You can add, edit, or delete data from either part (as long as the record source is updatable, and you have not configured the form to prevent these actions). Selecting a field in one part of the form selects the same field in the other part of the form. Create a split form by using the Split Form toolĪ split form gives you two views of the data at the same time - a Form view and a Datasheet view.Ī split form differs from a form/subform combination in that the two views are connected to the same data source and are synchronized with one another at all times. If there is more than one table with a one-to-many relationship to the table that you used to create the form, Access does not add any datasheets to the form. ![]() You can delete the datasheet from the form if you decide you do not need it. For example, if you create a simple form that is based on the Employees table, and there is a one-to-many relationship that is defined between the Employees table and Orders table, the datasheet displays all the records in the Orders table that relate to the current Employee record. If Access finds a single table that has a one-to-many relationship with the table or query that you used to create the form, Access adds a datasheet to the form that is based on the related table or query. For example, you can adjust the size of the text boxes to fit the data, if necessary. In Layout view, you can make design changes to the form while it is displaying data. On the Create tab, in the Forms group, click Form.Īccess creates the form and displays it in Layout view. In the Navigation Pane, click the table or query that contains the data you want to see on your form. You can start using the new form immediately, or you can modify it in Layout view or Design view to better suit your needs. When you use this tool, all the fields from the underlying data source are placed on the form. You can use the Form tool to create a form with a single mouse-click. In this articleĬreate a split form by using the Split Form toolĬreate a form that displays multiple records by using the Multiple Items toolĬreate a form by using the Blank Form tool Note: This article assumes you have already created a table (or a query based on one or more tables), and that you want to build a form to view or manipulate the data. A visually attractive form makes working with the database more pleasant and more efficient, and it can also help prevent incorrect data from being entered. An effective form speeds the use of your database, because people don't have to search for what they need. Think of bound forms as windows through which people see and reach your database. You can also add command buttons and other features to a form to automate frequently performed actions. Providing those users with a form that contains only those fields makes it easier for them to use the database. For example, certain users might need to see only several fields in a table with many fields. ![]() You can use bound forms to control access to data, such as which fields or rows of data are displayed. This article focuses primarily on bound forms. Alternatively, you can create an "unbound" form that does not link directly to a data source, but which still contains command buttons, labels, or other controls that you need to operate your application. A "bound" form is one that is directly connected to a data source such as a table or query, and can be used to enter, edit, or display data from that data source. ![]() A form in Access is a database object that you can use to create a user interface for a database application. ![]()
0 Comments
Leave a Reply. |