Mastering Access 2002 Premium Edition

Acknowledgments......Page 10
Contents at a Glance......Page 11
Contents......Page 13
Introduction......Page 34
PART I – AN OVERVIEW OF ACCESS......Page 40
1. Getting Started and Getting Around......Page 42
Starting Access......Page 44
Opening an Existing Database or Project......Page 48
Opening the Sample Northwind Database......Page 51
What Is a Database, Anyway?......Page 52
And What about Projects?......Page 54
Working in the Database Window......Page 55
Uncovering a Hidden Database Window......Page 56
Changing Your View of Database Window Objects......Page 57
Working with Groups of Objects......Page 58
Managing Database Objects......Page 59
Using the Toolbars and Menu Bar......Page 60
Viewing Toolbars, ScreenTips, and the Status Bar......Page 62
Showing More of a Menu......Page 63
Positioning the Toolbar or Menu Bar......Page 64
Opening Shortcut Menus......Page 65
Getting Help......Page 66
Summary of Self-Help Techniques......Page 67
Looking Up Information......Page 68
Help with Whatever You\'re Doing......Page 70
Searching Help......Page 71
Asking the Office Assistant......Page 72
Exiting Microsoft Access......Page 73
Where to Go from Here......Page 74
2. Understanding Databases......Page 76
You Use Tables to Store Data......Page 78
The More Fields, the Better......Page 80
Why Use Multiple Tables?......Page 81
The One-to-Many Relationship......Page 82
The Primary Key Field......Page 83
Where to Go from Here......Page 84
3. Access in an Evening......Page 86
Before You Start These Lessons......Page 87
Creating an Instant Database......Page 88
Understanding the Wizards......Page 89
Choosing a Style for Forms......Page 90
Choosing a Style for Printed Reports......Page 91
Choosing a Database Title and Adding a Picture......Page 92
Finishing Up......Page 93
At Your Leisure......Page 94
Returning from a Break......Page 95
Exploring the Contact Management Form......Page 96
Exploring the Contact Management Reports......Page 97
Lesson 3: Creating and Customizing a Form......Page 98
Modifying and Saving the Form Design......Page 99
Preventing the Cursor from Landing in a Field......Page 103
At Your Leisure......Page 104
Opening the Form......Page 105
Making Changes and Corrections......Page 107
Don\'t Save Each Record......Page 109
Sorting and Filtering......Page 110
Remember: Computers Are Dumb!......Page 111
Lesson 5: Creating and Printing Reports......Page 112
Preparing Mailing Labels......Page 113
Previewing and Printing a Report......Page 115
Using the Page Wizard......Page 117
Browsing Your New Page......Page 119
Creating a Query......Page 120
Choosing Fields to View......Page 121
Choosing Records to View......Page 122
Choosing the Sort Order......Page 123
Running the Query......Page 124
Changing the Query......Page 125
At Your Leisure......Page 126
Adding Command Buttons to a Form......Page 127
Creating the Close Button......Page 130
Adding Visual Basic Code to a Form......Page 131
Customizing the Switchboard Form......Page 133
Putting It All Together with Startup Commands......Page 136
Testing the Application......Page 137
Where to Go from Here......Page 138
4. About Access, Office, Windows, and the Internet......Page 140
Making the Most of Windows and Access......Page 141
The Microsoft Office Shortcut Bar......Page 144
Common Bars......Page 146
Common Dialog Boxes......Page 147
Common Office Tools......Page 148
Sharing Access Information with Other Office Programs......Page 150
Using OLE......Page 151
Using Access Data from Microsoft Excel......Page 156
Using Access Data from Microsoft Word......Page 159
Creating Data Access Pages......Page 161
Importing and Exporting HTML......Page 162
Where to Go from Here......Page 163
PART II – CREATING A DATABASE PROJECT......Page 164
5. Creating a Database......Page 166
Getting Started......Page 168
Creating a Blank Database......Page 169
Using the File Database Dialog Box......Page 171
Creating a Database with the Database Wizard......Page 173
About the Sample Databases......Page 176
Changing the Database Properties......Page 179
Where to Go from Here......Page 181
6. Creating Access Tables......Page 182
Using the Table Wizard to Create Tables......Page 183
Planning a Table from Scratch......Page 187
Creating a Table without Using a Wizard......Page 188
Defining a Table\'s Fields......Page 189
Choosing Appropriate Data Types......Page 190
Defining Field Properties......Page 191
Setting a Primary Key......Page 195
Saving a Table\'s Design......Page 197
Switching between Design and Datasheet Views......Page 198
Why Two Views?......Page 199
Modifying the Table Structure......Page 200
Selecting Rows in Design View......Page 201
Moving, Copying, Deleting, and Renaming Entire Tables......Page 202
Tables in the Order Entry Database......Page 203
The Customers Table......Page 204
The Products Table......Page 206
The Orders Table......Page 207
The Order Details Table......Page 208
The Payments Table......Page 209
Other Tables in Order Entry......Page 210
About Lookup Fields......Page 211
Use a Query When…......Page 212
Use a List of All Field Names in a Table When…......Page 213
Setting up a Lookup Field......Page 214
Defining Relationships among Tables......Page 219
Relating Two Tables......Page 221
Redefining (or Deleting) a Relationship......Page 225
Changing the Starting Value of an AutoNumber Field......Page 226
Defining a Relationship When One Field Is an AutoNumber......Page 228
Where to Go from Here......Page 230
7. Linking, Importing, and Exporting Data......Page 232
Link, Import, Export: What\'s the Difference?......Page 233
Interacting with Other Databases......Page 234
Where You\'ll See Imported/Linked Tables......Page 235
Importing or Linking Paradox Tables......Page 237
Importing or Linking dBASE Files......Page 238
Importing or Linking ODBC Databases......Page 239
Importing or Linking Other Access Databases or Projects......Page 241
Setting Properties of Linked Tables......Page 243
Speeding Up Linked Tables......Page 244
Using the Linked Table Manager......Page 245
Deleting the Link to a Linked Table......Page 246
Importing or Linking Spreadsheets and Text Files......Page 247
Importing or Linking Spreadsheets......Page 249
Importing or Linking Text Files......Page 252
Using an Import or Link Specification......Page 256
Importing or Linking HTML Files......Page 259
Importing XML Documents......Page 261
Troubleshooting Import Problems......Page 262
Problems When Importing to Existing Tables......Page 264
Exporting Data from Access......Page 265
Exporting Objects......Page 266
Exporting to Text or Excel Files......Page 267
Exporting to an ODBC Database......Page 268
Exporting to Another Access Database......Page 269
Exporting to HTML or HTX Files......Page 270
Exporting to XML......Page 271
Using OfficeLinks......Page 272
Mailing an Access Object......Page 273
Where to Go from Here......Page 275
8. Adding, Editing, and Viewing Data......Page 276
Datasheet View and Form View......Page 277
Closing a Form......Page 278
Switching between Datasheet View and Form View......Page 279
Opening a Subdatasheet View for One Record......Page 281
Choosing a Table for a Subdatasheet View......Page 282
Expanding All Subdatasheets for a Datasheet......Page 283
Inserting a Subdatasheet......Page 284
Customizing the Datasheet View......Page 285
Using the Formatting Toolbar......Page 286
Selecting and Arranging the Datasheet Rows and Columns......Page 287
Freezing and Unfreezing Columns......Page 289
Customizing the Subdatasheet View......Page 290
Navigating Forms and Datasheets......Page 291
Adding Data to a Table......Page 293
Tips for Adding Records......Page 294
Changing Data in a Table......Page 295
Keys for Editing Table Data......Page 296
Selecting Records and Fields......Page 297
Deleting Records......Page 299
When Cut-and-Paste Won\'t Work......Page 300
Using Hyperlinks in a Table......Page 301
Entering Hyperlink Addresses......Page 303
Using OLE to Store Pictures, Sounds, and Other Objects......Page 307
About OLE Servers and Clients......Page 308
An Easy Way to Insert Objects......Page 309
What the Object Looks Like......Page 311
Other Ways to Insert Objects......Page 312
Special Techniques for Memo Fields......Page 316
Special Techniques for Sizing Photographs......Page 317
Step 1: Create the Table and Field......Page 318
Troubleshooting Data Entry and Editing Problems......Page 319
Value Isn\'t Appropriate for This Field Type......Page 320
Access Won\'t Let You Add or Change Any Data......Page 321
Changing the Table Design from Datasheet View......Page 322
Inserting a Hyperlink Column......Page 323
Deleting a Column......Page 324
Where to Go from Here......Page 325
9. Sorting, Searching, Filtering, and Printing......Page 326
Quick and Easy Sorting......Page 327
Sorts within Sorts......Page 328
Returning the Records to Their Original Order......Page 329
Finding Individual Records......Page 330
Correcting Mistakes as You Type......Page 332
Checking Your Spelling......Page 335
Replacing Data in Multiple Records......Page 338
A Search-and-Replace Example......Page 339
Filtering Out Unwanted Records......Page 340
Filtering For Input......Page 341
Filtering by Selection or Exclusion......Page 342
Removing or Reapplying a Filter......Page 344
Filtering by Form......Page 345
Using Advanced Filter/Sort......Page 350
Choosing Fields to Filter......Page 353
Specifying Selection Criteria......Page 354
Sample Filters......Page 358
Saving a Filter as a Query......Page 361
Troubleshooting Filters......Page 362
Previewing Your Printout......Page 364
Printing Your Form or Datasheet......Page 366
Where to Go from Here......Page 369
10. Querying Your Tables......Page 370
What Queries Let You Do......Page 371
Types of Queries......Page 372
Using Query Wizards......Page 373
Creating a Query from Scratch......Page 374
Viewing the SQL Statement behind a Query......Page 379
Saving Your Query......Page 380
About the Query Design Window\'s Toolbar......Page 381
Filling In the QBE Grid......Page 384
Changing Field Properties......Page 385
Changing Query Properties......Page 386
Joining Tables......Page 389
Creating AutoLookup Queries......Page 395
Prompting for Selection Criteria......Page 397
Using Totals, Averages, and Other Calculations......Page 399
Using Calculated Fields......Page 400
Summarizing Your Data......Page 402
Creating Crosstab Queries......Page 410
Creating Action Queries......Page 413
Update Queries......Page 414
Append Queries......Page 416
Delete Queries......Page 418
Make-Table Queries......Page 420
Troubleshooting Action Queries......Page 421
Where to Go from Here......Page 423
11. Creating Forms with Form Wizards......Page 424
Columnar Forms......Page 425
Tabular Forms......Page 426
Datasheet Forms......Page 427
Hierarchical Forms......Page 428
Charts......Page 431
PivotTables......Page 432
Using Wizards to Create a Form......Page 433
Opening and Using a Form......Page 439
Getting Around in Hierarchical Forms......Page 444
Changing the Style of a Form......Page 445
Where to Go from Here......Page 446
12. Creating Reports with Report Wizards......Page 448
Columnar (Vertical) Reports......Page 449
Tabular Reports......Page 450
Groups, Totals, and Summary Reports......Page 451
Mailing Labels......Page 455
Using Wizards to Create a Report......Page 456
Creating Mailing Labels......Page 467
Opening a Report......Page 470
Changing the Style of a Report......Page 471
Where to Go from Here......Page 472
13. Creating Custom Forms and Reports......Page 474
Switching to Design View......Page 475
Creating a Form or Report from Scratch......Page 476
Design Tools......Page 478
Choosing a Style for Your Design......Page 479
The Field List, Design View Toolbars, and Toolbox......Page 481
The Property Sheet......Page 482
The Ruler......Page 484
The Grid......Page 485
Changing the Size of the Form or Report......Page 486
Adding Bound Controls (Fields)......Page 487
Selecting Controls, Sections, Forms, and Reports......Page 489
Deleting Controls......Page 490
Grouping Controls......Page 491
Resizing Controls......Page 492
Aligning Controls......Page 493
Changing the Font, Color, Border, Appearance, and More......Page 494
Controlling the Tab Order......Page 495
Copying Properties to Other Controls......Page 496
Adding Help, Menus, and Prompts to Controls......Page 497
Customizing AutoFormat Styles......Page 499
Specifying the Record Source on the Fly......Page 500
Form Sections......Page 501
Report Sections......Page 503
Grouping Data in Reports......Page 506
Sizing a Section......Page 511
Adding Your Own Controls......Page 512
Using the Toolbox......Page 513
Changing Default Properties for Toolbox Tools......Page 516
Adding Text Boxes......Page 518
Adding Option Groups......Page 519
Adding Toggle Buttons, Option Buttons, and Check Boxes......Page 521
Adding Combo Boxes and List Boxes......Page 522
Adding the Current Date and Time......Page 525
Drawing Frames around Controls......Page 526
Adding Page Breaks......Page 527
Adding Hyperlinks......Page 529
Adding Command Buttons......Page 531
Adding Tab Controls......Page 532
Adding Pictures, Sounds, and Other Objects......Page 534
Changing the Front-to-Back Order of Controls......Page 541
Creating Calculated Controls......Page 542
Adding a Subform or Subreport......Page 545
Putting a Preprinted Form on the Screen......Page 549
Step 2: Create the Table......Page 550
Step 4: Put the Printed Form on the Screen......Page 551
Printing a Report from the Form......Page 553
Form Letters, Mailing Labels, Etc.......Page 554
First Aid for Designing Forms and Reports......Page 555
Where to Go from Here......Page 557
14. Creating Data Access Pages......Page 558
Types of Data Access Pages......Page 560
Where Data Access Pages Reside......Page 561
How a Page Finds Its Data......Page 562
Using the Page Wizard......Page 563
Starting the Page Wizard......Page 564
Creating a One Table Page with the Page Wizard......Page 565
Creating a Grouped Page with the Page Wizard......Page 567
Creating a Page Yourself......Page 569
The Parts of a Data Access Page......Page 570
The Data Access Page Design Toolbox......Page 571
Notes on Working in the Data Access Page Design Window......Page 572
Aligning and Sizing Objects......Page 573
Adding a Title to a Page......Page 574
Using the Field List......Page 575
Adding a Table......Page 576
Adding a Field......Page 578
Adding Data from Related Tables......Page 579
Adding a PivotTable List to a Page......Page 581
Moving a PivotTable List......Page 582
Deleting a Field from a PivotTable List......Page 583
Filtering Records in a PivotTable List......Page 584
Grouping Data in a PivotTable List......Page 586
Sections of a Grouped Data Access Page......Page 589
Grouping Records Using a Table......Page 591
Adding a Caption Section to a Group......Page 594
Adding a Summary Field to a Group Footer......Page 596
Including Other Controls on a Page......Page 597
Applying a Theme to a Page......Page 598
Setting a Default Theme......Page 599
Creating a Stand-Alone Data Access Page......Page 600
Browsing a Page with Internet Explorer......Page 602
Revising an Access Data Access Page......Page 603
Revising Another Type of Web Page......Page 604
Where to Go from Here......Page 605
15. Creating Charts and PivotTables......Page 606
Charting Your Data......Page 607
Choosing the Data You Want to Chart......Page 609
About Freestanding and Embedded Charts......Page 612
Creating a Freestanding Chart......Page 615
Creating an Embedded Chart......Page 618
Customizing a Chart......Page 627
Building a Better Chart......Page 631
Freezing the Data in Your Chart......Page 633
Charting Data from Other Programs......Page 634
Creating PivotTables......Page 636
Understanding PivotTable Buzzwords and Procedures......Page 639
Creating a PivotTable with the PivotTable Wizard......Page 641
Where to Go from Here......Page 644
PART III – DATABASE TUNING AND ADMINISTRATION......Page 646
16. Personalizing Access......Page 648
Personalizing Your Work Environment......Page 649
Changing Advanced Options......Page 650
Changing Datasheet Options......Page 651
Changing Edit/Find Options......Page 652
Changing Forms/Reports Options......Page 653
Changing General Options......Page 654
Changing International Options......Page 656
Changing Keyboard Options......Page 657
Changing Pages Options......Page 658
Changing Spelling Options......Page 659
Changing Tables/Queries Options......Page 660
Changing View Options......Page 662
Changing Startup Options......Page 664
Installing Wizards, Builders, and Menu Add-Ins......Page 667
Using Control Panel to Customize Access......Page 669
Using Command-Line Options When Starting Access......Page 670
Where to Go from Here......Page 673
17. Speeding Up Your Database......Page 674
So Where Do I Start?......Page 675
Tweaking Hardware and Windows Settings......Page 676
Tweaking General Access Settings......Page 678
Using the Performance Analyzer......Page 679
Speeding Up Tables......Page 680
Speeding Up Queries......Page 681
Speeding Up Forms, Reports, and Printing......Page 682
Where to Go from Here......Page 683
18. Administering Your Database......Page 684
Backing Up a Database......Page 685
Why You Need to Compact a Database......Page 687
Repairing a Damaged Database......Page 689
Converting from Other Access Formats......Page 690
Encrypting and Decrypting Your Database......Page 692
Viewing Information about Your Database......Page 693
Documenting Your Database......Page 695
Creating a Replica......Page 697
Creating a Partial Replica......Page 699
Updating a Replica......Page 701
Where to Go from Here......Page 702
19. Networking and Security......Page 704
Option 1: Put the Entire Database on the Server......Page 705
Option 2: Put Only Shared Data on the Server......Page 706
Separating the Tables......Page 707
Preventing Exclusive Access......Page 709
Editing Data on a Network......Page 710
Refreshing Network Data......Page 713
Tweaking Multiuser Settings......Page 714
Record-Locking Strategies......Page 715
Minimizing Locking Conflicts......Page 717
Security Concepts......Page 718
Access Logons......Page 719
Workgroup Files......Page 720
Built-In User and Groups......Page 722
Working with Users and Groups......Page 723
Viewing Ownership and Permissions......Page 726
The User-Level Security Wizard......Page 728
Skating Past the Logon Dialog Box......Page 731
Password Security......Page 732
Where to Go from Here......Page 733
PART IV – BUILDING A CUSTOM APPLICATION......Page 734
20. Creating a Custom Application......Page 736
How Much Programming Is Involved?......Page 737
Finding Event Properties......Page 738
Sample Form Events......Page 740
Sample Control Events......Page 741
Creating a Control and Action in One Step......Page 742
Using Control Wizards......Page 743
Testing the New Control......Page 746
More Wizard-Created Controls......Page 747
Where to Go from Here......Page 748
21. Using Macros to Create Custom Actions......Page 750
How to Create a Macro......Page 751
Determining When a Macro Plays......Page 755
Running the Macro......Page 756
Summary of Macro Actions......Page 757
Executing a Macro Action \"If…\"......Page 760
Creating Macro Groups......Page 765
Editing Macros......Page 767
Referring to Controls from Macros......Page 768
Typing Lengthy Identifiers......Page 771
Making More \"Generic\" Macros......Page 774
Dealing with Macro Errors......Page 776
Single-Stepping through a Macro......Page 777
Creating a Macro to Run at Startup......Page 778
Learning by Example......Page 779
Where to Go from Here......Page 780
22. Creating Custom Switchboards......Page 782
Changing Wizard-Created Switchboard Options......Page 783
Defining and Changing Switchboard Items......Page 784
Changing Wizard-Selected Art......Page 786
Creating the Blank Switchboard Form......Page 789
Adding Controls to Your Custom Switchboard......Page 791
Creating a Macro for the New Control......Page 793
Making AddressBook Return to the Main Switchboard......Page 796
Filling Out the Switchboard......Page 801
Wizard-Created versus Custom Switchboards......Page 803
Summary: Custom Switchboards......Page 804
Where to Go from Here......Page 805
23. Creating Custom Dialog Boxes......Page 806
Our Goal......Page 807
Add the Check Box Controls......Page 809
Add the Command Buttons......Page 811
Print, Save, and Close the Form......Page 813
Cancel Printing Macro......Page 815
Preview Reports Macro......Page 816
Print Reports Macro......Page 818
Step 3: Assign Macros to Dialog Box Buttons......Page 820
Modal and Pop-Up Properties......Page 822
Dialog Box Border Style......Page 823
Default and Cancel Buttons......Page 824
Where to Go from Here......Page 826
24. Creating Custom Toolbars......Page 828
Hiding and Displaying the Built-In Toolbars......Page 829
Controlling the Size and Appearance of Toolbars......Page 830
Creating a Custom Toolbar......Page 831
Adding and Deleting Buttons......Page 832
Saving and Modifying the Custom Toolbar......Page 834
Creating Your Own Buttons......Page 835
Changing a Button\'s Face and Description......Page 836
Creating Your Own Button Face......Page 837
Adding Toolbars to Your Custom Application......Page 838
Creating Macros to Show or Hide Custom Toolbars......Page 839
Attaching Toolbars to Forms......Page 840
Attaching a Custom Toolbar to Print Preview......Page 841
Combining Menus and Toolbars......Page 842
Where to Go from Here......Page 844
25. Creating Custom Menus......Page 846
Creating Custom Menus......Page 847
Adding a Custom Menu to a Menu Bar......Page 849
Copying Commands from a Menu......Page 851
Saving a Custom Menu Bar......Page 852
Attaching a Custom Menu to a Form or Report......Page 853
Building a Shortcut Menu......Page 854
Setting a Contextual Shortcut Menu......Page 855
Where to Go from Here......Page 856
PART V – REFINING A CUSTOM APPLICATION......Page 858
26. Introducing Visual Basic......Page 860
Why Use Visual Basic?......Page 861
What Is the Shape of Visual Basic?......Page 862
Visual Basic and Events......Page 863
Visual Basic and Statements......Page 865
Visual Basic and Variables......Page 866
Visual Basic and Procedures......Page 867
Visual Basic and Functions......Page 868
Building a Sample Procedure......Page 869
Converting Macros to Visual Basic......Page 871
Where to Go from Here......Page 872
27. Creating Custom Error Messages......Page 874
Building Custom Error Messages with a Macro......Page 875
Flow Control in Visual Basic......Page 877
Building the Error Message......Page 884
Testing the Error Message......Page 886
Where to Go from Here......Page 887
28. Interacting with Other Programs......Page 888
Creating the Basic Object......Page 889
Working with the Basic Object......Page 893
Where to Go from Here......Page 895
29. Pulling It All Together......Page 898
What\'s Available to You......Page 899
Getting to the Source Code......Page 900
Finding Out What Makes It Tick......Page 902
What Good Is This Information?......Page 906
Printing Technical Documentation......Page 907
Modifying Existing Applications......Page 908
Where to Go from Here......Page 909
30. Working with Projects......Page 910
Project Basics......Page 911
The Sample NorthwindCS Project......Page 912
Installing the Sample NorthwindCS Project......Page 913
Working with the NorthwindCS Project......Page 914
Creating a New Project......Page 921
Creating a Project to Work with Existing Tables......Page 922
Creating a Project for New Tables......Page 923
Deploying a Project......Page 924
Where to Go from Here......Page 925
PART VI – MACRO PROGRAMMING FROM INDUSTRY EXPERT SUSANN NOVALIS......Page 926
31. Macro Basics......Page 928
The Macro Window......Page 929
The Macro Toolbar......Page 932
Macro Arguments......Page 934
Duplicating Built-in Commands......Page 939
Sending Messages......Page 940
Sending Keystrokes......Page 942
Displaying Current Data......Page 943
Creating Macros......Page 946
Using Macro Flow Diagrams......Page 947
Editing in the Macro Sheet......Page 948
Running a Macro from the Macro Window......Page 949
Running a Macro from Any Active Window......Page 950
Running a Macro from a Command Bar......Page 951
Running a Macro from a Shortcut Key......Page 952
Running a Macro at Startup......Page 953
Running a Macro from the Visual Basic Window......Page 954
Running a Marco by Trapping an Event on a Form or Report......Page 956
Documenting Macros......Page 957
Forms Navigation......Page 959
Conditional Macros......Page 967
Controlling the Flow of a Macro with Conditions......Page 968
The Built-in Decision Functions......Page 977
Macro Loops......Page 980
Where to Go from Here......Page 985
32. Dealing with Errors in Macros......Page 986
Syntax Errors......Page 987
Run-Time Errors......Page 988
Logic Errors......Page 989
Single Stepping Macros......Page 990
Using Breakpoints......Page 991
Using the MsgBox Action to Troubleshoot......Page 992
Using the Visual Basic Window to Troubleshoot......Page 993
Handling Run-Time Errors: Macros versus Visual Basic......Page 996
The Error Code for an Error......Page 997
Using Macro Programming......Page 998
A Simple Visual Basic Error Handler for the Error Event......Page 999
Designing to Avoid Macro Errors......Page 1002
Exceptional Macro Actions......Page 1004
Where to Go from Here......Page 1006
33. Navigation with Macros......Page 1008
Navigation through Controls......Page 1009
Moving to a Specific Control on the Active Form......Page 1010
Moving to a Specific Control on Another Open Form......Page 1012
Physical Navigation among Records......Page 1013
Automating Keystroke Navigation......Page 1014
Automating the Default Navigation Buttons and Menu Commands......Page 1015
Finding a Specific Record......Page 1019
Returning to the Previous Record......Page 1026
Remove Navigation Buttons from a Form with Logical Navigation......Page 1029
Adding Logical Navigation to Another Form......Page 1030
Synchronizing Two Forms......Page 1032
Adding the Review Button to Another Form......Page 1036
Keeping the Forms Synchronized......Page 1037
Create a Macro to Keep the Forms Synchronized......Page 1038
Synchronizing a Report to a Form......Page 1041
Creating a Startup Macro......Page 1043
Where to Go from Here......Page 1045
34. Data Maintenance with Macros......Page 1046
Using Macros to Validate Data......Page 1047
Using ValidationRule Properties......Page 1048
Checking for Duplicate Primary Key Values......Page 1050
Display a Primary Key Violation Form instead of a Message......Page 1052
Adding New Records......Page 1054
Analyze and Automate the Process......Page 1055
Undoing Changes......Page 1056
Saving Changes......Page 1057
Date-Stamp a Changed Record......Page 1058
Saving a New Record......Page 1060
Carrying Values Forward to a New Record......Page 1061
Setting the DefaultValue Property......Page 1062
To Delete......Page 1066
Cascading a Delete......Page 1070
Other Ways to Delete a Record......Page 1073
Add a New Record......Page 1074
Where to Go from Here......Page 1078
35. Working with Groups of Records Using Macros......Page 1080
Sorting Records......Page 1082
Automate the Sort Process......Page 1083
Selecting a Group of Records Interactively......Page 1091
Automate the Selection Process......Page 1093
Using Multiple Criteria to Select a Group of Records......Page 1097
Creating a Second Selection Combo Box......Page 1098
Adding a Null Row to a Selection Combo List......Page 1100
Adding a Null Row to Another Combo List......Page 1104
Printing a Group of Records Based on the Current Form......Page 1105
Using a Custom Dialog to Select Records......Page 1110
Create a Filter Query for the Report......Page 1114
Creating a Custom Dialog......Page 1115
Setting Criteria for the Filter Query......Page 1117
Using the OpenQuery Action to Run an Action Query......Page 1120
PART VII – APPENDICES......Page 1126
A: Installing Microsoft Access......Page 1128
Checking Your Hardware......Page 1129
Preparing Your Access 2.0, Access 95, and Access 97 Databases......Page 1130
Installing Access......Page 1131
Running Setup to Add or Remove Components......Page 1132
Enabling and Converting Old Access Databases......Page 1133
Converting a Database a Different File Format......Page 1134
B: About the CD-ROM......Page 1136
Copying a Database to Your Hard Disk......Page 1137
ZipDemo and FuncDemo......Page 1138
United States Postal Service Barcodes......Page 1139
Installing the PLANET Font......Page 1140
From TAZ Information Services......Page 1141
C: Installing and Using Fulfill 2002......Page 1144
Copying Fulfill 2002 to Your Hard Disk......Page 1145
Starting Fulfill 2002......Page 1146
Using Fulfill\'s Address Book......Page 1147
Adding a Name and Address......Page 1148
Entering Credit Card Information......Page 1153
Navigating the Address Book......Page 1155
Printing from the Address Book......Page 1159
Adding New Products......Page 1162
Navigating the Products Form......Page 1164
Entering Orders......Page 1165
Entering a New Order......Page 1166
Tools for Managing Current (Unprinted) Orders......Page 1172
Tools for Managing Printed Orders......Page 1173
Questions, Comments, Snide Remarks......Page 1176
A......Page 1178
C......Page 1181
D......Page 1183
E......Page 1188
F......Page 1189
G......Page 1193
H......Page 1194
I......Page 1195
L......Page 1196
M......Page 1197
O......Page 1201
P......Page 1202
Q......Page 1204
R......Page 1206
S......Page 1209
T......Page 1212
U......Page 1214
W......Page 1215
Z......Page 1216