Can Access 2007 link information from one template to another?

[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!

 

[Jeff Boyce]

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