Microsoft Access 2010 Bible
Chapter 4: Selecting Data with Queries 153 Printing a Query’s Recordset After you create your query, you can easily print all th ...
Part I: Access Building Blocks 154 After you create the tables for your database and decide how the tables are related to one an ...
Chapter 4: Selecting Data with Queries 155 Selecting a field from the drop-down list in the field cell first adds the table’s na ...
Part I: Access Building Blocks 156 FIGURE 4.24 The Datasheet view of data from multiple tables Adding multiple fields The proces ...
Chapter 4: Selecting Data with Queries 157 In Access, the records in your tables might not always be updateable. Table 4.1 shows ...
Part I: Access Building Blocks 158 Updating a unique index (primary key) If a query uses two tables involved in a one-to-many re ...
Chapter 4: Selecting Data with Queries 159 If referential integrity is set on the relationship, Access uses a somewhat thicker l ...
Part I: Access Building Blocks 160 Caution When you remove a table from a query design, join lines to that table are deleted as ...
Chapter 4: Selecting Data with Queries 161 If relationships are set in the relationship builder, you might not see the auto-join ...
Part I: Access Building Blocks 162 FIGURE 4.25 An ad hoc join between tblProducts and tblCategories Auto-join Ad-hoc join Specif ...
Chapter 4: Selecting Data with Queries 163 The problem in Figure 4.26 is that you can’t even tell records are missing. The only ...
Part I: Access Building Blocks 164 FIGURE 4.28 A right outer join corrects the “missing products” problem in Figure 4.27. The lo ...
Chapter 4: Selecting Data with Queries 165 Understanding Table Join Types In Chapter 3, you learned about table relationships an ...
Part I: Access Building Blocks 166 It’s possible to have a buyer in tblCustomers who has no sales. With referential integrity co ...
Chapter 4: Selecting Data with Queries 167 FIGURE 4.29 A datasheet with a right outer join. It shows all customers, including th ...
Part I: Access Building Blocks 168 FIGURE 4.30 A query with a self join involving the Employees table Notice in Figure 4.30 that ...
Chapter 4: Selecting Data with Queries 169 True self-joins are relatively rare in most databases. But, it’s good to know that Ac ...
Part I: Access Building Blocks 170 FIGURE 4.33 A Cartesian product recordset In virtually every instance, the data returned by a ...
171 CHAPTER Using Operators and Expressions in Access IN THIS CHAPTER Understanding operators in expressions Creating complex qu ...
Part I: Access Building Blocks 172 Note You’ll see the term evaluate a lot in this chapter. When you present Access with a field ...
«
6
7
8
9
10
11
12
13
14
15
»
Free download pdf