Help consists of requesting or getting assistance while working on a database. There are various types of assistance you can get in Microsoft Access. One of the ways you can get help is by clicking the Help button on the right side of the Ribbon and close to the right border of the Microsoft Access interface:

One of the types of help you can get is through small boxes called tool tips. These small rectangles display when you position the mouse on a certain item, such as a button on a the Ribbon, for a few seconds. In the following example, the mouse is positioned on the Portrait button and a short description appears: 

When you move the mouse away, the small box disappears (or closes itself)

Context-Sensitive Help

Context-sensitive help refers to help provided on a specific dialog box on the screen. Such help is provided for objects that are part of the Microsoft Access interface. Context-sensitive help is also referred to as “What’s This?”. To get context-sensitive help, press Shift + F1. This would call a help window that can describe or explain the object that is displaying. Another type of context sensitive help is provided in various dialog boxes. They display a button with a question mark on the left of the system Close button. To use this type of help, click the question mark button .

1. Click the Office Button -> Access Options
2. Click Advanced
3. Press Shift + F1
    
   
4. Close the Access Help window
5. In the left frame, click Datasheet
6. To get context-sensitive help on a dialog box, on the Options dialog box, click the What’s This button 
7. Close the Access Help window
8. To close the Access Options dialog box, click Cancel

Probably no matter have careful and meticulous you are, sooner or later, you will get errors on something you are working on. These errors display a square box with an exclamation mark:

If you position the mouse on it, a down pointing arrow is added to the right side of the button and if you click the button or its down pointing arrow, a menu would appear. One of the options on the menu is labeled Help on This Error:

You can then click Help on This Error to get some information on how to fix the error.

In various sections of our lessons, we will use an object called the Properties window, which allows you to change the characteristics of a control:

Some options of the Properties window could be difficult to figure out, especially if they are not explicit and if you are not familiar with them. Fortunately, to get help for any item of the Properties window, click it and press F1. The Help window would come up and would display one or more options on the topic you had clicked. If you see a link with the same name of the item you clicked, you can click that link and its explanation would display.

Online help is a program that provides help on Microsoft Access. There are two main types of online help:

• Microsoft Access ships with a help system. To use it, simply press F1
• If you have access to a Microsoft Developer Network (MSDN) CD-ROM or DVD, which is the help system provided to programmers who use Microsoft technologies (such as Microsoft Visual Studio), it includes a section on Microsoft Office

1. Press F1
2. In the Access Help window and on the left side of Search, type Create Table
3. Click Search
    
   
4. On the list that appears, click Create tables in a database
5. On the Access Help window that appears, read the text, scroll down, and click Create A New Table
6. After reading it, on the toolbar of the Access Help window, click the Back button
7. Close the Access Help window

Although help on the Internet tends to be disparate, it is still the widest form of help available. This is provided in web sites, web pages, newsgroups, support groups, etc. As the publisher of the database environment, it is only natural to refer to Microsoft corporate web site first for help. The Microsoft web site is divided in categories. A web site is dedicated to Microsoft Access at http://www.microsoft.com/access. You can get help at http://support.microsoft.com. Probably the most visited site of Microsoft for developers of all Microsoft products is http://msdn.microsoft.com. This last site provides a tree list that presents items in categories (like the MSDN CD-ROM or a DVD).