Microsoft Access 2003 for the Technology Instructor’s Soul Corinne Hoisington Understanding what’s new for you… and for your students
New Look for Access • Energetic new look • New task panes include Getting Started, Help, Search Results, and Object Dependencies.
Open a Table in Design View and click on the new Smart Tags properties box. Now open the table and click on the smart tag next to the field set. New Smart Tags
In Microsoft Office Access 2003, you can use the SmartTags property to add a smart tag to any field in a table, query, form, report, or data access page in a database. More Smart Tags
Propagating Field Properties • In older versions if you changed a field’s inherited property, you had to change all the other properties by hand. • If you modify an inherited field property in Table design view, Access displays an option to update the property
Backing Up a Database • You can back up a database to an alternate location and a different name • You can restore a database from the backed up copy if the medium on which you stored the original database gets corrupted
Object Dependencies • If you click on View, Object Dependencies you are able to see if a particular form is dependent on a table. • The following illustration shows the objects use the Quarterly Orders query, and also the tables and queries that the query uses.
Checking for Errors • Green Triangles are error checking options • Can occur with keyboard shortcut errors • Can occur with report is wider than paper • Can occur when a label is not associated with an control