Monday, July 28, 2014

How To Working with Database Objects in Access 2003

How To Working with Database Objects in Access 2003

The Database window is the container for all the objects in a database, including tables, forms, reports, queries, pages, macros, and modules. These database objects work together to help you store and manage your data. Objects are organized by object type on the Objects bar. You can open, group, rename, and delete database objects from the Database window. You can use the Open button in the Database window to view and enter object data, and the Design button to create the layout for the object data.

Open and View a Database Object

graphics/1_icon.jpg
If necessary, click the Objects bar in the Database window.
graphics/2_icon.jpg
Click the object type icon on the Objects bar.
graphics/3_icon.jpg
Click the object you want to open.
graphics/4_icon.jpg
Click the Open button on the Database window toolbar to view the object's data, or click the Design button to work with the object's design.
graphics/5_icon.jpg
To close the object, click the Close button in the upper-right corner of the Object window.
graphics/02inf04.jpg

Manage Database Objects

  • To create a new object, click the type of object you want to create on the Objects bar, and then click the New button on the Database window toolbar.
  • To delete an object, right-click it in the Object list, and then click Delete.
  • To rename a database object, right-click the object in the Object list, click Rename, and then type a new name.
  • To change the Database view of the objects, click the Large Icons, Small Icons, List, or Details button on the Database window toolbar.
    graphics/02inf05.jpg

Did You Know?

You can use AutoCorrect to rename objects. When you rename a database object, you don't have to worry about other Access objects that use the object you just renamed. The Name AutoCorrect feature automatically fixes common side effects that occur when a user makes name changes. Click the Tools menu, click Options, click the General tab, and then work with the Name AutoCorrect settings to enable this feature.