Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
slimjen
Yak Posting Veteran
61 Posts |
 Posted - 2008-12-06 : 21:09:19
|
| I have been working with SQL Server 2000 and 2005 for about a year. Mostly I've created SQL backends with front end user applications using MSAccess 2003. I've now been tasked to create a Quality Monitoring program They want a database with a SQL backend. The managers need to access the Quality Monitoring Forms through our site on the internet and well as on their desktops. In the past, I worked with a Web Master. I would create the back end in SQL for the database by upsizing the MSAccess tables create by the web master and give the web master permissions to connect to the sql database. The web master is not longer assessible. Now, I have to create the entire program. I can create the database in SQL. After the schemas and all other database objects are created; how do I make it accessible to the users on the web. I also need to create a scorecard for the data after the managers are done with monitoring a agent. I know basic tsql code enough to manage the data i.e. by agent, date etc. I can figure out somewhat how to come up with a score. Maybe I can use the reporting services to create reports. I am all over the place trying to get a start and an outcome. Can someone give me any idea of getting started? Is there a sample quality monitoring program that can guide me. Please help. |
|
|
|
|
|
quaility monitoring program