I would think the speed would be the bigger issue. Basically the queries have to be smartly made. Something that will take what people want to receive, and be smart about how they do the joins and selects and things like that. I figured that there would possibly be some application (maybe even Access) that would do that automatically, but wasn't sure.

It will be non-technical people using the software, but as I said there are DBAs and so it's not like there are NO technical people to maintain the software. It just couldn't be a dense C# program or something. If it was maybe something simpler that was not as hard to understand then I could probably make a case for it.