[vicsireland] Re: Using sql with jaws 8
- From: "Cearbhall O'Meadhra " <cearbhall.omeadhra@xxxxxxx>
- To: <vicsireland@xxxxxxxxxxxxx>
- Date: Thu, 10 Sep 2009 13:16:34 +0100
Mairead and Tony,
I am currently managing an MS Access database and so I can refresh your
memory!
The Access screen opens with a list view showing the tables you have
created with some wizards to help you to create new tables. Below this list
is a series of seven buttons which you can move through using the right and
left arrow keys. To get to the list of buttons is one stroke of the tab key.
Like the Table view, the query window opens with a list view showing all the
queries that you have created. Since you will have no queries at this stage,
the list view shows only two wizards: "Create query in design view" and
"Create query by using wizard". The second wizard is not accessible to JAWS
so I always ignore it.
To create a new query use the first wizard i.e. "create query in design
view". This opens with an inaccessible GUI and we cannot use it. JAWS can
only spot confusing fragments of the screen. Pressing escape will stop the
wizard. Ignore the screen display for the moment as you will not be using
this interface. Open the main menu. A few strokes of the right arrow will
bring up the View menu. The first item is "Design View" and is checked
because that is the view that is currently open. One down arrow shows "SQL"
and this is what you want. Pressing entry on SQL opens the SQL editor where
you can type your code. This editor is a little like a bad wiki editor. It
works most of the time but JAWS can lose it some of the time. For
consistency, I find it best to write a query in notepad so that the text is
in clean ASCII code with no strange characters. I then copy the completed
script into the query editor. This can be done as often as you like until
the query is running correctly.
To run the query in SQL view, open the main menu and arrow right until you
find the "query" menu where the first item is "run". Pressing this runs the
query for you. The system messages about success or any errors encountered
are reasonably accessible. I also find the online help for queries very
useful.
Like Tony, I find that I forget this routine when I leave MS Access for a
while. However, I do enjoy working with it as you can do great things with
the queries.
All the best,
Cearbhall
Meeting the Leadership Challenge
T:(01) 2864623 M: 083 33 234 87 E: cearbhall.omeadhra@xxxxxxx
-----Original Message-----
From: vicsireland-bounce@xxxxxxxxxxxxx
[mailto:vicsireland-bounce@xxxxxxxxxxxxx] On Behalf Of Tony.G.Murray@xxxxxx
Sent: 10 September 2009 09:55
To: vicsireland@xxxxxxxxxxxxx
Subject: [vicsireland] Re: Using sql with jaws 8
Hi Mairead,
Microsoft Access is a nice place to start. It is a friendly self contained
little Relational Database Management System.
Microsoft Access (and most other Relational DBMS') are made up of similar
concepts. In my original mail, when I discussed Microsoft SQL Server I
described the two main ways of manipulating the Database and it's contents;
through SQL, and with the visual tools. Well, with Microsoft Access the
same rules apply. The tools just have different names! In addition, there
are all manner of friendly little Wizards which help you to create Queries,
just like that.
The following is from memory... and a pretty sozzled one at that. Things
have a habit of changing names down the years and the versions, but I reckon
the concepts are largely the same.
As far as I know in Microsoft Access you can type SQL Code in to the 'Query
View'. This is equivalent to the 'Query Analyser' I described in Microsoft
SQL Server. It is basically a text editor so it is easy to use with Jaws.
There'll be a run button somewhere, and maybe even a 'Parse'
button which will check your SQL Code for errors... Always handy!
The equivalent Visual Tool in Microsoft Access is called something like the
'Query Design Grid'. This could produce a challenge or two with Jaws, I am
not sure. It's been many years since I've even seen an Access Database. I
guess things like your Jaws Version and the version of Access you're using
will play a part here. In the good old days when I used Access I had no
problem with the Query Design View. Unfortunately, that is all I remember,
aside from the fact that there were many helpful Wizards available to speed
things up. In addition, there are bound to be Jaws Scripts out there to
further simplify the Query Design View in Access, maybe these were the ones
you spoke about originally?
However, the brilliant news is, that if you are good with SQL Programming,
you probably won't have to use the Visual Tools; everything you can do by
dragging and dropping etc can be achieved through good old fashioned raw SQL
Code typed in to the Query View as described above.
There are lots of different sources online to learn basic SQL Programming,
so it might be an idea for you to get a step ahead of the game before
starting the module.
Best wishes,
Tony Murray
Internet Solutions,
AIB Enterprise Systems & Technology,
Block B0,
AIB Bankcentre,
Ballsbridge,
Dublin 4.
T: +353 (0) 164 13801
E: tony.g.murray@xxxxxx
Mairead O Mahony <maireadomahony@xxxxxxxxx> Sent by:
vicsireland-bounce@xxxxxxxxxxxxx
09/09/2009 20:01
Please respond to vicsireland
To: vicsireland@xxxxxxxxxxxxx
cc:
Subject: [vicsireland] Re: Using sql with jaws 8
Hi all
Thanks to everyone who replied to my email about using sql with jaws.
At the moment I am checking out what Gui we will be using. As far as I am
aware we will be using Sql with Microsoft access but I need to get that
confirmed. Any other suggestions are greatly appreciated.
Thanks in advance
Mairead
On 9/9/09, Tony.G.Murray@xxxxxx <Tony.G.Murray@xxxxxx> wrote:
> Hi Mairead,
>
> "I am using jaws 8 and would appreciate it if anyone could let me know
for
> definit if sql works with jaws. "
>
> SQL (Structured Query Language) is a computer language used for
> manipulating relational Databases and their contents. Like a lot of
> computer programming languages, it is simply text which is interpreted
by
> the machine. So in that sense, yes SQL definitely works with Jaws.
>
> Now then, SQL is often used in conjunction with a relational DBMS
> (Database Management System), which is basically an environment in
> which your relational database and the tools you use to manage/access
> it are living. There are lots of very widely used DBMS', like Oracle,
> SQL Server, MySQL, the list goes on and on and on. A lesser DBMS is
> Microsoft's Access, but this wouldn't be considered an enterprise
> DBMS;
it
> is limited in the data it can store. It's a nice way to learn
Relational
> Database methodologies etc, and is probably used behind some smaller
> web applications or in small office environments, but that's about it.
>
> When you say 'SQL' could you possibly be referring to SQL Server? This
is
> Microsoft's bigger DBMS, which is often just called 'SQL'. This is a
> pretty crazy way to refer to something like SQL Server, but that's
> unfortunately computing... init! For the rest of this mail, when I say
SQL
> I mean the computer language, and when I say SQL Server, I mean...
you've
> guessed it, SQL Server the Relational Database Management System!
>
> If you are indeed talking about Microsoft SQL Server, the news is good.
> I've used SQL Server 97/2000/2005 in my time. The SQL Server Tools
(which
> are part of the DBMS) allow you to do everything you could possibly
> want to do with a Database, or the data stored within one.
>
> There are two major ways of accessing the Microsoft SQL Server Database.
> One is through SQL (and I mean the computer language remember), and
> the other is through a visual interface.
>
> SQL can be typed out in an editor provided as part of SQL Server, and
> executed against your database. This is very very accessible and easy
to
> use... AS easy as Notepad! The editor contained within SQL Server to
> do this is called 'Query Analyser', or something similar depending on
> the version of SQL Server you're using.
>
> The other way is through the visual tool, called 'Enterprise Manager'
> or 'Management Studio', again depending on the version of SQL Server
> you're working with. This allows you to do everything you can do
> through SQL
and
> more, without having to actually know the language. It too is pretty
> accessible, when you get to know the environment. It's mainly tree
views,
> lists, menus... All the normal stuff Microsoft has got us all so used
to.
>
> "I would also appreciate it if someone could let me know if I need to
> download scripts to increase the functionality
of
> Sql."
>
> To be honest, I didn't know there were scripts available... but that's
no
> surprise! I'm not so well up on Jaws, even though I use it every day.
> If there are scripts available, and you are talking about SQL Server,
> I'm sure someone on here can help you to install them.
>
> All the above assumes that when you say 'SQL', you mean Microsoft's
> SQL Server. However, if you're not talking about SQL Server, I think
> you'll be safe enough when it comes to programming in SQL (the
> language). Once you know how to write SQL, you'll be able to access
> and use most Relational DBMS', like Oracle, Microsoft SQL Server, MySQL,
all those.
SQL
> is simply a language used to access all sorts of relational databases...
> Kind of like a skeleton key! You can get in to any relational database
if
> you've a bit of SQL knowledge. Beautiful huh?
>
> To finish, I'll say that SQL is a nice language to learn. It looks
> very much like English; it is based on a bunch of keywords, some
> logical operators, and that's about it.
>
> For example, let's say you have a table in your database called
> UserInformationTable containing names and addresses.... The SQL to
> show you all the names in that table might look something like:
> SELECT FirstName, LastName FROM UserInformationTable;
>
> Not bad eh?
>
> Best wishes,
>
> Tony Murray
>
> Internet Solutions,
> AIB Enterprise Systems & Technology,
> Block B0,
> AIB Bankcentre,
> Ballsbridge,
> Dublin 4.
>
> T: +353 (0) 164 13801
> E: tony.g.murray@xxxxxx
>
> ===========================================================
> The vicsireland mailing list
>
> To unsubscribe at any time send a mail to:
>
> vicsireland-request@xxxxxxxxxxxxx
>
> with the word "unsubscribe", without the quotes in the subject of the
> message.
>
> To contact the moderator send mail to:
>
> tim.j.culhane@xxxxxxxxx
>
> For mor information on the Visually Impaired Computer Society visit:
>
> http://www.vicsireland.org
>
>
===========================================================
The vicsireland mailing list
To unsubscribe at any time send a mail to:
vicsireland-request@xxxxxxxxxxxxx
with the word "unsubscribe", without the quotes in the subject of the
message.
To contact the moderator send mail to:
tim.j.culhane@xxxxxxxxx
For mor information on the Visually Impaired Computer Society visit:
http://www.vicsireland.org
******************************************************
This document is strictly confidential and is intended for use by the
addressee unless otherwise indicated.
This email has been scanned by an external email security system.
Allied Irish Banks
AIB and AIB Group are registered business names of Allied Irish Banks p.l.c.
Allied Irish Banks, p.l.c. is regulated by the Financial Regulator.
Registered Office: Bankcentre, Ballsbridge, Dublin 4. Tel: + 353 1 6600311;
Registered in Ireland: Registered No. 24173
Please consider the environment before printing this e-mail.
******************************************************
===========================================================
The vicsireland mailing list
To unsubscribe at any time send a mail to:
vicsireland-request@xxxxxxxxxxxxx
with the word "unsubscribe", without the quotes in the subject of the
message.
To contact the moderator send mail to:
tim.j.culhane@xxxxxxxxx
For mor information on the Visually Impaired Computer Society visit:
http://www.vicsireland.org
===========================================================
The vicsireland mailing list
To unsubscribe at any time send a mail to:
vicsireland-request@xxxxxxxxxxxxx
with the word "unsubscribe", without the quotes in the subject of the message.
To contact the moderator send mail to:
tim.j.culhane@xxxxxxxxx
For mor information on the Visually Impaired Computer Society visit:
http://www.vicsireland.org
Other related posts:
