Read more about Services on Office Update  

Answers to Your Questions About Access 2000 

In addition to helpful Access 2000 Articles, Tips and Tricks for Access 2000, and Access 2000 Downloads, the Office Update Web site offers articles In Response to Your Online Comments about Access. These articles respond directly to questions you have asked Office Update through the Answer Wizard in Access Help. The following list brings together all the various types of user assistance available on the Office Update site and addresses some of the most common user questions about Access.

Creating and working with databases

• Avoiding Divide By Zero Errors in Access 97/2000
• Access 97/2000: Avoid Multiple Fields That Contain Similar Data
• Getting Help in Access 2000
• Incrementing the Numeric Portion of a String in Access 97/2000
• List of Keys Used in the Relationships Window in Access 2000
• Managing Relationships in Access 2000 by Using the Keyboard
• Access 97/2000: Opening Multiple Databases at the Same Time
• Access 97/2000: Periodically Archive Records
• Switchboard Manager and Linked Table Manager in Access 2000

Creating and designing tables

• Access 97/2000: Base a Primary Key on More Than One Field
• Access 97/2000: Enter a Value in a New Record Automatically
• Access 97/2000: Fields That Generate Numbers Automatically
• Access 97/2000: How Field Properties Work with Bound Controls
• Access 97/2000: Inserting the Value from the Previous Record
• Access 97/2000: Phone Number Input Mask with Default Area Code
• Access 97/2000: Print Information About the Design of a Table
• Access 97/2000: Storing Postal Codes (ZIP Codes) in a Text Field

Working with queries

• Access 97/2000 Queries: Display Only Highest or Lowest Values
• Finding the First or Last Record in a Query in Access 97/2000
• Access 97/2000: Periodically Archive Records
• Access 97/2000: Sorting Records in a User-Defined Order

Working with reports and forms

• Access 97/2000: Add the Database Name to a Report
• Calculating Age from a Birth Date in Access 97/2000
• Calculating a Future or Past Date in Access 97/2000
• Calculating Week Days Between Two Dates in Access 97/2000
• Access 97/2000: Creating a Report Based on Multiple Queries
• Access 97/2000: How Field Properties Work with Bound Controls
• Access 97/2000: Move a Form or Report Control to Another Section
• Display a Criteria Parameter in an Access 97/2000 Report
• Access 97/2000: Placing a Subreport in a Report
• Access 97/2000: Specifying the Color of a Control's Interior
• Using Dates and Times in Access 2000

How to get the answers you need from Help

When you have a question about an Office program, you can ask the Office Assistant for help. For example, if you want to see information about how to save a document as a Web page, you can type save document in the Office Assistant balloon. However, typing something more specific, such as save a document as a Web page, will provide you with better feedback. If the Office Assistant is turned off, you can type your question on the Answer Wizard tab in the Help window, and then click Search.

The natural language technology in Office 2000 allows you to ask the Office Assistant for help in your own words, without having to know the correct computer terminology. You get personalized, interactive assistance when you need it.

Send your question to Office Update

If you have a question about Access and can't find the answer in Access Help or on the Office Update Web site, you can send your question to Office Update by using the Office Assistant. A response to your question may be posted on the Office Update Web site.

You must be using the Office Assistant to get Help. When you ask a question in Access Help and don't find the information you want, do the following to send your question to Office Update and search for help there:

1. Select the None of the above, look for more help on the Web option in the Office Assistant balloon.
2. In the text box provided for your feedback, describe what you are trying to do.
3. Click the Send and go to the Web button to send Office Update your question and search for help on the Office Update Web site.

Look for answers In Response to Your Online Comments about Access.

Additional resources

Office Update Answer Wizard Extensions for Office 2000   The Office Update Answer Wizard Extension for Office 2000 includes links to articles and other information about Office 2000 on Office Update.

Knowledge Base Search   The Microsoft Knowledge Base includes technical support information and self-help tools for Microsoft products.

Microsoft Product Support Services   Product Support Services include technical support offerings, such as phone numbers, online requests, FAQs, and custom support.