Software

Let Access 2007 create a form from the active table

Access 2007 makes form creation easier than ever. Here's how to make a form from any table you open.

Access 2007 provides a quick way to create a form. Follow these steps:

1. In the Navigation pane (at the left of the database), double-click the table that contains the fields for your form.

2. Click the Create tab.

3. In the Forms section, click the Form command.

4. Right-click the tab of the new form.

5. Click Save and enter a new name for the form.

6. Click OK.

You are not limited to creating single-record forms with this method. You can also create a form that shows multiple records in a datasheet format by clicking the Multiple Items Form command in step 3. You can also choose the Split Form command to create a form that includes a datasheet in the lower section and a single-record form in the upper section for entering information about a record selected in the datasheet below.

Miss a tip?

Check out the Microsoft Access archive, and catch up on our most recent Access tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

3 comments
ollney.hoopai
ollney.hoopai

Sorry but this didn't work for me. On step 2 there was no Create tab. All I wanted was the wizard button to create a new form.

bkamhi
bkamhi

Just to let you all know, I really hate the new blog format for these tips and the fact that I can't get them in Print Format (I can only print them). It's a shame you had to ruin a good thing.

50THZ
50THZ

**************

Editor's Picks