In the Form view, the Ribbon (shown in Figure 35-23) provides commands for working with the data. The Home tab has some familiar objects on it, as well as some new ones. This section provides an overview of the Home tab in the Form view;

FIGURE 35-23
The Ribbon’s Home tab in Form view.

The first group is the View group, which allows you to switch between Form View, Datasheet View, PivotTable View, PivotChart View, Layout View, and Design View. You can see all six choices by clicking the command’s down-arrow. Clicking Form View lets you manipulate data on the form.

Datasheet View shows the data in a row-and-column format. Design View permits you to make changes to the form’s design. Layout View lets you change the form’s design while viewing data. PivotTable View and PivotChart View let you create PivotTables and PivotCharts based on the form’s data. All these commands may not be available on all forms. By setting the form’s properties, you can limit which views are available. You’ll learn more about form properties later in this chapter.

The Clipboard group contains the Cut, Copy, and Paste commands. These commands work like the commands in other applications (Word, Excel, and so on). The Paste command’s down arrow gives you three choices: Paste, Paste Special, and Paste Append. Paste Special gives you the option of pasting the contents of the Clipboard in different formats (Text, CSV, Records, etc.) Paste Append pastes the contents of the Clipboard as a new record—provided a record with a similar structure was copied.

The Font group lets you change the look of the datasheet in Datasheet View. Use these commands to change the font, size, bold, italic, color, and so on. Use the Align Left, Align Right, and Align Center commands to justify the data in the selected column. Click the Gridlines command to toggle gridlines on and off. Use the Alternate Fill/Back Color command to change the colors of alternating rows, or make them all the same.

When modifying text in a memo field with the Text Format property set to Rich Text, you can use these commands to change the fonts, colors, and so on. The Rich Text group lets you change a memo field’s data if the field’s Text Format property is set to Rich Text. Use these commands to add bullets or numbered lists and change the indentation levels.

The Records group lets you save, delete, or add a new record to the form. It also contains commands to show totals, check spelling, freeze and hide columns, and change the row height and cell width in Datasheet View.

The Sort & Filter group lets you change the order of the records, as well as limit the records being displayed— based on criteria you want. The Find group lets you find and replace data and go to specific records in the datasheet. Use the select command to select a record or all records.

• Top Best 100 Incredibly Useful & Free Mac Apps [/caption] Everyone loves free applications. One of the greatest things about Macs is the wealth of extremely talented developers that...
• Foghorn Outdoors California Camping: The Complete Guide to More Than 1,500 Tent and RV Campgrounds User Reviews Send this to a friend Foghorn Outdoors California Camping: The Complete Guide to More Than 1,500 Tent and...
• Top 40 best free iPod touch apps 2010 - Updated [/caption] Still scouting for some great apps to install on your new iPod Touch? Here are 40 of the best....
• Review - Nikon D5000 Digital SLR [/caption] Nikon Inc. introduced the new D5000, a digital SLR camera with a host of features and capabilities that deliver...
• Optimize your layouts Writing user interface layouts for Android applications is easy, but it can sometimes be difficult to optimize them. Most often,...