|
|
Most people have a database. Some of us have
more than one and it can be confusing and time consuming
to figure out which one to use. First of all, you want to
make sure they are appropriately named. Keeping them in
a logical place to the user of the database is important
too. Once you have these two items in order, consider the
following for your Microsoft Access databases:
Create an index to make managing or finding a particular
database easier. There are several ways you could do this.
The following example uses Access.
- Start a new database
- Start a new form
- In Design View, press Ctrl-K and the 'Insert Hyperlink'
dialogue box will appear
- Browse to find one of your databases and single click
on the database name
- The path and filename will be placed in both the 'Text
to
- Display' field and the 'Address' field
- Change the 'Text to Display' to something more meaningful,
i.e. Month-end Reporting
- Click OK and the hyperlink will appear on your form
- Move and format it as you wish
- Repeat these steps until you have all your databases
listed on the form
- Save the form
- Click on the Tools menu and then Startup
- In the Display Form/Page combo box, select your form
to make it open automatically whenever you open this database
If you create a shortcut to this new database on your desktop
(or anyone else you would like to have access to it) you
can quickly open any database from within your Index Database.
Happy data to you!
|
|
|