I'm designing a database for internal use at my company that will store data that is produced by my team members. While SQL Server will be installed only on a single server machine, my team members will need to be able to access the data and run filter/select queries on it from their own terminals (for instance, search for the product from a specified brand that had the max score on a certain test). Obviously, I could design a web interface or C# app that did this, but I'm sure there's a client side app already out there that would allow this as well.
So is there? Even like a free Microsoft downloadable perhaps? I guess what I'm really looking for is a query builder of sorts. I remember working with Access back in the day and it had a nice GUI for making up nice little queries with max/min/average options and fitlers aplenty; that's what I'm looking for.
Also, table management (a la PHPMyAdmin) would be nice, but isn't necessary. The primary thing my team members need to be able to do is run select queries like the example I gave in the first paragraph. They don't even need to do insertions necessarily because I have a separate system set up for that.
Thanks!
P.S. I found Acitve QueryBuilder and DbVisualizer through Google, and they both look great. However, they both cost money as well. Is there a free alternative? Or, if not, are these two I found good query builders? Or are there other ones that are better?
Update: I just realized that while I can't install SQL Server Developer on all my team members' terminals, I can install the Express edition, which includes the management studio. I'm new to the software, but I'll mess around with that and see if it does what I want and post back...