Microsoft Access 2010 Bible

Chapter 2: Creating Access Tables 73 FIGURE 2.21 The Table Design View area on the Options screen contains options for setting t ...

Part I: Access Building Blocks 74 FIGURE 2.22 The property area for the Currency field named CreditLimit Pressing F6 switches be ...

Chapter 2: Creating Access Tables 75 FIGURE 2.23 The Lookup tab for a Yes/No field FIGURE 2.24 Setting up a combo box as the dis ...

Part I: Access Building Blocks 76 FIGURE 2.25 Using a combo box as a lookup control to restrict user input on a field Setting th ...

Chapter 2: Creating Access Tables 77 Good primary keys l Uniquely identify each record. l (^) Cannot be null. l Must exist when ...

Part I: Access Building Blocks 78 Creating composite primary keys You can designate a combination of fields to be used as a tabl ...

Chapter 2: Creating Access Tables 79 are in chronological order, which is not necessarily helpful when preparing reports detaili ...

Part I: Access Building Blocks 80 The importance of indexes Microsoft’s data indicates that more than half of all tables in Acce ...

Chapter 2: Creating Access Tables 81 current table. Without an index, Access has to search all records in the related table to m ...

Part I: Access Building Blocks 82 FIGURE 2.29 It’s easy to set the properties of an index. Selected index Index properties The i ...

Chapter 2: Creating Access Tables 83 A field can be both the primary key for a table and part of a composite index. You should i ...

Part I: Access Building Blocks 84 Note A compact and repair cycle on an Access database forces Access to rebuild the indexes in ...

Chapter 2: Creating Access Tables 85 FIGURE 2.31 Printing options in the Print Table Definition dialog box Tip The Database Docu ...

Part I: Access Building Blocks 86 l (^) Copying tables in a database l Copying a table to another database You perform these tas ...

Chapter 2: Creating Access Tables 87 l (^) Append Data to Existing Table: Clicking the Append Data to Existing Table but- ton ad ...

Part I: Access Building Blocks 88 Open the other Access database and choose Edit Paste from the shortcut menu, or click the Cop ...

Chapter 2: Creating Access Tables 89 to handle many different types of data, until recently there was no way to accommodate comp ...

Part I: Access Building Blocks 90 Summary This chapter has covered the important topics of creating new Access databases and add ...

91 CHAPTER Designing Bulletproof Databases IN THIS CHAPTER Understanding bulletproof database design Normalizing database data L ...

Part I: Access Building Blocks 92 payroll tables first, connecting these tables with a relationship to make it easy to find all ...