Re: What is the name of the Language we are using & recommend book to

On Tue, 25 Mar 2008 16:24:00 -0700, TravelingHT
<akwillims75@xxxxxxxxxxx(stopthespamer)> wrote:

Dear All:

I need help figuring out what the hell I am trying to learn. Are we using
QSL or Microsoft SQL Server Data Engine or what.

I presume that QSL is a typo for SQL....

Access will let you connect to the JET database engine, its default; to
SQL/Server databases, if you have a SQL/Server database installed (and you can
install SQL Express if you wish); or to other DBMS's such as MySQL or Oracle.

A native Access .mdb file without links to some external database supports two
languages: SQL - the Microsoft JET dialect of Structured Query Language, which
is a bit different from SQL/Server's or Oracle's or MySQL's dialect; and quite
separately, VBA, also known as Visual Basic for Applications. SQL is the
language of queries, and the query design grid is just a tool to construct
SQL; VBA is the language of Modules.

I obviously need to get a book to learn this stuff can you recommend me a
book on the language?

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

I have gone through Access 2003 Inside Out to the point I can make and
connect Simple Database and Crate forms, sub forms and Queries.

I have a form, with check boxes for each region and in addition I have a
check box for each state. I want for the related states in a region to be
checked automatically if the region check box is checked.

Well... STOP.

It sounds like you started the design with the form, and are working backwards
to designing the tables. Tables are FUNDAMENTAL. If your table has 50 yes/no
fields named Alabama, Alaska, etc. you are very much *on the wrong track*.
What is the structure of your table, or tables? How are you storing the region
and state information? --

John W. Vinson [MVP]
.

Relevant Pages

  • Re: Another idea from pick goes mainstream...
    ... A relational database has nothing to do ... SQL is one of the ... is now considered THE language for any dbms implementing the relational ... Then, XML came out. ...
    (comp.databases.pick)
  • Re: If you were developing a database in Forth...
    ... instances of SQL server. ... relational database well is a difficult task. ... free to come up with your own query language philosophy/design. ...
    (comp.lang.forth)
  • Re: What is the name of the Language we are using & recommend book
    ... Can I have 2 sub forms in a form that are not sub forms of the other sub ... As for my process I am trying to create my Access Database in shells like ... QSL or Microsoft SQL Server Data Engine or what. ... language of queries, and the query design grid is just a tool to construct ...
    (microsoft.public.access.formscoding)
  • Re: Do you use PL/SQL
    ... SQL over C++ or Java are very little. ... - JDBC is not a programming language. ... Leave in the database what the database is good at. ...
    (comp.databases.oracle.server)
  • Re: Problems with querying date field
    ... the internal SQL datatypes are converted into host language ... A database is language or anything else-independent so long as you don't ... hard-pressed to do it in a way that is independent of the particular SQL ...
    (microsoft.public.sqlserver.programming)