Hi Jan,
Requirements are always different. Personally, I like to dig in and start doing the work -- more reliable than guessing what to do. I start with data structure.
Get example copies of all the forms, and reports they use
Get example copies of files they keep track of information in too -- Excel, Word, etc.
Print a copy of everything so you can spread them out on a table and write notes. I have a desk next to my computer desk so I can look at papers and start designing tables. Perhaps you want to write structures on big paper first. Here are video tutorials that start with planning a database:
Learn Access Playlist on YouTube
http://www.youtube.com/view_play_list?p=1B2705CCB40CA4CA
once you get an idea of what they have to work with, you can see where you can go. Until you get to this point, don't put time into designing forms or reports -- that will change the way you see the data and you might miss things.
To document the structure, you can run the free Analyzer for Microsoft Access
http://analyzer.codeplex.com/
I would also print a well-laid out relationships diagram. They have probably never seen one of those before ... so you'll probably have to explain it.
Are you doing this as a volunteer? What kind of a non-profit is it?
Warm Regards,
Crystal
~ be awesome today ~
A local non-profit has asked me to put together a database for them. Does anyone have a template for documenting their requirements they would care to share?
Thanks
Posted by: crystal 8 <strive4peace2008@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar