How to Create a Multi-Page Form Base in a Microsoft Access Database

One benefit of Access databases is that are easy to append and expand. Because of this, though, they can contain overwhelming amounts of information. One way to make necessary data easier to find is by using a multi-page form. Begin by dividing the data into logical categories. Then you can use the Access tab control feature to create a form with multiple, tabbed pages that simplify finding the information you and others using the database need.

Things You'll Need

• Access 2003, 2007 or 2010

Instructions

1. Click "Forms" under "Objects" in the main database window. Click "New" and select "Design View" in the "New Form" dialog box. Click "OK." A new, blank form will open in design view.

2. Click the "Toolbox" button on the toolbar in Access 2003. The "Toolbox," which is a floating toolbar, will open.

3. Click the "Control Tab" button on the "Toolbox" in Access 2003. This button resembles a file folder. In Access 2007 or 2010, go to the "Design" tab and click the "Control Tab" button in the "Controls" group.

4. Click on the form where you want to place the tab. Double-click the tab to open the "Properties" box. Enter a name for the tab that describes the data that will be on that page.

5. Drag the fields onto the first page where you want to place them. Go to the second page and drag the appropriate fields to this page. Add more pages by right-clicking the tab and selecting "Insert Page." Save the changes to your form base before closing Access.

References

• Access 2003: Add a tab or page break control to a form
• Access 2007: Create a tabbed form