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