Setting a Default Value for a Column ....................183
Example 3 ...............................183
Removing a Column from a Table .....................184
Example 4 ...............................184
Removing a Table ..............................185
Improving Data Retrieval Time Using Indexes ..............185
Index Options ..............................186
Creating an Index ............................187
Example 5 ...............................187
Viewing and Editing Indexes ......................188
Deleting an Index ............................189
Example 6 ...............................189
Summary ..................................189
Chapter 12 Temporary Tables vs. Views .............191
Introduction .................................191
Creating a View ...............................192
Example 1 ...............................192
Creating a Temporary Table ........................194
Example 2 ...............................194
Accessing the Temporary Table ......................195
Querying a Temporary Table ........................196
Example 3 ...............................196
Indexing a Temporary Table ........................197
Example 4 ...............................197
Updating a Temporary Table ........................198
Example 5 ...............................198
Deleting a Temporary Table ........................199
Example 6 ...............................199
Summary ..................................199
Chapter 13 Parameter Queries .................201
Introduction .................................201
Parameter Queries .............................201
Creating a Simple Query ..........................202
Example 1 ...............................202
Creating a Parameter Query ........................203
Example 2 ...............................203
Customizing Your Dialog Box .......................205
Example 3 ...............................205
Creating Multiple Prompts .........................206
Example 4 ...............................206
Example 5 ...............................207
Using the LIKE Keyword to Prompt the User ...............208
Example 6 ...............................208
x
Contents
4
|
|