Take the 2-minute tour ×
Programmers Stack Exchange is a question and answer site for professional programmers interested in conceptual questions about software development. It's 100% free, no registration required.

My little brother is a CPA but in his new job he is required to use access to pull his own data. He has grown frustrated with the limitations of the canned reports that he has access to. However he does have read access to the data cubes and can write his own queries. I am looking for a book that would be easy for him to understand.

Any suggestions?

share|improve this question
    
When you say "required to use Access", do you mean by policy, or that's all they give him to use? Writing SQL queries in Access is fairly awkward. Also, what database is he connecting to? A better tool might be available. –  Joe Internet Mar 24 '11 at 8:05
    
It's what the IT team at his companey use. Since he can't even install his own programs I don't think they will let him use other tools. –  Erin Mar 24 '11 at 12:43
    
They might let him use another tool, but they'll probably need to install it for him. He should at least try, because his job can be a lot more efficient with better tools than Access. –  Joe Internet Mar 24 '11 at 13:09
add comment

closed as not constructive by Mark Trapp Dec 8 '11 at 19:41

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance.If this question can be reworded to fit the rules in the help center, please edit the question.

2 Answers

I used to have a bunch of links that I'd share, but I seem to have misplaced them.

Here's on of the links I can remember and it's sequel :) SQL Course SQL Course 2 (The Sequel)

And an article with a whole lotta lumps... I mean links ;)

http://learningsqlserver.wordpress.com/2011/02/18/a-new-users-guide-to-learning-sql-server/

For a print book, I'd recommend "Beginning SQL 2008" or "Beginning SQL 2005" by Robert Vieira, I've had a lot of luck mentoring/tutoring with.

share|improve this answer
add comment
up vote 0 down vote accepted

In talking with a couple dbas at my work the suggested the following book. Server 2008 Transact SQL Recipes Problem Solution I am thinking I will get it for him.

share|improve this answer
add comment

Not the answer you're looking for? Browse other questions tagged or ask your own question.