todd.ayers (5/7/2013)
OK... so in lieu of access what could I use to act as a GUI for the users?
Well don't just take my opinion as the direction you should go. I am jaded against Access. Access has worked as the front end for a lot of applications for a lot of people. It is pretty easy to use and the learning curve is not too bad.
If you are looking for alternatives it might depend somewhat on how you want to interact with your application. Should it be available as a website or is a windows application preferred?
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/