Microsoft Access 2010 Bible

Chapter 6: Working with Datasheet View 233 The Paste command’s down arrow gives you three choices: l Paste: Paste inserts the co ...

Part I: Access Building Blocks 234 You can select your search options in the Find tab and then click the Replace tab to continue ...

Chapter 6: Working with Datasheet View 235 Caution The Default value for this dialog box is Yes. Pressing the Enter key automati ...

Part I: Access Building Blocks 236 FIGURE 6.12 Selecting and dragging a column to change the field order You can select and drag ...

Chapter 6: Working with Datasheet View 237 Changing the field display width You can change the field display width (column width ...

Part I: Access Building Blocks 238 Changing the record display height You might need to increase the row height to accommodate l ...

Chapter 6: Working with Datasheet View 239 Changing display fonts By default, Access displays all data in the datasheet in the C ...

Part I: Access Building Blocks 240 After changing the gridline settings or alternate row colors, Access will ask whether to save ...

Chapter 6: Working with Datasheet View 241 Figure 6.17 shows a datasheet with dots instead of solid lines and a higher contrast ...

Part I: Access Building Blocks 242 Freezing columns When you want to scroll left and right among many columns but want to keep c ...

Chapter 6: Working with Datasheet View 243 FIGURE 6.18 The Sort & Filter group lets you change the record order and narrow t ...

Part I: Access Building Blocks 244 l (^) Contains “Trucks” l Does Not Contain “Trucks” The area to the right of the Navigation b ...

Chapter 6: Working with Datasheet View 245 FIGURE 6.19 Using Filter by Selection. In this case, you see all trucks that are not ...

Part I: Access Building Blocks 246 The check boxes in this menu contain data that appears in the column. In this case, the choic ...

Chapter 6: Working with Datasheet View 247 Cross-Reference Chapters 4 and 5 discuss queries and using operators and expressions. ...

Part I: Access Building Blocks 248 Clicking on a column in the Totals row transforms the datasheet cell to a drop-down list. The ...

Chapter 6: Working with Datasheet View 249 The printout reflects all layout options that are in effect when the datasheet is pri ...

Part I: Access Building Blocks 250 You also customized the fonts, colors, column widths, row heights, and other visual aspects o ...

251 CHAPTER Creating Basic Access Forms IN THIS CHAPTER Creating different types of forms Adding controls to a form Working with ...

Part I: Access Building Blocks 252 Formulating Forms Use the Forms group on the Create tab of the ribbon to add forms to your da ...