I worked in the Foundation office at the local university and we invested in Raisers Edge. It was quite costly then but extremely powerful. I was lucky enough to get training on it and then was able to fully realize the potential it had to offer. If you have an organization which can afford the software and the high support fees it's good.
The nonprofit I currently work with uses Giftworks. I find the program does what I need it to do. Will integrate with Quickbooks...although I prefer to keep the two separate. There are a few limitations [and bugs] that I've found with the program...but overall it's wonderful for us.
I would not use MS Access unless you're into setting up everything to give you what you want. I tried that in the beginning and spent more time trying to "tweak things" here and there and gave up.