Use Application Parts to quickly build tables and forms in Access

Application Parts are a quick way to partially, or completely, build specific tables and forms for your database. Using the Contacts template as an example, once used, this Application Part will create tables, queries, forms and reports. This preset functionality is useful, especially if you are not sure where to start. Even though the Application Part creates all these pieces, you are still able to add anything that you need for your database. Starting off this way might also give you some additional ideas that you did not think of originally.

In order to use this feature, click the Create tab, then click the dropdown for Application Parts (located on the left side of the ribbon). There are a number of templates to choose from, or if you are just looking for a form template, there are a number of these available, as well. Once created, you can alter any of the created items.

Before creating an Application Part, ensure all tabs are closed, or an error message will pop-up asking if you want to close all open objects. In order to populate the template, you will need to click “Yes” on the dialog box.

To check out all the objects that were created using this functionality, ensure that All Access Objects is selected in the navigation pane, typically located on the left. These objects can then be changed by clicking the drop-down arrow in the top right-hand corner of the navigation pane.

Empower your databases with an Access Training course from MCT in either Denver or Phoenix.