|
|
|
In Access, a query is an element that searches an Access database for specific information in answer to the user’s request. For example in the AddressDB, created in this tutorial, a query could find a specific person’s or all peoples addresses in a specific state. A query could find specific or all phone numbers, or e-mail addresses. After I show you how to create a query and how to use it on the AddressForm you will be able to see how useful they are and how they can find, sort and display information contained in the database. Without queries, a database would be nothing more than a notebook. |
First we need to view the AddressDB main window. To bring up the main database window, you need to open the AddressDB. You open the AddressDB via the following path from the desktop: (or, if you have the AddressDB already open, simply press the F11 key) Start \ Programs \ Microsoft Access \ Open an existing file \ AddressDB \ OK If you followed the path correctly, you’ll see something like the following: |
| Next, click where I’ve indicated in the above picture. Be sure to double click in step 2. Incidentally, anytime you’re not sure whether to click on an object once or twice, just click once and wait a second or two. |
If nothing happens click twice. You can do this in any windows program.
After clicking, you’ll see the picture on the next page:
|