[jawsscripts] Re: Creating accessible forms to manage databases in Microsoft Office 2007
- From: "Bryan Schulz" <b.schulz@xxxxxxxxxxxxx>
- To: <jawsscripts@xxxxxxxxxxxxx>
- Date: Mon, 24 Jan 2011 16:58:13 -0600
hi,
for free you can download and try visual basic or c++ 2008 or 2010.
you can design forms and use access on the back end.
Bryan Schulz
----- Original Message -----
From: "Graham Trevor" <grahamtrevor@xxxxxxxxxxx>
To: <jawsscripts@xxxxxxxxxxxxx>
Sent: Monday, January 24, 2011 1:25 PM
Subject: [jawsscripts] Re: Creating accessible forms to manage databases in
Microsoft Office 2007
> Hi Luciano,
>
> Two things to try.
>
> 1. I used to use a database called q & a, and found it easier than
> Access
> or Excel. Not sure what it's like these days or if it's still available.
>
> 2. Have you tried using Dreamweaver? You might be able to create nice
> looking, easy-to-use forms for both blind and sighted users and then
> import
> that into Access. Or build an intranet database using Dreamweaver and
> mysql.
>
> Been out of the loop for awhile, but I used to do lots with databases. So
> I'm sure there's a way somewhere. May be it's as simple as writing better
> scripts for Jaws to use Access.
>
> Good luck! Like the long message hope it's the right answer. I've never
> tried to answer before.
>
> If anyone else reads this this is a great source for learning how to use
> Jaws better.
>
> Graham
>
> ----- Original Message -----
> From: "luciano de souza" <luchyanus@xxxxxxxxx>
> To: <jawsscripts@xxxxxxxxxxxxx>
> Sent: Monday, January 24, 2011 10:09 PM
> Subject: [jawsscripts] Creating accessible forms to manage databases in
> Microsoft Office 2007
>
>
>> Hi all,
>>
>> I work in a management project area. It’s crucial to control several
>> structured information. I tried to do it with Excel. However, it’s not
>> easy to use
>> Excel with a database.
>>
>> My intention is to use Microsoft Access. The interface between Access
>> and JAWS is not perfect, but using Access 2003, I have created tables
>> easily with
>> SQL mode. It was really enthusiastic, however I could not create the
>> forms.
>>
>> Forms can be created with wizards, but there are two reasons why I
>> don’t want to use it:
>>
>> 1. I want to use VBA to validate the informed data and I desire
>> to customize some aspects to improve the navigation in the interface.
>>
>> 2. Wizards can create only simple forms from a single table.
>> It’s possible to create forms linking another forms.
>>
>> My question is: what is the best way to create forms with JAWS? I
>> consider the following hypothesis:
>>
>> 1. In Access, to create forms in the design mode, moving the
>> cursor to the control bar and trying to find and insert then in the
>> form. Long time ago,
>> a friend said me it’s possible to create forms using JAWS in Access.
>> However, my attempts was frustrated.
>>
>> 2. In Notepad, to create a HTML page and use it as a data access
>> page. When I heard about data access page, I thought the solution was
>> found. Only
>> typing some tags in a editor, I could create the interface.
>> Wonderfull? But, it doesn’t work. I could create the page, to import
>> it to Microsoft Access,
>> converting the page in HTML form available in Access. What was the
>> problem? I could create the form, but not to attribute callbacks to
>> the controls. For
>> example, I create a button called “send”. It should get the values of
>> the “name” field, “phone” field… and concatenate it in a sQL
>> instruction, allowing
>> the insertion of new records in the database, in other words, I needed
>> to attribute a macro or a VBA function to work as a callback of the
>> mentioned button.
>> Editing data access page in design mode, I can’t attribute functions
>> to controls.
>>
>> 3. In Excel, to create a form to get the data. I don’t use Excel
>> as a database. Since I was not able to create forms in Access, I try
>> to collect the
>> data in a Excel form. I wanted to get the data in Excel and
>> afterwards, to call Access with VBA, inserting records. I know, it’s a
>> very complicated way.
>> I would use Excel as interface and Access as database. Despite the
>> complexity, I tried it, but I was not successful. I opened VBA in
>> Excel environment
>> and I tried to create a new user form. The form is created, but it’s
>> not possible to attach controls to the form. As far as I could
>> observe, this task
>> is totally inaccessible for JAWS.
>>
>> 4. In VBA, to create the forms and their respective controls. Is
>> it possible? Yes, it’s possible, despite of the big complexity, it’s
>> possible. But,
>> if it solves a problem, unlikely it creates another. I want to create
>> the database. But I know, being blind, I can’t create beautiful
>> databases. If I am
>> able to create forms by the Access or Excel interface, the bad
>> positioned controls can be moved by a seeing person. My forms will be
>> awful, but with few
>> clicks, a seeing person could improve the the look. If I create the
>> form and the controls by code, it can’t be edited by a seeing person
>> because the controls
>> can’t be moved in the design mode. Therefore, I can’t follow this way.
>>
>> So, I ask if one of the solutions bellow are available:
>>
>> Solution 1: To create forms in Access without the wizard.
>>
>> Solution 2: To create a data access page in Access, attributing
>> functions to the controls.
>>
>> Solution 3: To create forms in Excel and link it to Access by means of
>> VBA.
>>
>> I could create it with Lua, Sqlite and IUP. For blinds, it’s really a
>> good combination among programming language, database and graphical
>> library. However,
>> I am in a company and I need to solve the problems with the tools
>> offered by the company. Unfortunately, Access and Excel are the single
>> alternative.
>>
>> Everything I described is based in Microsoft Office 2003. But I need
>> to solve my problem using the Microsoft Access 2007, Windows XP and
>> JAWS 11.01471.
>>
>> Is there a solution for my problem? Can I create databases with
>> Microsoft Office?
>>
>> This is my first message and it became really a long message!
>>
>> Best regards,
>>
>>
>> --
>> Luciano de Souza
>> __________�
>>
>> View the list's information and change your settings at
>> //www.freelists.org/list/jawsscripts
>>
>
> __________�
>
> View the list's information and change your settings at
> //www.freelists.org/list/jawsscripts
>
__________�
View the list's information and change your settings at
//www.freelists.org/list/jawsscripts
Other related posts:
