|
|
|
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 |
|
|
| |
| 11) When you close the datasheet view. A window asking for save changes will appear. |
| |
| 12) Open the Areas table in Design View. As you can see, this table does not have a Primary key. Select the AreaId
field and create a primary key. |
| |
|
| Illustration 5: Press the Primary key command to create the key. |
| |
| 13) Close the Design view window and try to save changes. |
| |
|
| Illustration 6: Press the YES button. |
| |
| 14) Close the Design view window and try to save changes. |
| |
|
| Illustration 7: Error message raised by the application. Click here to view larger image. |
| |
| This error message is indicating that there are duplicates keys for the field selected as Primary Key. As you can see at illustration 3, there are two
records with AreaId = 6. |
| |
| 15) Open the Areas table in datasheet view and change the AreaId field another value. |
| |
|
| Illustration 8: Select a non repeated value for the key. |
| |
| 16) Repeat the steps to create the primary key and save the changes. This time, you will not receive the error message. |
| |
| 17) Try to modify another record by changing the AreaId field and using a duplicated value. You will receive another error message. |
| |
|
| Illustration 9: When you try to insert a duplicated value in the key field, the error will be raised. Click here to view larger image. |
| |
|
|
| |
|
|
|
|
|
|
|
|
|
