a2965z-nonprofit at yahoo.com
a2965z-nonprofit at yahoo.com
Fri Mar 14 17:04:59 CDT 2008
I want to thank all of you for your responses to my search for VBA and SQL books. I'm excited about getting my head into these topics and my arms around a career move.
Thanks again,
Cynthia
----- Original Message ----
From: "accessd-request at databaseadvisors.com" <accessd-request at databaseadvisors.com>
To: accessd at databaseadvisors.com
Sent: Thursday, March 13, 2008 8:08:30 AM
Subject: AccessD Digest, Vol 61, Issue 24
Send AccessD mailing list submissions to
accessd at databaseadvisors.com
To subscribe or unsubscribe via the World Wide Web, visit
http://databaseadvisors.com/mailman/listinfo/accessd
or, via email, send a message with subject or body 'help' to
accessd-request at databaseadvisors.com
You can reach the person managing the list at
accessd-owner at databaseadvisors.com
When replying, please edit your Subject line so it is more specific
than "Re: Contents of AccessD digest..."
Today's Topics:
1. Re: VBA and SQL for Access (Susan Harkins)
2. Re: VBA and SQL for Access (Tesiny, Ed)
5. Re: VBA and SQL for Access (jwcolby)
7. Re: VBA and SQL for Access (Drew Wutka)
Message: 1
Date: Wed, 12 Mar 2008 14:05:23 -0400
From: "Susan Harkins" <ssharkins at gmail.com>
Subject: Re: [AccessD] VBA and SQL for Access
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Message-ID: <017c01c8846b$a9e651f0$4b3a8343 at SusanOne>
Content-Type: text/plain; format=flowed; charset="iso-8859-1";
reply-type=original
Okay, I'm going to step in now because nobody seems to really want to help
Cynthia with the problem she has at hand, which is learning VBA/SQL and
Access. She didn't ask about SQL Server or .NET -- she asked about Access.
I'm not fussing because I know you guys mean well, but let's give her the
help she asked for. :)
I generally don't do this, and I gave them all plenty of time, but Cynthia
try the following:
<http://www.amazon.com/SQL-Access-Susan-Sales-Harkins/dp/1893115305/ref=sr_1_1?ie=UTF8&s=books&qid=1205344838&sr=8-1>
I don't think you'll find a better SQL book than this one, although Martin's
half is almost obsolete now. :( But most of the information in that half
should still help you with SQL Server Express.
<http://www.amazon.com/Automating-Microsoft-Access-Business-Solutions/dp/0789732440/ref=sr_1_2?ie=UTF8&s=books&qid=1205344909&sr=1-2>
Before you purchase either, see if your library has them, just to make sure
they're really what you need. Also check out discount book stores, as
they're both old and liable to be on sale tables. The VBA book was written
before Access 2008. A lot of the code should still work, but the
instructions will be vastly different, so I wouldn't suggest this book for
2008.
Susan H.
> Cynthia,
>
> First, if you want to kick it up a notch, stop using
> Access for the data. Use SQL Server Express instead.
>
> Here are some Access VBA books:
>
>
> ISBN 0764559036
> ISBN 0782123244
> ISBN 0782140130
> ISBN 0764525883
> ISBN 047004702X
> ISBN 0789737310
>
> For SQL Server 2005, Inside SQL Server 2005: T-SQL Programming
> is a good place to start.
>
> Robert
>
> At 05:39 AM 3/12/2008, you wrote:
>>Date: Wed, 12 Mar 2008 04:07:56 -0500
>>From: "C \(Soucheray\) Reitzel" <ch.souch at yahoo.com>
>>Subject: [AccessD] VBA and SQL for Access
>>To: <accessd at databaseadvisors.com>
>>Message-ID: <00d501c88420$979c9360$88fea8c0 at GATEWAY>
>>Content-Type: text/plain; charset="us-ascii"
>>
>>Hi,
>>
>>I am wanting to kick my career up a notch by beefing up my knowledge of
>>SQL
>>and VBA for Access. Can anyone recommend any good how-to books for someone
>>with a base-line knowledge of programming and querying?
>>
>>Thanks,
>>
>>Cynthia
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
------------------------------
Message: 2
Date: Wed, 12 Mar 2008 14:15:54 -0400
From: "Tesiny, Ed" <EdTesiny at oasas.state.ny.us>
Subject: Re: [AccessD] VBA and SQL for Access
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Message-ID:
<F7F17F79CF2A60418DC957FA11069BC701550D2D at ALBMX2K3.rt.oasas.state.ny.us>
Content-Type: text/plain; charset="us-ascii"
Drew Wutka had a nice little 40+ page tutorial on his web site where you
could get your feet wet. Couldn't find a kink for you but maybe Drew
does. If not, I'll try to hunt it up.
Ed Tesiny
EdTesiny at oasas.state.ny.us
------------------------------
Message: 7
Date: Wed, 12 Mar 2008 15:30:06 -0500
From: "Drew Wutka" <DWUTKA at Marlow.com>
Subject: Re: [AccessD] VBA and SQL for Access
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Message-ID:
<A5615CBECEC42E4791D7A7C724E1E9B2010A1D21 at MIEXCH.marlow.ii-vi.net>
Content-Type: text/plain; charset="us-ascii"
http://www.marlow.com/VBA_Training.zip (Haven't had my website up in
years)
Drew
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tesiny, Ed
Sent: Wednesday, March 12, 2008 1:16 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] VBA and SQL for Access
Drew Wutka had a nice little 40+ page tutorial on his web site where you
could get your feet wet. Couldn't find a kink for you but maybe Drew
does. If not, I'll try to hunt it up.
Ed Tesiny
EdTesiny at oasas.state.ny.us