Need to create word documents for access data

[luminous]

Hi all. I am totally new to this, but good with computers.

I have an access database with about 25 fields of information inside. I need this database to create a standard set of word documents (about 10 different documents). Each document will make use of most of the information within the database.

Its nothing advanced, just name, address, DOB, that sort of thing to go into different standard format word documents.

Office 2010 is installed on our machines, including Access.

Ideally I would just like to press a button from within Access when on a specific record and it will just generate the batch of reports I am after.

Any ideas on how to get started please?

 

[PaulO]

In simplistic terms this sounds achieveable ... creating variable Queries based on multi-Table data with the subsequent output being converted to Word or even PDF output.

 

[luminous]

In simplistic terms this sounds achieveable ... creating variable Queries based on multi-Table data with the subsequent output being converted to Word or even PDF output.

Yes, that does sound logically what I am trying to do. Any advice on what the logical steps should be to achieve this? Conversion to PDF could be nice as well.

Basically I was meant to get some help to do this, but I have been dropped right in it, and have only a couple of days to get this totally sorted, tested, and working

 

[PaulO]

Basically I was meant to get some help to do this, but I have been dropped right in it, and have only a couple of days to get this totally sorted, tested, and working

Sounds like a normal project to me lol ...

I think, firstly, you need to determine what Tables you need to create. Once you populate the Tables with data you can then build the Queries and create/link Reports to the Queries.

 

[luminous]

OK, working on the tables at the moment. Should have that structure sorted soonish.

I don't think at present, there is any need to make reports. All the output that is required must be in the form of a word document. Different word documents will need different information within them. For example one document is a customer document, another is a letter to a supplier listing parts needed, another is a contract that has to be signed.

Once I get the tables made and linked, I think it may just be a case of getting that information into word with a push of a button....hmmm....

 

[luminous]

Reports all linked

Now, how do I make a word document from access.....time for googling