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

Dear Mr. Vinson:

Thank you for your answers.

As for organization I have used the forms in the book to structure my
databases. I have used the 4 rules, (although I can only recall 3 off the top
of my head) to create my databases. I have worked through the examples and
seen the problems and there solving.

I am on the other hand very new at this.

What I want to do and why, is this;

I have a DB(Database) for the work preferences of my contacts, region skill
levels, management experience, all the variables that can affect suitability
for a job.

I have a DB for a persons personal information, contact etc.

I have the work preferences form in a sub form of the personal information
form for collecting info on the phone.

When I am asking people where they are interested in working in the USA I
usually get a response by region, but sometimes by state.

When I am going to be searching I am searching by state. So I need to know
who is interested in going to which state.

I do not want to manually fill out the state buttons (State and Region
buttons are tick boxes) if I do not have to. I want the state tick boxes to
automatically fill if the corresponding region is selected.

Light bulb, so what I want is an unbound control for the regions that
affects the states as I describe above. I need not record the region
information.
Unless I need it for something? And if I do it should be in a different DB.

As for my process I am trying to create my Access Database in shells like
Atlantis, I can not hope to try to create it all at once. I know I need to
learn more and as I go and hit problems like this, and I learn. I have
planned 15 DB but this is a long term project for me. I want to get up and
running some things that will be useful for me from day one and this is one
of them.

Thank you again for your help.
--
Anthony Williams
Histotech Exchange LLC
19 Whitmore St.
Lexington, VA 24450
anthony@xxxxxxxxxxxxxxxxxxxxx



"John W. Vinson" wrote:

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]

.