Microsoft Access 2010 Bible

Chapter 5: Using Operators and Expressions in Access 213 FIGURE 5.20 Using multiple Ands and Ors across fields. This is a rather ...

...

215 CHAPTER Working with Datasheet View IN THIS CHAPTER Understanding datasheets Looking at the datasheet window Opening a datas ...

Part I: Access Building Blocks 216 Note Many of the behaviors described in this chapter apply equally to Access forms. Most Acce ...

Chapter 6: Working with Datasheet View ................................................................................... 217 L ...

Part I: Access Building Blocks 218 Moving within a datasheet You easily move within the Datasheet window using the mouse to indi ...

Chapter 6: Working with Datasheet View 219 FIGURE 6.2 The Navigation buttons of a datasheet First New record Previous Last Recor ...

Part I: Access Building Blocks 220 Clipboard The Clipboard group contains the Cut, Copy, and Paste commands. These commands work ...

Chapter 6: Working with Datasheet View 221 Note The controls in the text formatting group behave differently when the currently ...

Part I: Access Building Blocks 222 FIGURE 6.4 An empty datasheet. Notice that the first record is blank and has an asterisk in t ...

Chapter 6: Working with Datasheet View 223 When adding or editing records, you might see three different record pointers: l Reco ...

Part I: Access Building Blocks 224 Now you know how to enter, edit, and save data in a new or existing record. In the next secti ...

Chapter 6: Working with Datasheet View 225 Of course, you can define your own acceptable values in the Format property for the f ...

Part I: Access Building Blocks 226 Number/Currency data entry with data validation The CreditLimit field in tblContacts has a va ...

Chapter 6: Working with Datasheet View 227 FIGURE 6.8 The Zoom window. Notice that you can see a lot more of the field’s data — ...

Part I: Access Building Blocks 228 Tip Watch the scrolltips when you use scroll bars to move to another area of the datasheet. A ...

Chapter 6: Working with Datasheet View 229 The Find and Replace dialog box lets you control many aspects of the search. Enter th ...

Part I: Access Building Blocks 230 Caution Checking Search Fields As Formatted may slow the search process. The search begins wh ...

Chapter 6: Working with Datasheet View 231 Caution Pressing Ctrl+– (minus sign) deletes the current record. Changing an existing ...

Part I: Access Building Blocks 232 Using the Undo Feature The Undo button on the Quick Access toolbar is often dimmed because th ...