Microsoft Office Tutorials and References
In Depth Information
Managing Database Objects
The Navigation Pane
Managing Database Objects
So far, you know how to open a table using the navigation pane. However, opening
tables isn’t all you can do with the navigation pane. You can actually perform three
more simple tasks with any database object that shows up in the navigation pane:
Rename it. Right-click the object, and then choose Rename. Type in the new
name, and then press Enter. Go this route if you decide your Dolls table would
be better off named DollsInMyWorldRenownedCollection.
Create a copy. Right-click the object, and then choose Copy. Right-click
anywhere in the navigation pane, and then choose Paste. Access prompts you to
supply the new copy’s name. The copy-an-object feature is useful if you want to
take an existing table and try redesigning it, but you’re not ready to remove the
original copy just yet.
Delete it. Right-click the object, and then choose Delete. Access asks you to
confirm this operation, because you can’t reverse it with the Undo command.
Access gives you a few more options for transferring database objects and tucking
them out of sight.
timesAVinG tip
Creating a Shortcut to a Table
You probably already know that you can place a
Windows shortcut on your desktop that points to your
database file. To do so, just right-click your desktop, choose
New➝Shortcut, and then follow the instructions to pick
your database file and choose a shortcut name. Now,
anytime you want to jump back into your database, you can
double-click your shortcut.
1. Resize the Access window so it doesn’t take up the
full screen, and then minimize any other programs.
This way, you can see the desktop behind Access,
which is essential for this trick.
2. Find the table you want to use in the navigation pane.
Drag this table out of Access and over the desktop.
3. Release the mouse button. Access creates a shortcut
with a name like “Shortcut to Dolls in Bobblehead.
accdb”. Double-click this shortcut to load the
Bobblehead database and to open a datasheet right away
for the Dolls table.
You probably don’t know that you can create a shortcut
that opens a database and navigates directly to a specific
table. In fact, this maneuver is even easier than creating a
plain-vanilla shortcut. Just follow these steps:
Search JabSto ::




Custom Search