I've recently inherited an excel spreadsheet with multiple tabs keeping track of multiple different models of phones / tablets / wifi cards issued to different users in different offices across the country. In a seperate spreadsheet we are keeping track of how many car/wall chargers we are sending out. And in a third spreadsheet we are recording when devices are returned to us.
There is a high turn over rate in our industry so I will constantly be swapping out devices. I need a better way to keep track of the Assets we are sending out and the assets being returned to me. I'm a little rusty with Access as I haven't used it in a few years, but I'm willing to brush up on it a little bit to creat a more refined solution.
Obviously I will need a table for:
Employee Info:
-ID*
-FirstName
-LastName
-OfficeLocation
-Notes
I will also need a way to keep track of the actual assets. Should the car and wall chargers have there own table? What would be the best way to keep inventory in order to record returned devices and keep track of items that have been shipped out?
Device Table:
-ID*
-Category (Phone,Tablet,WiFiCard,WallCharger,CarCharger)
-IMEI
-SIM (This can change)
-Make (LG,Samsung,Apple)
-Model (Galaxy,Spectrum,iPhone)
-PhoneNum (This can change)
-Carrier (Verizon, AT&T, T-Mobile)
-Price (Cost of deivce if lost or broken)
-Condition (New,Good,Fair,Poor)
-AquiredDate
-LineStatus (Active, Suspended)
-Office Location
-Notes
Order Table:
-ID*
-DateShipped
-TrackingNum
-FirstName
-LastName
-OfficeLocation
-Category (Phone,Tablet,WiFiCard,WallCharger,CarCharger)
-IMEI
-SIM (This can change)
-Make (LG,Samsung,Apple)
-Model (Galaxy,Spectrum,iPhone)
-PhoneNum (This can change)
-Carrier (Verizon, AT&T, T-Mobile)
-LineStatus (Active, Suspended)
-Notes
I'm not sure if I am on track or way off track.
What do you guys think?