Happy Easter (for those who celebrate it),

I have a question on how to proceed with my education. Below are the primary issues I need to learn how to perform.

Final Objectives

1. Create structured fillable forms that are either filled out directly by the users or via userforms.
2. Some of the data will be in drop-down lists. The choices in these drop-down lists need to be derived from an external data source so that certain users can add/modify/delete the data. (Access database?)
3. Other drop-down lists content (choices) will be dependent on what item was selected in previous drop-down lists (on the same form).
4. The name of the document and its save location needs to be controlled without any user input (except to actually initiate the process).
5. Saved documents must be read-only.
6. Create a MS Word ribbon that lists all the forms the users can create so they can just click on the item and the process will begin.

That pretty much covers it. I already have a basic understanding of creating forms in MS Word using content controls (thanks to macropod, gmaxey and gmayor). My main issue seems to be finding information on accessing and modifying external data sources (i.e. MS Access db) in VBA.



What I am looking for is an online resource/tutorials on how to perform the items listed above (with primary emphasis on Item #2).


Any and all input is much appreciated.