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.
Access is the right tool for the job, certainly. Without any detail I would estimate it is probably a week to 10 days' work. You can keep Excel in the mix also if you want some reports. Access has its own reporting fun Plus
13 freelance font une offre moyenne de €222 pour ce travail
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a database. I have 7 years’ experience designing and developing Access databases. I would approach your project by creating a draft Plus
Hi there, if you'd really like to have a professional Ms Access software for your project , here is my introduction: I’m an Access/VBA programmer, a mathematician and a full time developer with a strong background deve Plus
I have a bachelor degree in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administration and Plus
Hello, dear sir! I have registered on the forum not long ago and I have yet completed projects to www.freelancer.com. I am ready to carry out your project in the minimum price and in the shortest possible time and wit Plus
I am 9+ Years of Experienced Software Developer. ASP .Net , C# , VB .Net , Visual Basic, Excel VBA , MS SQL Server , MYSQL , Oracle , MS Access, Crystal Report, Telerik , Bootstrap , HTML 5 , CSS , Java Script are my Plus
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.
We are highly experienced Post Graduate Engineers, Doctors, IT, ITES, Software, Infrastructure Professionals, Web Designers and IT Architects. We can redo, improve, and publish any engineering, scientific MATLAB, S Plus
!! I WILL DO YOUR PROJECT FREE if this project helps me improve!! Hello. Thanks for your job posting! I'm happy to bid on this project and have a relationship with you. I understand your requirements exactly. I Plus
Hi, I read through the document attached to your request. While access database might work for you now, it will get difficult to manage when the time comes. What I propose is Desktop App with mysql database Backend Plus
You are headed the right direction in moving to Access. I can create you a database that will be easier to navigate, allow you to grow easily, and provide more information quickly. I have worked created databases t Plus
Hi, I suggest you ms access bcoz Ms access complete dbms than other (All in One). I will design it clean and clear. I will do relation between equipment and employee. I will provide Admin panel where you can add, ed Plus