Microsoft Access 2010 Bible

Chapter 2: Creating Access Tables 33 FIGURE 2.6 Opening an obsolete Access data file invokes the Database Enhancement dialog box ...

Part I: Access Building Blocks 34 FIGURE 2.7 Choosing an alternate display for the Navigation Pane Here are the navigation optio ...

Chapter 2: Creating Access Tables 35 Figure 2.8 shows how the Tables and Related Views works. The Categories group has been expa ...

Part I: Access Building Blocks 36 Tip The Filter By Group option is really only helpful when you have a fairly large number of o ...

Chapter 2: Creating Access Tables 37 Instead of explaining each of the groups and controls within groups on the ribbon, I’ll int ...

Part I: Access Building Blocks 38 Microsoft has added a tabbed document interface to Access, preventing objects from obscuring o ...

Chapter 2: Creating Access Tables 39 Creating a New Table Creating database tables is as much art as it is science. Acquiring a ...

Part I: Access Building Blocks 40 Designing tables Designing a table is a multistep process. By following the steps in order, yo ...

Chapter 2: Creating Access Tables 41 Create the new table. Enter field names, data types, properties, and (optionally) descript ...

Part I: Access Building Blocks 42 FIGURE 2.12 The Create tab contains tools necessary for adding new objects to your Access data ...

Chapter 2: Creating Access Tables 43 The Click to Add column is intended to permit users to quickly add tables to an Access data ...

Part I: Access Building Blocks 44 FIGURE 2.15 A new table added in Design view Field Name Data Type Field Properties For this ex ...

Chapter 2: Creating Access Tables 45 Field Name Data Type Description OrigCustDate DateTime Date the contact first purchased som ...

Part I: Access Building Blocks 46 FIGURE 2.16 The Design tab of the ribbon The controls in the Design tab affect the import tabl ...

Chapter 2: Creating Access Tables 47 FIGURE 2.17 The Property Sheet Indexes Indexes are discussed in much more detail in the “In ...

Part I: Access Building Blocks 48 To enter a field name, position the pointer in the first row of the Table Design window under ...

Chapter 2: Creating Access Tables 49 l (^) OLE Object: Pictures, graphs, sound, video, word processing, and spreadsheet files l ...

Part I: Access Building Blocks 50 Figure 2.18 shows the Data Type drop-down list used to select the data type for the field you ...

Chapter 2: Creating Access Tables 51 l (^) Consider the impact of data type on sorting requirements. Numeric data sort differ- e ...

Part I: Access Building Blocks 52 Memo data type The Memo data type holds a variable amount of data from 0 to 65,536 characters ...