At my previous employer I created a database with Microsoft Access. It grew in functionality and the number of forms and reports over time. Even included ASP reports available on a website extracted live from the database. It handled tracking of active projects which would transition to the approval listing and tracked renewals. Metrics were available in the reports for approval durations by country as well. Worked out very good as was tailored specifically to the company processes. Easy to use too (if I do say so myself since I wrote it)! The original list of approvals was done in Excel by Marketing so importing into Access saved a lot of initial data entry. Excel is the poor man's database in my opinion and is too limiting. This kind of information belongs in a real database of some kind. ______________________________________________________ Dan Roman, N.C.E. VP of Communications Services mailto:dan.ro...@ieee.org
_____ From: Goedderz, Jim [mailto:jgoedd...@tycoint.com] Sent: Friday, June 29, 2012 11:16 AM To: EMC-PSTC@LISTSERV.IEEE.ORG Subject: [PSES] database Group, We've been discussing getting a database that would include all our products, and their status as pertains to safety, emc, etc. The object is to be able to sort and see which products have missing certifications, all certifications, etc. and can also store the documents. Can anyone suggest a program that is off the shelf for this use? Thank you. James Goedderz Sr. Principal Engineer-Product Safety Sensormatic Electronics, LLC 561.912.6378 - ---------------------------------------------------------------- This message is from the IEEE Product Safety Engineering Society emc-pstc discussion list. To post a message to the list, send your e-mail to <emc-p...@ieee.org> All emc-pstc postings are archived and searchable on the web at: http://www.ieee-pses.org/emc-pstc.html Attachments are not permitted but the IEEE PSES Online Communities site at http://product-compliance.oc.ieee.org/ can be used for graphics (in well-used formats), large files, etc. Website: http://www.ieee-pses.org/ Instructions: http://listserv.ieee.org/request/user-guide.html List rules: http://www.ieee-pses.org/listrules.html For help, send mail to the list administrators: Scott Douglas <emcp...@radiusnorth.net> Mike Cantwell <mcantw...@ieee.org> For policy questions, send mail to: Jim Bacher <j.bac...@ieee.org> David Heald <dhe...@gmail.com> - ---------------------------------------------------------------- This message is from the IEEE Product Safety Engineering Society emc-pstc discussion list. To post a message to the list, send your e-mail to <emc-p...@ieee.org> All emc-pstc postings are archived and searchable on the web at: http://www.ieee-pses.org/emc-pstc.html Attachments are not permitted but the IEEE PSES Online Communities site at http://product-compliance.oc.ieee.org/ can be used for graphics (in well-used formats), large files, etc. Website: http://www.ieee-pses.org/ Instructions: http://listserv.ieee.org/request/user-guide.html List rules: http://www.ieee-pses.org/listrules.html For help, send mail to the list administrators: Scott Douglas <emcp...@radiusnorth.net> Mike Cantwell <mcantw...@ieee.org> For policy questions, send mail to: Jim Bacher: <j.bac...@ieee.org> David Heald: <dhe...@gmail.com>