|
|
|
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 |
|
|
| |
| Create Queries |
| |
| Queries are those that truly make the work in a data base. They can make several different functions. Its function commonest is to recover specific
data of the tables. The data that wish to see usually are distributed by several tables and, thanks to the queries; you can see them in a single data sheet.
In addition, since normally you do not wish to see all the records simultaneously, the queries allow you to add criteria for "filtering" the data until
obtaining the whished records. The queries often serve as origin of registries for forms and reports. |
| |
| Some queries are "updatable", which means that it is possible to edit the data of the table's through query's datasheet. If it works with an
updateable query, remember that the changes also take place in the tables, no only in the query's datasheet. There are two basic types of queries: those of
selection and those of action. A selection query simply recovers the data and causes that it become available for
his use. The results of the query can be seen in the screen, be printed or be copied to the paper holder. Or can be used like data source for forms or
reports. |
| |
| An action query, as its name indicates, makes a task with the data. The action queries can serve to create new tables, to add data to existing
tables, to update data or to eliminate data. |
| |
| 15) Open TutorialDb. |
| |
| 16) Select the Create tab on Options Tape and select the Query Wizard command. |
| |
|
| Illustration 6: Create a query. Click here to view larger image. |
| |
| 17) Select the Simple Query wizard Option and press OK button. |
| |
|
| Illustration 7: Simple query wizard. |
| |
| Open a database through Microsoft Office Access button |
| |
| 18) Select the Files table from Table / Queries list. Then select Filename, Comments and
Directory fields from the Available Fields list. |
| |
|
| Illustration 8: Configure the query's fields. |
| |
|
|
| |
|
|
|
|
|
|
|
|
|
