BEGINNER NEEDING HELP!

[JUDY]

I think that Access is the program that has been used in
another office to merge information into leases and track
the leases by the person's name or property description
in each lease. The leases were entered and then the
information inserted as needed from the database. Am I
on the right track and how is this done?

Thanks for your help.

 

[John Nurick]

Hi Judy,

This is the kind of task that might well have been done in Access. It
needs a database consisting of at least two tables, one for Persons and
one for Leases (in practice, probably several others including one for
Properties), together with forms to enter and view the data. Then there
might be a Word template for each standard kind of lease, with
formfields where the name, property description, dates and so on need to
go, and VBA code in Access that fires up Word, creates a Word document
from the right template and fills in the formfields.

All this is straightforward for an experienced database developer but
it's not something Access does straight out of the box. The best thing
to do is probably to get hold of the other office's database (assuming
it's another office rather than another company). Otherwise, prepare
yourself to learn a bit about database design and programming<g>.