Results 1 to 4 of 4
  1. #1
    henrytime247 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Aug 2014
    Posts
    2

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

    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!!

  2. #2
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    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

  3. #3
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    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.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  4. #4
    henrytime247 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Aug 2014
    Posts
    2
    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.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 06-26-2014, 12:52 PM
  2. Replies: 4
    Last Post: 02-03-2014, 12:16 PM
  3. Replies: 35
    Last Post: 01-08-2014, 01:33 PM
  4. Replies: 1
    Last Post: 07-22-2013, 09:31 AM
  5. Replies: 1
    Last Post: 05-10-2012, 11:56 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums