Microsoft Office Tutorials and References
In Depth Information
Book III: Queries (Or Getting Information from Your Data)
Contents at a Glance
Contents at a Glance
Chapter 1: Creating Select Queries.............................189
Understanding Types of Queries ............................................................... 190
Creating a Query in Design View ............................................................... 191
Creating a Query with the Simple Query Wizard ..................................... 194
Viewing Your Query .................................................................................... 197
Using Query Design View ............................................................................ 198
Taking Tips on Creating a Query ............................................................... 202
Editing a Query ............................................................................................ 204
Limiting Records with Criteria Expressions ............................................ 207
Working with Multiple Related Tables ...................................................... 213
Working with Query Datasheets ................................................................ 217
Saving Queries ............................................................................................. 219
Chapter 2: Letting Queries Do the Math .........................221
Doing Calculations in Queries .................................................................... 221
Writing Expressions in Access ................................................................... 224
Using Expression Builder ........................................................................... 228
Going beyond Basic Arithmetic ................................................................. 232
Performing Date and Time Calculations ................................................... 238
Manipulating Text with Expressions ......................................................... 242
Writing Decision-Making Expressions ....................................................... 243
Testing for Empty Fields ............................................................................. 248
Sorting by Name or Company .................................................................... 248
Creating Flexible Parameter Queries ........................................................ 249
Working with Totals, Subtotals, Averages, and Such ............................. 252
Chapter 3: Doing Neat Things with Action Queries
and Query Wizards ...........................................255
Creating Action Queries .............................................................................. 255
Changing Data with Update Queries ......................................................... 258
Creating New Tables with Make-Table Queries ....................................... 262
Moving Data from One Table to Another with Append Queries ........... 265
Deleting Lots of Records with Delete Queries ......................................... 267
Finding Unmatched Records with a Wizard ............................................. 270
Finding Duplicate Records ......................................................................... 272
Chapter 4: Viewing Your Data from All Angles Using Crosstabs ...277
Aggregating Data in a Crosstab Query ...................................................... 277
Using the Crosstab Query Wizard ............................................................. 278
Creating a Crosstab Query in Design View ............................................... 282
Modifying a Crosstab Query ...................................................................... 284
 
Search JabSto ::




Custom Search