Access Archon: Working with Word

A practical guide to the many options available to get Access data into your Word documents with instructions, working code, sample data and templates from the editor of Access Watch.  Second Edition.

  AN OFFICE-WATCH.com GUIDE  

by Helen Feddema - Editor of the Access Watch newsletter since 1999 and 'Access Archon'

Access Archon: Working with Word

Peek Inside

FAQ

Buy now

New! Buy with Google Checkout

Access Archon: Working with Word

* Access 2007
* Access 2003
* Access 2002 (XP)

 

Paypal is NOT the only option

We have other payment methods available at our online store.

 
Solution Graphics

"Thanks for a great book.  Most e-books are small, almost pamphlets but the Desktop Search Handbook is great value for over 60 pages of info"    - Greg H, Lincoln, Nebraska.

 

Access Archon: Working with Word is the new e-book from the makers of Organizing Outlook Email and the Office Watch newsletters.

Buy now - click here

 

Access report features only go so far.  If you want to create elaborately formatted documents filled with Access data then you have to work with Word.

Helen Feddema, editor of Access Watch, shows you many different ways to put your Access data into Word documents.

There are four main methods of getting Access data into Word documents, Access Archon: Working with Word goes through all four of them discussing the advantages and disadvantages.

Separate chapters describe how to create Word documents filled with Access data using Word document properties, bookmarks, the TypeText method, mail merge and now also document properties.

There is also a discussion of using Word form fields (or, for Word 2007, content controls) to allow users entry of additional data into documents produced from Access and a technique for embedding templates in OLE Object or Attachment type fields is described, for an idiot-proof way of delivering Word templates for use in exporting Access data.

There’s even the possibility of user entry of more data on-the-fly, and especially if you want to produce separate documents to save in folders on your computer, the best method is to create Word documents from templates in VBA code, and fill them with data from Access.

Finally, Helen gives tips on debugging your VBA code.

The ebook comes with detailed examples, sample databases with working code and Word templates ready for you to use in your own projects.  Supplied files come in Office 2007 (.accdb/.dotx) and Office 2003/XP (.mdb/.dot) formats.

Compatibility:

  • Office 2007 – Access 2007 & Word 2007

  • Office 2003 – Access 2003 & Word 2003

  • Office XP – Access 2002 & Word 2002

Second edition:  A second edition is now available with all the content from the popular first edition plus new chapters and sample files about using document variables to insert data into Word documents.  Plus a technique for embedding templates in OLE Object or Attachment type fields is described, for an idiot-proof way of delivering Word templates for use in exporting Access data.

The entire e-book plus is Available NOW.

Access Archon: Working with Word

 
 

»   Why an ebook? 
We like the feel of a paper book and, despite the hype, we don’t think paper pages are going anywhere.  But for topics like this, an electronic book is ideal.

Low cost – we can supply a comprehensive guide faster and for less cost than a paper book.

Adobe PDF’s offer features you can’t get in a paper book:

  • Immediate Searching – look for any text in the book in an instant.
  • ‘Clickable’ Table of Contents – click on any heading in the contents list and you’ll jump right to that page.
  • Bookmark Tree – open the bookmarks pane to see the whole book in outline form (like the Document Map in Word.
  • Resizing.  You can change the Zoom setting in Acrobat Reader to make the text larger and easier to read.
  • Portability – take the ebook on your notebook computer without adding extra weight to carry around.
  • Color - all examples and screen images are in full color.
  • Web links - just click on a link in the book and it'll open in your browser.  No need to retype links from a paper page.
  • Copy Code - all the VBA code in the ebook can be copied into your projects - no re-typing.
  • Examples 'ready to run' - the example database and templates are supplied with the ebook, no extra charge, for you to use right away
  • Printing - unlike many ebooks we give you the option to print out pages.  We don't suggest that you print the entire ebook, just any pages or chapters you wish.


»    How much? 
Access Archon: Working with Word is available in US Dollars pricing and other currencies.   Click here for details

Subscriber Discounts

Subscribers to any of the Office-Watch.com newsletters get a discount on the regular purchase price.   Click here for details

Access Archon: Working with Word is in PDF format, approx 8.5MB, personalized for each buyer.