Best Access Books?

[Tony]

I think I'm an intermediate to advanced level user, but I
need to know when to add indexes, when to base a report on
a table vs. a query (what are the pros and cons) or what
is the convention.

I do very little writing of code, but lots of queries of
all types (append, delete, make, crosstab) with some Iif
statements and calculations, and reports based on these.

I need to know more than just the "how to", I need to know
the why? My team deals with large db's (we do exceed
Access 97's limits of 1GB), so we've had to archive data.
I'd also like to learn about using SQL server instead of
the Jet engine.

Thanks in advance,
Tony

 

[Van T. Dinh]

The best Access book depends on the reader so you will have to settle for
the recommended lists and make your own decision.

See the recommended lists by John Viescas:

http://www.viescas.com/Info/books.htm

or the one by FMS Inc:

http://www.fmsinc.com/toplevel/books.htm

For SQL Server, I use Kalen Delaney's Inside Microsoft SQL Server 2000 but I
have not used other books so I can't say which one is best but Kalen
Delaney's suit my purpose at the moment. There are plenty of SQL Server
books so you can browse at a well-stocked bookshop.