Red Box

Sign up now
for your FREE
Newsletter
"Tech-tips"
which reveals unusual computer
short cuts, tips, and tricks.
 


Dino’s technical tips and solutions.

 

 


About


Services

Tech Tips


Contact

 

 

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!


 




 

Stop: BACK UP!

Don't risk losing all of your data.
CLICK HERE
to find out about our BS solutions


STORAGE
SOLUTIONS

Need to simplify your data storage needs?
CLICK HERE
to find out how
.


 

 


All content © 2006 Red Box Computer solutions
(519) 851-9434