I need to create a database for diferent equipment that I rent out
€30-250 EUR
Paid on delivery
Hello,
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.
Project ID: #12706211
About the project
Awarded to:
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 More
11 freelancers are bidding on average €214 for this job
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 More
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 More
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 More
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 More