Access 97 Articles Available by Fax or E-Mail: Tables & Design

• Microsoft Access 97

SUMMARY

This article shows you how to obtain support information from the Microsoft Knowledge Base by e-mail or by fax. If you are currently viewing this article on the World Wide Web, this information may not pertain to you.

MORE INFORMATION

The "Article Listing" section of this article includes a subset of Knowledge Base articles about Tables and Database Design in Microsoft Access 97. Use the instructions in the "Ordering an Article by E-Mail or by Fax" section of this article to order items from this list.

Note that because Microsoft Technical Support is constantly adding new information to the Knowledge Base, not all articles are listed here. For this reason, you may want to look on the Web to find the information you are looking for. Microsoft Technical Support on the Web is located at the following address on the World Wide Web:

   http://support.microsoft.com/support/default.asp

ORDERING AN ARTICLE BY E-MAIL OR BY FAX

Ordering an Article by E-Mail

To have an article from the list sent to you in e-mail, send a message to "mshelp@microsoft.com" (without the quotation marks), and use the Article ID in the subject line of the message, as in the following example:

     TO: mshelp@microsoft.com
     SUBJECT: Q119591

   mshelp@microsoft.com

Ordering an Article over the Phone and Having It Sent to a Fax Machine

To have an article sent to a fax machine, use the Microsoft FastTips System. Microsoft FastTips is available 24 hours a day, 7 days a week, from a touch-tone telephone. To order items from this article list, first note the five- to six-digit number of the Article ID shown for each item, and then follow these steps:

1. Dial the toll-free FastTips number:

         (800) 936-4100
   

2. When prompted, select the appropriate number for the product you are using (for example, for Microsoft Word, select 2).

3. When prompted, select the version of the product that you are using.

4. From the "FastTips Main Menu," select 1 to place a FastTips catalog order.

5. At the "to order items from your catalog" prompt, select 1.

6. When prompted with the "at the tone, enter the item ID number followed by the pound key" message, enter the Article ID number from the following list and press # (use the numbers following "Q," but do not include "Q").

         NOTE: You can order up to five items at a time.
   

7. When prompted, select the fax option and enter your three-digit area code and seven-digit fax number.

8. When you're finished ordering, hang up.

ARTICLE LISTING

 ITEM ID  ARTICLE TITLE                                               PAGES
 --------------------------------------------------------------------------

 Q93690  ACC: How to Update a Table Based on Values in a Second Table    2
 Q95608  ACC: How to Parse Comma-Separated Text into Multiple Fields     4
 Q98793  ACC: Compound Indexes Must Restrict First Indexed Field         2
 Q98664  ACC: Deleting Duplicate Records from Two Tables                 3
 Q100139 ACC: Database Normalization Basics                              5

 Q101675 ACC: Sample Table Design to Support Questionnaire Applications  3
 Q109329 ACC: How to Delete Duplicate Records from a Table               2
 Q109704 ACC: Storing Calculated Values Using ControlSource Property     4
 Q109953 ACC: How to Repair a Damaged Database                           5
 Q112111 ACC: Cannot Enforce Referential Integrity in Relationship       3

 Q114810 WX0995: Table and Query Questions and Answers                   8
 Q130514 ACC: Storing, Calculating, and Comparing Date/Time Data         6
 Q140636 ACC: How the Table Analyzer Wizard Works                        3
 Q155514 ACC: Can't Create Relationship with Multiple-Field Primary Key  4
 Q159327 ACC97: How to Edit Data in a Hyperlink Field in a Table         3

 Q162750 ACC97: Copying Linked Table Does Not Create Local Table         3
 Q164098 ACC: Lookup Wizard Fails with Certain Data Types in Tables      5
 Q164172 ACC: Understanding Relational Database Design Available on MSL  2
 Q164238 ACC97: Duplicate Relationships Multiply in Back-End Database    6
 Q164240 ACC97: Error Messages Running DB Documenter or Table Analyzer   3

 Q165209 ACC: Table Wizard Loses Selection When You Scroll Backward      2
 Q166290 ACC: Error Using Database Documenter If Objects Are Open        3
 Q167068 ACC97: Changes to Design of Linked Table Saved If Data Modified 3
 Q167171 ACC97: Error Saving Table with Multiple Primary Key             4
 Q167660 ACC97: Modifying Linked Exchange Tables in Microsoft Access     4

 Q168549 ACC97: Choosing the Appropriate DB White Paper Available on MSL 2
 Q170779 ACC: Inconsistent Behavior with Multiple-Field Primary Key      4
 Q172347 ACC97: "Invalid procedure call" Error with Linked Table Manager 4