WebAIM - Web Accessibility In Mind

E-mail List Archives

Thread: Accessibility of Access Reports

for

Number of posts in this thread: 7 (In chronological order)

From: Krack, Joseph@DSS
Date: Wed, May 31 2017 2:56PM
Subject: Accessibility of Access Reports
No previous message | Next message →

Good afternoon group! I have a question about Access or more specifically about reports developed from Access. One of our divisions in our Department has an Access database out of which they develop pdf reports that they have been posting. They are not tagged and when Auto-tagging the report in Acrobat Pro there are problems. I don't have access to the Access database and so am not familiar with how they develop the report.

Is there a way they can export the data into a PDF format to create accessible reports? Is there another file format they can use in the export process (Word, Excel) that would be easier to create an accessible table/report?

I have not been able to find a lot of information about this online, and was hoping someone here may have experience working with Access and would possibly be able to help.

Thanks,

Joe

From: Krack, Joseph@DSS
Date: Wed, May 31 2017 3:46PM
Subject: Re: Accessibility of Access Reports
← Previous message | Next message →

What does this mean?? Can I post a question? Another colleague tried to post and was also not allowed. We are from the California Department of Social Services. Is there a problem with our email addresses? Please let me know.

Thanks,

Joe

-----Original Message-----
From: WebAIM-Forum [mailto: = EMAIL ADDRESS REMOVED = ] On Behalf Of Krack, Joseph@DSS
Sent: Wednesday, May 31, 2017 1:56 PM
To: = EMAIL ADDRESS REMOVED =
Subject: [WebAIM] Accessibility of Access Reports

