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
