[vicsireland] Re: Using sql with jaws 8
- From: "Michael Lavin" <michael.lavin@xxxxxxxxxxxxxxx>
- To: vicsireland@xxxxxxxxxxxxx
- Date: Thu, 10 Sep 2009 11:50:47 +0100
Hello Mairead
To add to Tony's very good advice, have a look at the SQL tutorial on
http://www.threeschools.com
In fact anyone out there interested in skilling up on computer languages would
be well advised to have a look at this website - it's full of brilliant
tutorials.
Regards and good luck.
Michael
-----Original message-----
From: Tony.G.Murray@xxxxxx
Date: Thu, 10 Sep 2009 09:55:01 +0100
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:
