1. Excel Accessibility Issues

Office for Mac.Before generating your PDF, run the to make sure your document is easy for people of all abilities to access and edit.Select File Save As (or press Command+Shift+S), type the file name in the Save As text box, and then choose where you want the file to be saved.In the Save As dialog, go to the File Format drop down box. Use the Down Arrow to browse through file types, and select PDF.Select the radio button 'Best for electronic distribution and accessibility (uses Microsoft online service).' This ensures the PDF is tagged.Select Save. Office for web.Before generating your PDF, run the to make sure your document is easy for people of all abilities to access and edit.On the ribbon, select the File button.Select the Save As option.In the Save As pane, select Download as PDF to open the Microsoft Word for the web dialog box. You'll see a link to download your PDF document.Select Click here to view the PDF of your document and then press Enter.In the notification panel, find the name of your document under Current downloads, and do one of the following:.To save in the default location, choose Save.To save in a different location, press Save As. In the Save As dialog box, you can type a new file name and choose the folder you want.

Click the Save button.If you want to open the document or the folder, choose the option you want in the notification bar.

Adobe Acrobat Pro DC form creation tools make it simple to create interactive form fields that are accessible to users with disabilities, including those with visual impairments and mobility impairments. This is typically achieved by adding properly structured fillable fields to the PDF file, setting a tab order to control a logical sequence, and by adding tooltips to fields providing an accessible label and instructions to users of assistive technology.To determine if a PDF document should be an interactive form, examine the file for the presence of form fields, or areas in the document where users are asked to provide information that you would like to collect.

If the form contains these qualities, the document can be made electronically fillable, allowing users to complete the form online. Many people with disabilities can fill out electronic forms unassisted, which is a huge advantage over print forms. An accessible electronic form can provide privacy, security, and independence to users with disabilities. Note: These must be provided in a way that is available to all users, including those using assistive technology. For example, using the Tooltip property value, it is possible to add text to a check box on an RSVP that users can use to indicate their intention to attend an awards dinner. The tooltip could be set to “I plan to attend the awards dinner” which will be announced to someone who is blind or visually impaired via a screen reader. When form objects are used in Acrobat, the object’s type (such as Check Box), and state (checked or unchecked) will also be exposed to assistive technologies.

This document describes the various types of form objects and provides implementation strategies for accessibility in electronic forms. A PDF form created with Adobe Acrobat Pro DC’s forms editing tools can contain the following types of fields:.

Text Field: Allows the user to type in text, such as name, address, or phone number. Check Box: Presents yes-or-no choices for individual items. If the form contains multiple check boxes, the user can typically select as many or few of these as needed.

Radio Button: Presents a group of choices from which the user can select only one item from the group. All radio buttons with the same name work together as a group. List Box: Displays a list of options the user can select.

List boxes have a field property that lets the user Shift-click or Control-click to select multiple items on the list. Combo Box: Allows the user either choose an item from a pop-up menu or type in a value.

Button: Initiates a change on the user’s computer, such as opening a file, playing a sound, or submitting data to a web server. These buttons can be customized with images, text, and visual changes triggered by mouse actions. Action buttons are different from radio buttons, which represent data choices made by the user. Digital Signature Field: Allows the user to electronically sign a PDF document with a digital signature.

Barcode: Encodes the input form selected fields and displays it as a visual pattern that can be interpreted by decoding software or hardware (available separately). The Prepare Form Wizard in Adobe Acrobat Pro DC can be used to create interactive forms from an existing electronic document (for example a Word, PDF, or Excel document) or from a paper form that was placed in a scanner with the resulting image opened in Acrobat. Authors can also create forms manually in Acrobat, or individually add form fields to an existing document using the form tools.Acrobat’s automatic form field detection will attempt to locate any labels that are adjacent to the form field (text, check box, etc.) and use any labels it finds as the source for the accessible label (the form field tooltip in Acrobat). A form element and form objects for each field will be created in the Tags pane as part of this process. Examine the document carefully to verify that Acrobat accurately detected the fields and labeled them properly.To make an electronic form fillable with the wizard start by selecting the Prepare Forms Wizard from the Tools pane.

(See “Figure 1. Prepare Form Wizard”) to open the Select a File and Scan a Document File to begin pane. (See “Figure 2. Select a File or Scan a Document File to begin”). In Forms Editing Mode, you can add, edit or delete any existing form object.The Acrobat Pro DC user interface changes when in Forms Editing Mode (Refer to “Figure 4. Form Editing Toolbar” on page 4). The Form Editing Toolbar appears and provides access to the Select Object tool, the Add New Field buttons for each field type, and the Form Preview button.

On the right hand side of the Forms Editing Toolbar, beneath the Preview button, the Distribute, Track, More, and other formatting commands are displayed. The Fields pane shows any interactive fields that are currently part of the form. You can exit this mode by selecting the Close Forms Editing button above the Preview button. Once a form tool has been selected, a crosshair cursor appears, and a blue region defines the outline of the form object selected for placement.

On the page, click where the field is to be added. A field with a default size.

To create a field using a custom size, drag a rectangle to set the dimensions of the field. In the Field Name box, type the name of the field. (See “Figure 6.

Field Name Box”). Select a name that is relevant and descriptive to make organizing and collecting the data easier. This name is not shown to users of the form. How a form field behaves is determined by settings in the Properties dialog box for that individual field. Properties can be set that apply formatting, determine how the form field information relates to other form fields, impose limitations on what the user can enter in the form field, trigger custom scripts, and so forth.To modify a field’s properties, right-click it (or select and then press the Application key).A variety of properties can be set for an Acrobat form field, depending on the form field type.

The properties for each type of form field are selected on a series of tabs. When a property is changed, it is applied as soon as another property is selected or when Enter is pressed.All form field types have a General tab, Appearance tab, and an Actions tab. Other tabs appear only in specific types of form fields. The Options tab appears for most form field types, but the options available are unique to each type of form field.You can leave the Properties dialog box open if you want to change multiple fields at once. The tooltip field on the General tab of the field properties dialog is the most important item for form fields.

The content of the tooltip will be announced by screen readers as the accessible name of the field. This property provides the user with information and instructions about the field. Tooltips should be short and descriptive and should not include the type of field or text such as “Click to enter”. For example, “First Name” would be a good tooltip for a first name field and “Sign-up Date (2 digit month / 2 digit day / 4 digit year) would be a good name for a “Sign up date” field that had a required field format. The City field for a group of shipping field would need to include the group name as well as the on-screen label, “Ship to City” or “Shipping Address City”. (Refer to “Figure 7.

Set Name and Tooltip Value for Form Field”). To set the tooltip property of a form field:. Ensure that the Select Object tool is selected from the toolbar. Open the field properties dialog. Double-click a selected form field; or. Right click or select and press the applications key and select properties; or.

Select the desired field and press the shortcut keystroke (Control+I). Enter a short and concise label into the tooltip field.The tooltip should provide any group label for a group of fields along with the field’s label (refer to the special instructions for radio button groups in the next section Tooltips for Radio Buttons). To create a radio button group, where only one field can be selected at a time, assign each field the same name and the same tooltip, but provide different Button Choices (values). The radio button choice is a field in the Options tab of the Radio Button Properties dialog.

The tooltip and button value will be announced to users of assistive technology for each radio button. When the same radio button name is assigned to a radio button, the tooltip field should automatically be populated with the tooltip text from the other radio buttons in the group. (Refer to “Figure 8. Setting Identical Name and Tool Tip Value for a Radio Button Group”).For example, create a radio button group that asks the question, “Address Type”.Create four radio buttons.

For each button, choose to give the button the identical name, “Address Type.” For each radio button, the identical text appears in the Tooltip field, such as “Address Type”. Acrobat form field properties can only be accessed in Prepare Forms mode. Properties for multiple form fields can be set at once. To edit multiple form fields, select the fields to edit. Hold down control and click each field to select. Right-click/Control-click one of the selected fields, and choose Properties.

Excel Accessibility Issues

Change the properties on each of the available tabs, as needed. The property is changed as soon as another property is selected or Enter is pressed. Activate the Close button or press enter to close the Properties dialog box.If form fields are selected that have different property values, some options in the Properties dialog box are not available. Otherwise, changes to the available options are applied to all selected form fields. There are many different actions that can be associated with a form field. These include actions based on mouse entry, mouse exit, mouse up, mouse down, on focus, and on blur.It is important to note that mouse-only actions will not be keyboard accessible.

All functionality must be keyboard-accessible without requiring the use of a mouse. The “on focus” and “on blur” actions are triggered when the field receives or loses focus respectively. These actions should be used with caution. The “on focus” action must not move focus to another field unless the field is not to be used, and these actions must not be used to trap the keyboard focus within certain fields.The user must be able to navigate past form fields without having the keyboard focus trapped. This is a requirement because many keyboard-only users, including users of assistive technology, use the Tab or Shift+Tab keystrokes to explore the fields of a form and discover what options are available. For the same reason, the option “Commit value immediately” should be avoided for the dropdown and list fields.

Users of assistive technology often use the Up and Down arrows to explore or navigate to items in these fields, so changing values using these keystrokes can prevent them from using the form properly. When form validation is used to automatically validate fields, error messages must indicate what fields triggered the error and provide suggestions to help the user enter the correct information. Error suggestions are not required when they would invalidate the purpose of the form, such as with a quiz. But error prevention must be provided for legal or financial transactions. Error prevention can involve allowing the user to review or make changes, and/or checking the information for errors prior to submission.

Typically, the Validation tab of the field properties dialog is used to provide feedback to the user. One accessible solution is to provide an alert that indicates the error and provides a suggestion. However, error-detection mechanisms should not restrict the ability for keyboard users to navigate among form fields.When audio is used to indicate an error such as entering more characters into a field than are allowed, a visual indication must also be provided to warn users who cannot hear the audio.

If a PDF document does not have a specified tab order, the default order is based on the document structure, unless the user has deselected the Tab Order option in the Accessibility preferences.The tab order can be changed after the form has been created. It has the following options:. If Forms Editing mode is active, the order can be set to document structure (default), row, or column. The order can also be set manually by dragging and dropping fields in the Fields pane. If Forms Editing mode is not active, the order can be set in page properties by row or column. However, the tab order cannot be set manually.To change the tab order, first select “Order Tabs Manually” from the Tab Order button on the Fields pane. Then fields can be dragged and dropped where appropriate within the Fields pane to modify the tab order (Refer to “Figure 10.

Rearranging Tab Order with the Fields Pane”). To assist in determining tab order, select “Show Tab Numbers” from the Tab Order button menu of the Fields pane (Refer to “Figure 10.

Rearranging Tab Order with the Fields Pane'). To see the relationship between items in the Fields pane and the Document pane.

Note also the Order Tabs Manually and the Show Tab Numbers options are highlighted. It is important to ensure that all form fields have instructions or labels. Form instructions are typically be placed above the form, call out required fields, and provide additional information on completing and submitting the form. Individual form fields typically have labels above or to the left of the form field, with the exception of radio buttons and checkboxes, whose labels should appear to the right of each field. Labels should contain any formatting information, such as value length or date format. In addition to making form fields accessible, other tags and properties must be set to improve overall accessibility.

For example, the default language of the document must be specified; security settings must not interfere with screen readers; links must be provided in a tagged and keyboard accessible manner; and the document must be tagged. This is not an exhaustive list of the tasks required before a form based document can be considered accessible or conformant to a specific accessibility standard or guideline. For a discussion on additional requirements including verifying conformance, refer to the.