I need to create a database for diferent equipment that I rent out

Completed Posted 7 years ago Paid on delivery
Completed 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.

Microsoft Access

Project ID: #12706211

About the project

11 proposals Remote project Active 7 years ago

Awarded to:

TimHudspith

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

€300 EUR in 7 days
(5 Reviews)
4.2

11 freelancers are bidding on average €214 for this job

paris2785

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 More

€250 EUR in 10 days
(114 Reviews)
6.8
VladimirLilenko

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

€75 EUR in 4 days
(145 Reviews)
6.5
zu02

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 More

€555 EUR in 10 days
(47 Reviews)
6.1
crypthne

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 More

€166 EUR in 5 days
(29 Reviews)
4.4
BitSDestiny

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

€166 EUR in 3 days
(9 Reviews)
3.7
rafeemd

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.

€155 EUR in 3 days
(1 Review)
2.0
quickwriter24

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

€50 EUR in 3 days
(0 Reviews)
0.2
elnegmomar

A proposal has not yet been provided

€155 EUR in 3 days
(0 Reviews)
0.0
WestonPalmer

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

€166 EUR in 5 days
(0 Reviews)
0.0
kk51214

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 More

€311 EUR in 12 days
(0 Reviews)
0.0