[AccessD] VBA and SQL for Access

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