Need advice on doing both inventory and check-in & check-out system

[henrytime247]

Hey all!



I'm pretty new to Access but I'm pretty much sold on Access that it is the better than Excel when it comes to keeping inventory.

I need your advice on what would be the easiest way about doing the following:

- I'm looking to use Access to keep an inventory of all the tools that we have.
- I also need a way to allow users to check-in and check-out the tools (via online; includes information about the tool; duration of their usage; checked-out/in time)
- I need Access to keep track of all the tools that have been checked-in and out.

So basically I want to use Access like an library system where the user checks in and out the tools that they need via online and all I have to do is just go into my Access form once a day to make sure all the information are correct.

Tools available to me are Access 2007, phpScheduleit, Sharepoint, and Outlook.

Any suggestions will be very helpful!

Thank you in advance!!

[ssanfu]

You could start by looking at
Library of Free Database Models at:
http://databaseanswers.com/data_models/index.htm

Look at #44 - there are 5 models available that might help you get started

[June7]

Sounds like Lending Library database. Review http://office.microsoft.com/en-us/te...010206883.aspx

Web database is a whole other can of worms. I've never built one. SharePoint is one way to go.

[henrytime247]

Thank you guys for the previous response. But I'm still looking for practical ways to get the online check-in/out system in place.

Has anyone used sharepoint in that way? Or phpsheduleit?

Thanks in advance.