|
|
|
Amazon.com
|
 |
|
|
|
|
|
|
|
Microsoft Access 2007 Tutorials for beginners |
|
|
Welcome to MS Tips and Tricks |
Welcome to MS Tips and Tricks -
You are at the right place if you need tutorials for beginners - Online Microsoft Access tutorials for beginners, covering the following categories
- Databases, Customization, Table, Forms, Queries, Reports, etc.,
|
Microsoft Access Tips and Tricks for beginners |
|
|
| |
| 19) Press the NEXT button. |
| |
| 20) Assign a name to the query. |
| |
|
| Illustration 9: Set the query's name. You can see the data or modify the query design. |
| |
| 21) Press the FINISH button. You will see the data. |
| |
|
| Illustration 10: Query's results. Click here to view larger image. |
| |
| 22) Now, you will create a more refined query. Select the Create option in the Options Tape, and select the Query
design command. |
| |
|
| Illustration 11: Query design view. Click here to view larger image. |
| |
| 23) Double click on each table name to add it to the query designer. |
| |
|
| Illustration 12: Query design view. Click here to view larger image. |
| |
| Notice that the relations between tables are added at time of there is added to the query designer |
| |
| 24) Double click on each Field on File table that you want to show. Skip the TypeId, AreaId and ThemeId
fields. |
| |
| 25) The fields Filename, Comments and Directory will appear at bottom grid. You can deselect the show option.
This option will hide the field but it will still remain in the query for other purposes (for example, you can count the distinct instances of the file
name). |
| |
|
| Illustration 13: You added the main query fields. Click here to view larger image. |
| |
|
|
| |
|
|
|
|
|
|
|
|
|
