[vicsireland] Re: Using sql with jaws 8
- From: Tony.G.Murray@xxxxxx
- To: vicsireland@xxxxxxxxxxxxx
- Date: Thu, 10 Sep 2009 09:55:01 +0100
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
Other related posts:
