Designing Reports from Scratch .................................................................75
Understanding the report bands .......................................................76
Setting up the report page .................................................................78
Choosing your tables ..........................................................................82
Selecting the fields ..............................................................................83
Modifying Report Layouts ...........................................................................84
Deciding what needs to be done .......................................................84
Moving and formatting those pesky labels ......................................85
Pulling the layout together to save paper ........................................87
Adding Data from External Linked Tables ..................................................88
Choosing a method for accessing external data .............................89
Importing or linking external data ....................................................90
Part II: Creating Effective Queries ................................93
Chapter 5: Creating Multi-Table Queries . . . . . . . . . . . . . . . . . . . . . . . .95
Understanding Multi-Table Queries ............................................................95
Understanding the benefits of multiple tables ................................96
Establishing relationships between multiple tables .......................97
Adding Multiple Tables to Queries .............................................................98
Selecting multiple tables upfront ......................................................98
Adding the tables you forgot about to your query .......................100
Choosing the fields to use ................................................................101
Making Access use the correct table ..............................................102
Linking to External Databases in Your Queries .......................................103
Understanding the types of external data you can use ................103
Linking to tables in another foreign database format ..................104
Knowing what you can and can’t do with a linked
external database ..........................................................................106
Understanding Relationships in Queries .................................................106
Getting to know how tables are related ..........................................107
Making sure that you choose the right relationships ...................108
Setting up table relationships ..........................................................108
Chapter 6: Modifying Data with Queries . . . . . . . . . . . . . . . . . . . . . . .113
Understanding What You Can Modify with a Query ...............................113
Knowing what you can modify ........................................................114
Knowing what you can’t modify ......................................................115
Being Called to Action: Data-Modifying Queries .....................................115
Creating New Tables with Queries ............................................................117
Why you would want to create new tables ....................................117
Creating your first table with a make-table query ........................118
Updating Data by Using Queries ...............................................................121
Creating an update query example .................................................121
Understanding the update query results .......................................124
ix
Table of Contents
02_599658 ftoc.qxd 8/31/05 12:38 PM Page ix
|
|