Microsoft Office Tutorials and References
In Depth Information
AC 194
Access Chapter 3 Maintaining a Database
Additional Operations
Additional special operations include opening another database, closing a database
without exiting Access, and saving a database with another name. They also include deleting
a table (or other object) as well as renaming an object. Finally, you can change properties of
a table or other object, such as the object’s description.
When you open another database, Access automatically will close the database that
had been open. Before deleting or renaming an object, you should ensure that the object has
no dependent objects, that is, other objects that depend on the object you wish to delete.
The following steps describe how you could perform these operations.
T O O PEN A NOTHER D ATABASE
1. Click the Offi ce Button.
2. Click Open on the Offi ce Button menu.
3. Select the database to be opened.
4. Click the Open button.
T O C LOSE A D ATABASE WITHOUT E XITING A CCESS
1. Click the Offi ce Button.
2. Click Close Database on the Offi ce Button menu.
T O S AVE A D ATABASE WITH A NOTHER N AME
1. Click the Offi ce Button.
2. Point to Save As on the Offi ce Button menu.
3. Select the Desired format.
4. Enter a name and select a location for the new version.
5. Click the Save button.
T O C HECK FOR D EPENDENT O BJECTS
1. Ensure that the object you wish to check is selected.
2. Click Database Tools on the Ribbon to display the Database Tools tab.
3. Click the Object Dependencies button on the Database Tools tab.
4. Click the ‘Objects that depend on me’ option button to display any objects that depend
on the selected object.
T O D ELETE A T ABLE OR O THER O BJECT
1. Right-click the object.
2. Click Delete on the shortcut menu.
3. Click the Yes button in the Microsoft Offi ce Access dialog box.
T O R ENAME AN O BJECT
1. Right-click the object.
2. Click Rename on the shortcut menu.
3. Type the new name and press the ENTER key.
T O C HANGE O BJECT P ROPERTIES
1. Right-click the object.
Search JabSto ::




Custom Search