[This sender failed our fraud detection checks and may not be who they appear to be. Learn about spoofing at http://aka.ms/LearnAboutSpoofing]

Good afternoon group! I have a question about Access or more specifically about reports developed from Access. One of our divisions in our Department has an Access database out of which they develop pdf reports that they have been posting. They are not tagged and when Auto-tagging the report in Acrobat Pro there are problems. I don't have access to the Access database and so am not familiar with how they develop the report.

Is there a way they can export the data into a PDF format to create accessible reports? Is there another file format they can use in the export process (Word, Excel) that would be easier to create an accessible table/report?

I have not been able to find a lot of information about this online, and was hoping someone here may have experience working with Access and would possibly be able to help.

Thanks,

Joe

From: Mallory
Date: Wed, May 31 2017 3:50PM
Subject: Re: Accessibility of Access Reports
← Previous message | Next message →

Dunno, your message made it through though.

On Wed, May 31, 2017, at 11:46 PM, Krack, Joseph@DSS wrote:
> What does this mean?? Can I post a question? Another colleague tried to
> post and was also not allowed. We are from the California Department of
> Social Services. Is there a problem with our email addresses? Please
> let me know.
>
> Thanks,
>
> Joe
>
> -----Original Message-----
> From: WebAIM-Forum [mailto: = EMAIL ADDRESS REMOVED = ] On
> Behalf Of Krack, Joseph@DSS
> Sent: Wednesday, May 31, 2017 1:56 PM
> To: = EMAIL ADDRESS REMOVED =
> Subject: [WebAIM] Accessibility of Access Reports
>
> [This sender failed our fraud detection checks and may not be who they
> appear to be. Learn about spoofing at http://aka.ms/LearnAboutSpoofing]
>
> Good afternoon group! I have a question about Access or more
> specifically about reports developed from Access. One of our divisions
> in our Department has an Access database out of which they develop pdf
> reports that they have been posting. They are not tagged and when
> Auto-tagging the report in Acrobat Pro there are problems. I don't have
> access to the Access database and so am not familiar with how they
> develop the report.
>
> Is there a way they can export the data into a PDF format to create
> accessible reports? Is there another file format they can use in the
> export process (Word, Excel) that would be easier to create an accessible
> table/report?
>
> I have not been able to find a lot of information about this online, and
> was hoping someone here may have experience working with Access and would
> possibly be able to help.
>
> Thanks,
>
> Joe
>
> > > at http://webaim.org/discussion/archives
> > > > >

From: Ryan E. Benson
Date: Wed, May 31 2017 3:51PM
Subject: Re: Accessibility of Access Reports
← Previous message | Next message →

> Is there a way they can export the data into a PDF format to create
accessible reports?


The last time I poked around the answer was no. If there is an update, I'd
love to know.

> Is there another file format they can use in the export process (Word,
Excel) that would be easier to create an accessible table/report?

My only suggestion is to take the PDF, save that as a Word doc - which you
can do in Acrobat Pro. Make that accessible, and convert that back to a PDF`

--
Ryan E. Benson

On Wed, May 31, 2017 at 4:56 PM, Krack, Joseph@DSS < = EMAIL ADDRESS REMOVED = >
wrote:

> Good afternoon group! I have a question about Access or more specifically
> about reports developed from Access. One of our divisions in our
> Department has an Access database out of which they develop pdf reports
> that they have been posting. They are not tagged and when Auto-tagging the
> report in Acrobat Pro there are problems. I don't have access to the
> Access database and so am not familiar with how they develop the report.
>
> Is there a way they can export the data into a PDF format to create
> accessible reports? Is there another file format they can use in the
> export process (Word, Excel) that would be easier to create an accessible
> table/report?
>
> I have not been able to find a lot of information about this online, and
> was hoping someone here may have experience working with Access and would
> possibly be able to help.
>
> Thanks,
>
> Joe
>
> > > > >

From: Chagnon | PubCom
Date: Wed, May 31 2017 4:42PM
Subject: Re: Accessibility of Access Reports
← Previous message | Next message →

Since a database is essentially a table of sorts, why not export it as an Excel spreadsheet? Then you'd have at least some basic core accessibility built into the spreadsheet's matrix of columns and rows.

If you export it as a PDF, you're asking the PDF to convert the data into an accessible table, which is not really feasible at this time. You could run the PDF through a tagging utility, such as Acrobat's built in tag utility or one of the third party programs that do this. But none of them accurately recognize and tag the table inside the PDF.

It's been a while since I was in Access and can't recall if it has an Acrobat Ribbon bar at the top which could help make a better PDF. File/Print to Adobe PDF is not the route to take because it makes a digital print version without any tagging or structure whatsoever. File/Save as PDF is a Microsoft utility that doesn't make an adequately accessible PDF either.

If you do discover that Access has the Adobe Acrobat Plug-in (indicated by it having an Acrobat ribbon bar), the play around with the Acrobat Preferences in the ribbon, check to tag it for accessible PDF, and see if that improves the final file.

--Bevi

- - -
Bevi Chagnon | www.PubCom.com
Technologists, Consultants, Trainers, Designers, and Developers
for publishing & communication
| Acrobat PDF | Print | EPUBS | Sec. 508 Accessibility |
- - -


-----Original Message-----
From: WebAIM-Forum [mailto: = EMAIL ADDRESS REMOVED = ] On Behalf Of Ryan E. Benson
Sent: Wednesday, May 31, 2017 5:51 PM
To: WebAIM Discussion List < = EMAIL ADDRESS REMOVED = >
Subject: Re: [WebAIM] Accessibility of Access Reports

> Is there a way they can export the data into a PDF format to create
accessible reports?


The last time I poked around the answer was no. If there is an update, I'd love to know.

> Is there another file format they can use in the export process (Word,
Excel) that would be easier to create an accessible table/report?

My only suggestion is to take the PDF, save that as a Word doc - which you can do in Acrobat Pro. Make that accessible, and convert that back to a PDF`

--
Ryan E. Benson

On Wed, May 31, 2017 at 4:56 PM, Krack, Joseph@DSS < = EMAIL ADDRESS REMOVED = >
wrote:

> Good afternoon group! I have a question about Access or more
> specifically about reports developed from Access. One of our
> divisions in our Department has an Access database out of which they
> develop pdf reports that they have been posting. They are not tagged
> and when Auto-tagging the report in Acrobat Pro there are problems. I
> don't have access to the Access database and so am not familiar with how they develop the report.
>
> Is there a way they can export the data into a PDF format to create
> accessible reports? Is there another file format they can use in the
> export process (Word, Excel) that would be easier to create an
> accessible table/report?
>
> I have not been able to find a lot of information about this online,
> and was hoping someone here may have experience working with Access
> and would possibly be able to help.
>
> Thanks,
>
> Joe

From: Meacham, Steve - FSA, Kansas City, MO
Date: Wed, May 31 2017 4:50PM
Subject: Re: Accessibility of Access Reports
← Previous message | Next message →

That message is because the WebAIM-Forum sends the email on behalf of somebody else; Joseph Krack in this case. It didn't come directly from Joseph. It came from WebAIM.

Your email service provider has a rule to look for this and warn you. This sort of thing has its legitimate uses, like here on WebAIM. It can also be abused (what can't!?). Thus the warning.

-----Original Message-----
From: WebAIM-Forum [mailto: = EMAIL ADDRESS REMOVED = ] On Behalf Of Mallory
Sent: Wednesday, May 31, 2017 4:51 PM
To: WebAIM Discussion List < = EMAIL ADDRESS REMOVED = >
Subject: Re: [WebAIM] Accessibility of Access Reports

Dunno, your message made it through though.

On Wed, May 31, 2017, at 11:46 PM, Krack, Joseph@DSS wrote:
> What does this mean?? Can I post a question? Another colleague tried
> to post and was also not allowed. We are from the California
> Department of Social Services. Is there a problem with our email
> addresses? Please let me know.
>
> Thanks,
>
> Joe
>
> -----Original Message-----
> From: WebAIM-Forum [mailto: = EMAIL ADDRESS REMOVED = ] On
> Behalf Of Krack, Joseph@DSS
> Sent: Wednesday, May 31, 2017 1:56 PM
> To: = EMAIL ADDRESS REMOVED =
> Subject: [WebAIM] Accessibility of Access Reports
>
> [This sender failed our fraud detection checks and may not be who they
> appear to be. Learn about spoofing at
> http://aka.ms/LearnAboutSpoofing]
>
> Good afternoon group! I have a question about Access or more
> specifically about reports developed from Access. One of our
> divisions in our Department has an Access database out of which they
> develop pdf reports that they have been posting. They are not tagged
> and when Auto-tagging the report in Acrobat Pro there are problems. I
> don't have access to the Access database and so am not familiar with
> how they develop the report.
>
> Is there a way they can export the data into a PDF format to create
> accessible reports? Is there another file format they can use in the
> export process (Word, Excel) that would be easier to create an
> accessible table/report?
>
> I have not been able to find a lot of information about this online,
> and was hoping someone here may have experience working with Access
> and would possibly be able to help.
>
> Thanks,
>
> Joe
>
> > > archives at http://webaim.org/discussion/archives
> > > > archives at http://webaim.org/discussion/archives
> This electronic message contains information generated by the USDA solely for the intended recipients. Any unauthorized interception of this message or the use or disclosure of the information it contains may violate the law and subject the violator to civil or criminal penalties. If you believe you have received this message in error, please notify the sender and delete the email immediately.

From: JP Jamous
Date: Thu, Jun 01 2017 5:54AM
Subject: Re: Accessibility of Access Reports
← Previous message | No next message

I totally agree. I was thinking of that myself last night.

I have not touch Access in over 10 years, but exporting the MDB file to an XLS file should still be an option. From there, use Excel to handle any accessibility concerns. Excel can be quite accessible if you know its shortcuts and use it with JAWS. It will also allow you to tag PDF files as far as I know.

-----Original Message-----
From: WebAIM-Forum [mailto: = EMAIL ADDRESS REMOVED = ] On Behalf Of Chagnon | PubCom
Sent: Wednesday, May 31, 2017 5:42 PM
To: 'WebAIM Discussion List' < = EMAIL ADDRESS REMOVED = >
Subject: Re: [WebAIM] Accessibility of Access Reports

Since a database is essentially a table of sorts, why not export it as an Excel spreadsheet? Then you'd have at least some basic core accessibility built into the spreadsheet's matrix of columns and rows.

If you export it as a PDF, you're asking the PDF to convert the data into an accessible table, which is not really feasible at this time. You could run the PDF through a tagging utility, such as Acrobat's built in tag utility or one of the third party programs that do this. But none of them accurately recognize and tag the table inside the PDF.

It's been a while since I was in Access and can't recall if it has an Acrobat Ribbon bar at the top which could help make a better PDF. File/Print to Adobe PDF is not the route to take because it makes a digital print version without any tagging or structure whatsoever. File/Save as PDF is a Microsoft utility that doesn't make an adequately accessible PDF either.

If you do discover that Access has the Adobe Acrobat Plug-in (indicated by it having an Acrobat ribbon bar), the play around with the Acrobat Preferences in the ribbon, check to tag it for accessible PDF, and see if that improves the final file.

--Bevi

- - -
Bevi Chagnon | www.PubCom.com
Technologists, Consultants, Trainers, Designers, and Developers for publishing & communication
| Acrobat PDF | Print | EPUBS | Sec. 508 Accessibility |
- - -


-----Original Message-----
From: WebAIM-Forum [mailto: = EMAIL ADDRESS REMOVED = ] On Behalf Of Ryan E. Benson
Sent: Wednesday, May 31, 2017 5:51 PM
To: WebAIM Discussion List < = EMAIL ADDRESS REMOVED = >
Subject: Re: [WebAIM] Accessibility of Access Reports

> Is there a way they can export the data into a PDF format to create
accessible reports?


The last time I poked around the answer was no. If there is an update, I'd love to know.

> Is there another file format they can use in the export process (Word,
Excel) that would be easier to create an accessible table/report?

My only suggestion is to take the PDF, save that as a Word doc - which you can do in Acrobat Pro. Make that accessible, and convert that back to a PDF`

--
Ryan E. Benson

On Wed, May 31, 2017 at 4:56 PM, Krack, Joseph@DSS < = EMAIL ADDRESS REMOVED = >
wrote:

> Good afternoon group! I have a question about Access or more
> specifically about reports developed from Access. One of our
> divisions in our Department has an Access database out of which they
> develop pdf reports that they have been posting. They are not tagged
> and when Auto-tagging the report in Acrobat Pro there are problems. I
> don't have access to the Access database and so am not familiar with how they develop the report.
>
> Is there a way they can export the data into a PDF format to create
> accessible reports? Is there another file format they can use in the
> export process (Word, Excel) that would be easier to create an
> accessible table/report?
>
> I have not been able to find a lot of information about this online,
> and was hoping someone here may have experience working with Access
> and would possibly be able to help.
>
> Thanks,
>
> Joe