Access Database Contents to Word via Userforms

[Potemkin]

Dear VBA experts,

I have created a word template that loads a userform with multiple input boxes that then gets transferred to bookmarks.
The template is used to quickly draw up a budget proposal for a wedding (for a wedding coordinator). The form has fields for event name, couple details etc, as well as a form for budget figures.
What I want to do is to link this information to a database instead of typing in the information every time. What I want to know is:
1. How do I make the template automatically invoke the database (Access 2003)?
2. Is it possible to link the document to an offsite database on a ftp server?
3. Can I update the database from the userforms in word, rather than forms in Access?

PS: If I need to use some other type of database such as a SQL database that would be fine.

Cheers!

[matthewspatrick]

Why not simply use Access forms?

[Potemkin]

I'll try that -
Can I export my Access database info to a word document (with the click of a button :) ), or do I need to use Access Reports?

I've attempted Access reports but find them a bit Greek.

[matthewspatrick]

You can use code to create a Word doc from Access. You could even export an Access report as an RTF file (although the formatting is not high fidelity).

[Potemkin]

Dear Matthewspatrick.

I will spend some time on this before posting again.
Thanks for the info!