Microsoft Access 2010 Bible

Chapter 3: Designing Bulletproof Databases 113 Orphaned records are very bad in database applications. Because sales information ...

Part I: Access Building Blocks 114 All foreign key values must be matched by corresponding primary keys The second referential i ...

Chapter 3: Designing Bulletproof Databases 115 Uniquely identifying each record in a table is precisely what a primary key field ...

Part I: Access Building Blocks 116 However, there is no reason why the primary key value has to be meaningful to the application ...

Chapter 3: Designing Bulletproof Databases 117 The benefits of a primary key Have you ever placed an order with a company for th ...

Part I: Access Building Blocks 118 Designating a primary key From the preceding sections, you’re aware that choosing a table’s p ...

Chapter 3: Designing Bulletproof Databases 119 However, there are many situations where no “perfect” natural key exists in datab ...

Part I: Access Building Blocks 120 Select Database Tools ➪ Relationships. The Relationships window appears. Click on the Show ...

Chapter 3: Designing Bulletproof Databases 121 FIGURE 3.15 You enforce referential integrity in the Edit Relationships dialog bo ...

Part I: Access Building Blocks 122 Specifying the Join Type between tables The right side of the Edit Relations window has four ...

Chapter 3: Designing Bulletproof Databases 123 FIGURE 3.17 The Join Properties dialog box, used to set up the join properties be ...

Part I: Access Building Blocks 124 Note You might find, when you select Enforce Referential Integrity and click the Create butto ...

Chapter 3: Designing Bulletproof Databases 125 Generally speaking, however, there are very few reasons why the value of a primar ...

Part I: Access Building Blocks 126 “hide” a relationship by deleting the tables you see in the Relationships window. Click on a ...

Chapter 3: Designing Bulletproof Databases 127 Most often, these rules are added to a table at design time. Enforcing such rules ...

Part I: Access Building Blocks 128 soon see, building queries in Microsoft Access is about much more than simply asking the data ...

129 CHAPTER Selecting Data with Queries IN THIS CHAPTER Understanding what queries are and what they can do for you Creating que ...

Part I: Access Building Blocks 130 the query’s data is used. In many cases it makes more sense to include logic such as transfor ...

Chapter 4: Selecting Data with Queries ....................................................................................... 1 ...

Part I: Access Building Blocks 132 FIGURE 4.2 The results of the query shown in Figure 4.1 In this case, you want Access to show ...