Microsoft Access 2010 Bible

xxii

Contents

Specifying criteria for a total query ..........................................................................662

Creating expressions for totals .................................................................................664

Creating Crosstab Queries .................................................................................................666

Understanding the crosstab query ...........................................................................666

Creating the crosstab query .....................................................................................667

Understanding Action Queries ..........................................................................................671

Types of action queries ............................................................................................671

Creating action queries ............................................................................................671

Troubleshooting action queries ...............................................................................676

Summary ..........................................................................................................................677

Chapter 19: Advanced Access Form Techniques  . . . . . . . . . . . . . . . . . . 679

Setting Control Properties .................................................................................................679

Customizing default properties ...............................................................................681

Manipulating controls at runtime ............................................................................682

Reading control properties ......................................................................................685

Working with Subforms ....................................................................................................686

Designing Forms ...............................................................................................................688

Using the Tab Stop property ...................................................................................688

Tallying check boxes ...............................................................................................688

Adding animation ...................................................................................................688

Using SQL for a faster refresh ..................................................................................690

Selecting data for overtyping ...................................................................................690

Toggling properties with Not ..................................................................................690

Creating an auto-closing form .................................................................................691

Setting up combo boxes and list boxes ....................................................................691

Determining whether a form is open .......................................................................693

Tackling Advanced Forms Techniques ..............................................................................694

Using the Page Number and Date/Time controls .....................................................694

Using the Image control ..........................................................................................695

Morphing a control .................................................................................................695

Using the Format Painter.........................................................................................696

Offering more end-user help ...................................................................................697

Adding background pictures ...................................................................................697

Fine-tuning your form’s behavior with form events .................................................699

Using the Tab Control .......................................................................................................700

Using Dialog Boxes to Collect Information ........................................................................703

Composing the SQL statement ................................................................................704

Adding a default button ..........................................................................................706

Setting a Cancel button ...........................................................................................706

Removing the control menu ....................................................................................706

Closing the form .....................................................................................................707

Summary ..........................................................................................................................707

02_475348-ftoc.indd xxii02_475348-ftoc.indd xxii 4/1/10 1:42 PM4/1/10 1:42 PM