To get information directly from formf fields, use the .Result property of
each form field.

ActiveDocument.FormFields("name").Result

You could build an array of all form fields:

Dim FFArray() As String
Dim mFormField As FormField
Dim i As Integer

On Error Resume Next
For Each mFormField in ActiveDocument.FormFields
  Redim Preserve FFArray(i)
  FFArray(i) = mFormField.Result
 i = i + 1
Next

Now you have an array of all form field results.  NOTE! you must do some
error trapping on this.  Do a check on the form field type.  The above
assumes all TEXT formf fields.

You can test form field types with the following constants.

text formfield Type = 70
checkbox form field Type = 71
dropdown form field Type = 83

Once you have the array of results, you can do what you like with the
information, including exporting the data to Access.