i started a job where a database needed building and between me and my collegue we achived that with a sql server back end and access front end.
Although i understand what im doing, with no formal training (only over the shoulder type) i have big gaps in my knowledge of the fundamentals. problem is my collegue is now leaving...no big deal as it's already set up but i need to be able to expand my knowlegde....
as it will be a busy time of year i cant go on a training course so am wondering if there are any good books i can use to learn the fundamentals of sql and access vb....
i have sams teach yourself sql in 21 days which is pretty good but i'd like something that was based on sql server rather than oracle....i also have visual basic in eays steps which doesn't tell me much really...has loads of examples but no explanations of theory.
so i'd appreciate any book recommendations- books about sql or vb which are the standard industry reference. there are a lot out there and i wanna make sure i get the most suitable.