One of my co-workers and I are working together to implement a new help desk issue tracking front-end using Windows Sharepoint Services 3.0 (WSS). What's the best way to accomplish this? We have all Office 2007 applications so we've been playing around with InfoPath and Access. We also have Sharepoiint Designer 2007 as well, but don't know much about it? Is one of those our best option, or is there something else out there?
Our Back-end SQL 2000 database has all of our asset information, users, departements, etc in tables already, so we would just need help on the front-end. Ideally, it would be nice to design something, then publish it right to our sharepoint site somehow, but we're open to anything.