By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,109 Members | 993 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,109 IT Pros & Developers. It's quick & easy.

Book on database problem solving.

P: n/a
Was wondering if anyone knew of any references for solving particular
database problems with Access.

For example, how to create databases with transaction tables (I know
they're not built in to Access, so I want to know how to construct
something similar myself), general ideas on keeping track of financial
information (e.g. simple nominal ledgers), how to simply append data
to both sides of a one-many pair from a similar one-many linked pair
whilst keeping links intact or creating hierarchical databases.

Would be great if it also had a good go at explaining how to do good
database design, explaining the good and the bad ways to achieve
certain tasks. The more emphasis on twisting queries into shapes that
don't normally go in the better.

Actually, the examples don't have to be for Access, anything SQL based
will do.

I'm not after a manual on which Access widget does which, I'm after
something with tricky problems and solutions.

I've got very good manuals on how to use the features of Access (eg.
Access Developers handbook) but still find myself ending up in too
many dead ends because I couldn't quite construct the right kind of
SQL join for certain gnarly problems.

-------------------------------------------------------------
Dale Walker London Techno Events Saiko!
da**@sorted.org lo****@sorted.org sa***@sorted.org
London, UK london.sorted.org saiko.sorted.org
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Thu, 02 Sep 2004 00:01:17 +0100, Dale Walker <da**@sorted.org>
wrote:
Was wondering if anyone knew of any references for solving particular
database problems with Access.

For example, how to create databases with transaction tables (I know
they're not built in to Access, so I want to know how to construct
something similar myself), general ideas on keeping track of financial
information (e.g. simple nominal ledgers), how to simply append data
to both sides of a one-many pair from a similar one-many linked pair
whilst keeping links intact or creating hierarchical databases.

Would be great if it also had a good go at explaining how to do good
database design, explaining the good and the bad ways to achieve
certain tasks. The more emphasis on twisting queries into shapes that
don't normally go in the better.

Actually, the examples don't have to be for Access, anything SQL based
will do.

I'm not after a manual on which Access widget does which, I'm after
something with tricky problems and solutions.

I've got very good manuals on how to use the features of Access (eg.
Access Developers handbook) but still find myself ending up in too
many dead ends because I couldn't quite construct the right kind of
SQL join for certain gnarly problems.

-------------------------------------------------------------
Dale Walker London Techno Events Saiko!
da**@sorted.org lo****@sorted.org sa***@sorted.org
London, UK london.sorted.org saiko.sorted.org


A couple of books that come to my mind are

Access Cookbook by Ken Getz, Paul Litwin and Andy Baron
O'Reilly and Associates, 2002
ISBN 0-596-00084-7

and

SQL for Smarties by Joe Celko
Academic Press, San Diego, 2000 (2nd edition)
ISBN 1-55860-576-2

I think there is no direct information about finincial programming,
but you will find lots of practically useful information in both
books.

HTH
Matthias Kläy
--
www.kcc.ch
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.