Understanding OptimizationModifying Hardware and Software ConfigurationsHardware, Hardware, More Hardware Please!RAM, RAM, That's All I Need!Defragment Your User's Hard DiskCompact Your DatabaseDon't Use Compressed DrivesTune Virtual Memory: Tweak the Swap FileRun Access and Your Application LocallyDo Everything You Can to Make Windows Itself FasterChange Access's Software SettingsUnderstanding What Jet 3.5 Does to Improve PerformanceLetting the Performance Analyzer Determine Problem AreasDesigning Tables to Optimize PerformanceWhy Be Normal?I Thought You Just Told Me to NormalizeIndex, Index, Index!Select the Correct Data TypeDesigning Queries to Optimize PerformanceChanging Code to Improve PerformanceEliminate Variants and Use the Smallest Data Type PossibleUse Specific Object TypesUse Inline CodeToggle Booleans Using NotUse the Built-In CollectionsUse the Length FunctionUse True and False Instead of ZeroUse Transactions… Sometimes?Eliminate Unused Dim and Declare StatementsEliminate Unused CodeUse Variables to Refer to Properties, Controls, and Data Access ObjectsUse With...End WithUse the Me KeywordUse String Functions When PossibleUse Dynamic ArraysUse Constants When PossibleUse BookmarksSet Object Variables Equal to NothingUse Action Queries Instead of Looping Through RecordsetsDeliver Your Application with the Modules CompiledRetaining the Compiled StateDistribute Your Application as an MDEOrganize Your ModulesDesigning Forms and Reports to Improve PerformanceDesigning FormsDesigning ReportsPractical Examples: Improving the Performance of the Time and Billing ApplicationSummary