|
|
|
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 |
|
|
| |
| 26) Now, add the additional fields (those related to the TypeId, AreaId and ThemeId keys) by clicking in
AreaName from Areas table, TypeName from FileTypes table and Themename from Themes
table. |
| |
|
| Illustration 14: You added the related table's fields. Click here to view larger image. |
| |
| 27) Right click on Query1 name and select the SAVE menu item. |
| |
|
| Illustration 15: Save the query. Click here to view larger image. |
| |
| 28) Now set a name to the query and save. |
| |
|
| Illustration 16: Set the query name. |
| |
| 29) Select the Run command to view the query's results. |
| |
|
| Illustration 17: Run the query. Click here to view larger image. |
| |
| 30) Access 2007 will take each related field from related tables using the relational model data retrieval theory. |
| |
|
| Illustration 18: Query Results. |
| |
| If you try to change any related field (like AreaName, ThemeName or TypeName) all instances of these fields
will be changed. For example if you change the value "SCM" at the ThemeName in the first row, all instances of this field will be changed
automatically in the query and the base table (Themes) will be changed too. |
| |
|
| Illustration 19: Changing a related field will affect all instances of this field and the base table. |
| |
| 31) Now you will create a crosstab query. Select the Simple Query wizard Option and press OK button. |
| |
|
|
| |
|
|
|
|
|
|
|
|
|
