Key Points

  • Microsoft Office Access 2003 includes wizards to help you quickly and easily create databases and their objects, such as tables, queries, forms and reports.

  • In Design view, you can modify any object you created with a wizard.

  • Rather than storing all information in one table, you can create several different tables for each specific type of information, such as employee contact information, customer contact information, and supplier contact 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.

  • When you create a table in Access, you can apply one or more smart tags to each field. When information from that field is displayed in a table, form, or query, and the mouse pointer is moved over the text, the Smart Tag Action button is displayed and some action can be taken that is appropriate for the kind of information.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset