Use the Form command in the Form group of the Ribbon’s Create tab to create a new form based on a table or query selected in the Navigation Pane. To create a form based on the example tblProducts table you created in the last chapter, follow these steps:

1. Select tblProducts in the Navigation Pane.
2. Click the Create tab on the Ribbon, and then click on the Form command in the Form group.

Access creates a new form containing all the fields from tblProducts displayed in Layout View, shown in Figure 35-2. Layout View lets you see the forms data while changing the layout of controls on the form.

You may notice that Figures showing forms and other objects in this chapter and the next two no longer show the objects in the new tabbed format that is the default in Access 2007. That’s because in some objects, like a form, you might not be able to see the fields completely in a tab rather than a window. The example files that you download for this chapter and the next two have already been set up to use windows rather than tabs for objects.

To change between the tab and window display methods, select Office Button?Access Options. Click Current Database in the list at the left. Under Document Window options (in the Application Options section), click Overlapping Windows to display objects in windows, or Tabbed Documents to show tabs (make sure that Display Document Tabs is also checked). When you click OK, a message box tells you that you must close and reopen the database for the change to take effect. Click OK. Select Office Button?Close Database to close the file, and then reopen it. Also note that depending on
the screen resolution that you’re using, some fields may appear cut off, even in a window. You can change your screen resolution or resize the Navigation Pane as needed to show more information in the windows in Access, as needed.

FIGURE 35-2
Creating a new form. Use the Form command to quickly create a new form with all the fields from a table or query.

• Download Flash Video from Any Website Do you want to download a flash video? Are you having trouble finding a good program or plugin to rip...
• California Coastal Access Guide User Reviews Send this to a friend California Coastal Access Guide Manufacturer: Customer Rating: List Price: Varies based on product...
• 50 really useful Android tips and tricks [/caption] Android is a great little mobile operating system for the modern smartphone, but it can feel a little bewildering...
• Create your own backlinks As I mentioned in my Why are backlinks important? post, I'm about to share a way to create your own...
• Ipod Video Photo Help with Movie Play Now that you have purchased an older Ipod, you may wonder how to watch your movies, download your movies, or...