Tips |

If you forget to designate a primary key for a table, Access will remind you the first time you save the table.  If you like, it will even create a primary key for you at that point.

 

Note |

In Access, column and field mean the same thing.

Note |

The design you worked through in Chapter 4 defines the TypeID field in the Types table as an AutoNumber primary key field.  However, that is not what actually happened because Access automatically assigns the Number data type to the TypeID field when the contents are numerical values.  This small deviation from the original plan is insignificant at this stage.

Tip |

Although Access lets you include spaces in field names, we recommend that you avoid this.  Using spaces makes working with some other parts of the product, such as queries, more difficult

 

Note |

When you resize a column, it effects only that column.  When you resize a row, the new size applies to all the rows in the table.

Tip |

Any changes you make to the former of a datasheet apply only to that datasheet.  If you make any changes, Access asks you whether to save those changes.

 

Tip |

Your AutoCorrect settings are shared across all the Microsoft Office products, so any customizations you make here apply to Word and Excel as well as to Access

 

Tip |

Access also supports an even more flexible filtering mode called Filter by Form, in which you can select the values by which to filter without needing to find them first.

 

Tip |

To change the data after you find it, select the Replace tab in the Find and Replace dialog box and enter the new value in the control that appears.  Access prompts you before making any data changes.