I'm in need of a database for all my assets. Currently I've been using an excel spreadsheet but I see now that my needs have gone past what excel can deliver. So I'm thinking about moving over to MS Access(But I'm open to suggestions if you have a better idea).
I've attached the excel spreadsheet so you can see what I currently got(It's written in Norwegian but you'll get the picture). The three first sheets of the spreadsheet is where most of the data is located.
My spreadsheet contains clothes and other products that I rent out to my employees. I can see which employee has what, when they got it and when they delivered it back. But that's how far I currently can backtrack.
What I now want is to be able to choose an item or a person, and then see the history of:
- Who has the item and when did they get it.
- Who used to have the item, when did they get it and when did they deliver it back.
- What kind of items does the selected person have, when did they get it, when and what did they deliver.
It will be sufficent to know the dates of the things above.
I also need to be able to add new employees and new pieces of equipment. I would like to be able to add more information about my employees like telephone number, adress, email etc.
As said earlier, I was thinking about using MS Access for this but I'm open for suggestions.
13 freelance ont fait une offre moyenne de 222 € pour ce travail
I have sound experience (5+ years) in Excel/MS Access/Macros/Data Entry and Visual Basic for Applications development and ability to learn new task quickly. I am efficient and Trustworthy.