xxiii
Contents
Chapter 20: Advanced Access Report Techniques . . . . . . . . . . . . . . . . . 709
Grouping and Sorting Data ...............................................................................................710
Grouping data alphabetically ...................................................................................710
Grouping on date intervals ......................................................................................714
Hiding repeating information ..................................................................................716
Hiding a page header ..............................................................................................719
Starting a new page number for each group ............................................................719
Formatting Data ................................................................................................................720
Creating numbered lists ..........................................................................................720
Adding bullet characters ..........................................................................................723
Adding emphasis at runtime....................................................................................725
Avoiding empty reports ...........................................................................................728
Avoiding null values in a tabular report ...................................................................728
Inserting vertical lines between columns .................................................................729
Adding a blank line every n records ........................................................................731
Even-odd page printing ...........................................................................................733
Using different formats in the same text box ...........................................................735
Centering the title ...................................................................................................736
Easily aligning control labels ...................................................................................736
Micro-adjusting controls .........................................................................................736
Adding Data ......................................................................................................................737
Adding more information to a report ......................................................................737
Adding the user’s name to a bound report ...............................................................738
Trying More Techniques ...................................................................................................739
Displaying all reports in a combo box .....................................................................739
Fast printing from queried data ...............................................................................740
Hiding forms during Print Preview ..........................................................................741
Using snaking columns in a report ..........................................................................741
Exploiting two-pass report processing .....................................................................747
Assigning unique names to controls ........................................................................749
Summary ..........................................................................................................................750Chapter 21: Building Multiuser Applications . . . . . . . . . . . . . . . . . . . . . 751
Working on a Network .....................................................................................................752
Network performance .............................................................................................752
File location ............................................................................................................753
Data sources ............................................................................................................754
Considering the Options for Opening a Database ..............................................................756
Splitting a Database for Network Access............................................................................759
Detailing the benefits of splitting a database ............................................................759
Knowing where to put which objects ......................................................................761
Using the Database Splitter add-in ..........................................................................762
Finding the Key to Locking Issues .....................................................................................764
Access’s built-in record-locking features ..................................................................765
Record-lock error handling .....................................................................................76802_475348-ftoc.indd xxiii02_475348-ftoc.indd xxiii 4/1/10 1:42 PM4/1/10 1:42 PM