Key Points

• Access 2007 includes templates to help you quickly and easily create databases and tables.

• In Design view, you can modify any object you created manually or from a template.

• Rather than storing all information in one table, you can create different tables for each type of information, such as employee, customer, and supplier contact information, or book, video, and CD catalog information.

• Properties determine what data can be entered in a field, and how the data will look on the screen. In Design view, you can change some properties without affecting the data stored in the table; but changing some might affect the data, so you must exercise caution when modifying properties.

• You can adjust the structure of a table-by manipulating or hiding columns and rows-without affecting the data stored in the table.