|
|
|
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 |
|
|
| |
| 16) Once saved, select the field that will act as the table primary key and press the Primary Key button on the Options Tape.
|
| |
|
| Illustration 13: Create the Primary Key over the field declared as auto number and for indexing without duplicates. Click here to view larger image. |
| |
| 17) Save the table. |
| |
| 18) Now, we are ready to fill create indexes. Press the Indexes button at the toolbar. |
| |
|
| Illustration 14: Open the Indexes Window. |
| |
| 19) The Indexes window will be displayed. |
| |
|
| Illustration 15: Index creation and / or modification. |
| |
| 20) As you see, when you create the primary key, an index was created for the table with the name PrimaryKey. Note that this index is primary and unique. |
| |
| 21) Now, click on the Books table name at the left pane. Right click to display the context menu and select the Open menu
item. |
| |
|
| Illustration 16: Open table for Data visualization and / or input. |
| |
|
|
| |
|
|
|
|
|
|
|
|
|
