I'm a mechanical engineer based in atlantic canada and have started my new position as a project engineer. it did not take me long to realize this company needed to have a structured way of tracking parts on their facility plants. do we have any spares? where do we buy them from? where do they belong on our equipment etc. so i decided to create a database for this.
Hi Malcom, you're welcome
Microsoft Access is one of the best products for exactly what you asked for
And with the help of the forum users, you'll surely make a great impression
Just a word of advice: think big
Don't give in to the initial temptation of starting something that will be immediately operational but will then impede healthy growth
A database server, error handling, users with different permissions, front-end upgradeability, and database structure upgradeability, log insert and updates record with date/time/station/user, ecc..
Are all important features, not just for show but for real substance, that are often overlooked at project startup, but they are the foundation for offering a stable and easily usable structure in the future, and make this clear from beginning
Of course, it will take a few more weeks (or a few more months), but it allows you to offer a long-term vision, which is highly appreciated by company management, and support for the new project that will benefit from centralized logs to know 'who' did 'what'
Finally, do some experiments with your Access application loaded on a Terminal Server, It could even be a test virtual machine on your work PC
There are some aspects of user management, in printing, and in general, using an application via a Terminal Server that differ from using a traditional program installed on each workstation and accessing the remote database server, i assure you this experience will be useful soon.
Where do I send the invoice? .
