Can Access 2007 link information from one template to another?

  • Thread starter Thread starter MCourtney
  • Start date Start date
M

MCourtney

I have the need to capture a number of different types of informaiton.
Therefore, I will need to utilize a few different Access templates, such as
Event Management, Contact Management, Task Management and Inventory
Management. I need to know if information that will be captured in these
separate templates/databases can be link (relationship)?

Also, if I utilize a number of different business templates, can they all be
displayed on the home screen when I log on to Access? I would like them to
all be in one place to allow me to move from one template to another easily.

Thanks!
 
If you are saying that you will need the data associated with those various
templates/applications to be accessible from all of them, then how about if
you create a single back-end data file that contains all those tables/all
that data, and link to it from each of the "template" front-ends?

Templates are just that -- suggestions for a way to handle business needs.
You can create a single "front-end" that includes ALL the queries, forms,
reports, code, etc. from each of the "templates", plus a main menu form that
you add to gain access (sorry!) to each area of functionality.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top