|
|
|
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 |
|
|
| |
| 8) Complete all required fields at the sheet bellow the field definition row. |
| |
|
| Illustration 6: Fill the description fields with the appropriate and more descriptive information. Click here to view larger image. |
| |
| 9) Fill the Fields properties sheets. |
| |
|
| Illustration 7: Fill the field's properties with the most adequate definition. Click here to view larger image. |
| |
|
| Illustration 8: BooId field properties. Click here to view larger image. |
| |
| 10) Create all required fields for the table. Select the format by opening the Format list. |
| |
|
| Illustration 9: Create all the fields. Click here to view larger image. |
| |
| 11) If the data will be unique for each field (usually the primary key candidate), set the Indexed option to yes (no duplicates). |
| |
|
| Illustration 10: The Yes (No duplicates) option permit the primary key definition. Click here to view larger image. |
| |
| 12) Also, if the field cannot be null, set the Required option to Yes. |
| |
| 13) Once you completed all required fields, save the table by clicking the table name tab. |
| |
| 14) Right click to display the context menu and Click on the Save menu item. |
| |
|
| Illustration 11: Save the table. Click here to view larger image. |
| |
| 15) Assign the table name and press on the OK button. |
| |
|
| Illustration 12: Book table will be saved. Click here to view larger image. |
| |
|
|
| |
|
|
|
|
|
|
|
|
|
