I've been asked to design a web front ended database solution to run on a company intranet for around 10 users to record about 100 records a month (few simultaneous users possible). Nothing exists for this yet, so a clean sheet.
The data to be recorded is related to recording events that occur so fields will be date/desc/who/why/how/follow-up etc and I'll also need to allow attaching a document to each record (pdf or .doc). Numerous simple reports will be required mostly based around 'how many records between 2 dates' etc.
I have access to a server which is running Win2003, has SQLServer running an important off-the-shelf system, also has full Office2007 and all users have Office installed and use IE7 browser.
My main question is - is Alpha Five the best approach to take (given time is limited)? I'm new to all this (but have IT experience). Do I start with MS Access 2007 to build tables etc and then use Alpha V for web/form design and which will allow users to use solution?
Or should I not use Access as there will be limitations later? Should I sneak a new SQLServer database on the end of the installed one (who would notice?)
Or use MySQL?
The attaching of a document isn't a usual database requirement and concerns me.
(have ordered that book 'Database Design for Mere Mortals'!).
Would appreciate your thoughts/advice/suggestions. Needless to say I didn't volunteer for this!
The data to be recorded is related to recording events that occur so fields will be date/desc/who/why/how/follow-up etc and I'll also need to allow attaching a document to each record (pdf or .doc). Numerous simple reports will be required mostly based around 'how many records between 2 dates' etc.
I have access to a server which is running Win2003, has SQLServer running an important off-the-shelf system, also has full Office2007 and all users have Office installed and use IE7 browser.
My main question is - is Alpha Five the best approach to take (given time is limited)? I'm new to all this (but have IT experience). Do I start with MS Access 2007 to build tables etc and then use Alpha V for web/form design and which will allow users to use solution?
Or should I not use Access as there will be limitations later? Should I sneak a new SQLServer database on the end of the installed one (who would notice?)
Or use MySQL?
The attaching of a document isn't a usual database requirement and concerns me.
(have ordered that book 'Database Design for Mere Mortals'!).
Would appreciate your thoughts/advice/suggestions. Needless to say I didn't volunteer for this!
Comment