Microsoft Access 2010 Bible

xxv

Contents

Part IV: Professional Database Development 839

Chapter 24: Optimizing Access Applications  . . . . . . . . . . . . . . . . . . . . . 841

Understanding Module Load on Demand .........................................................................841

Organizing your modules ........................................................................................842

Pruning the call tree ................................................................................................842

Using the .accdb Database File Format ..............................................................................844

Distributing .accde Files ....................................................................................................846

Understanding the Compiled State ....................................................................................848

Putting your application’s code into a compiled state ..............................................849

Losing the compiled state ........................................................................................850

Distributing applications in a compiled or uncompiled state ...................................851

Improving Absolute Speed ................................................................................................854

Tuning your system.................................................................................................856

Getting the most from your tables ...........................................................................856

Getting the most from your queries .........................................................................858

Getting the most from your forms and reports ........................................................859

Getting the most from your modules .......................................................................862

Increasing network performance .............................................................................866

Improving Perceived Speed ...............................................................................................867

Using a splash screen ..............................................................................................867

Loading and keeping forms hidden .........................................................................868

Using the hourglass .................................................................................................868

Using the built-in progress meter ............................................................................869

Creating a progress meter as a pop-up form ............................................................870

Speeding up the progress meter display ..................................................................872

Working with Large Access Databases ...............................................................................872

Understanding how databases grow in size .............................................................873

Recognizing that compiling and compacting may not be enough ............................874

Using the decompile option ....................................................................................876

Detecting an uncompiled database and automatically recompiling ..........................877

Making small changes to large databases .................................................................879

Summary ..........................................................................................................................879

Chapter 25: Advanced Data Access with VBA . . . . . . . . . . . . . . . . . . . . . 881

Adding an Unbound Combo Box to a Form to Find Data .................................................881

Using the FindRecord method .................................................................................883

Using a bookmark ...................................................................................................885

Filtering a Form ................................................................................................................888

With code ...............................................................................................................888

With a query ...........................................................................................................889

Summary ..........................................................................................................................895

02_475348-ftoc.indd xxv02_475348-ftoc.indd xxv 4/1/10 1:42 PM4/1/10 1:42 PM