I'm in the midst of a final major project for my BSc Degree course and have an interesting problem to solve. Any broad advise about how I might approach the problem would be much appreciated. I'm certainly not looking for any serious assistance as that would be plagarism but general help would be welcome.
I need to create a system to achieve the following theoretical result.
I'm project managing a series of installations into a number of customer premises (100+) . Several colleagues need to be able to imput data into the system but cannot get access from outside the network i.e.from home. Therefore I need to set a up a web page which can be accessed by the user via the Internet and data entered into some sort of web form.
The data needs to be passed from there into a database (Access) where it is stored. The end users who want to see the data displayed don't have access to the database, so it will have to populate a spreadsheet across the company Intranet to which they do have access.
So what I need to do is design a system that allows data to pass from a web form into a database and then output itautomatically to a spreadsheet.
Is this even possible and if so broadly what would the process be? I don't actually have to create any of this, just explain the procedure as aprt of my project. I've worked with the applications concerned ( web edtors, Microsft Acces & Excel) and think??? it's possible. Any good websites would be useful. As long as I acknowledge the sources I can use any material I can find both on-line or off.
Ta. :winkiss:
Sharepoint? That would give you exactly this result although not quite in the way described.
TL.
yes it is possible. ASP can write to access databases easily enough and Access can export to spreadsheets.
However, I'd go the entire web route. Have the whole thing on a database and use a web frontend. Sharepoint will do that, but a custom written design would be best from a degree standpoint :P
Thanks for the info. I'll take a look at Sharepoint. I don't actually have to write any code, just explain the basic design and processes i.e explain that it can be done and how it would be done if I did design it. I wasn't sure linking the three parts together was possible but now I know I'm on the right track. Ta :)