Tracking location for item in building

[Allbutlost]

Sorry if this ends up not making sense I don't have any access experience but I am trying to set up a database for my small business that works with electronics for multiple companies. Up to this point I've always used Excel to keep track of this kind of stuff so I am having a rough time getting through to Access, but I feel like in the long run it would better suit my needs so I figured I would reach out for help in getting it set-up without having to re-make it because I made it horribly the first time.



I currently have an excel file that is done with columns like

"Company_Name"/ "Ticket_Number" / "Location" / "Type" / "Priority" / "Date_of_Arrival" / "Date_of_Processing" / "Date_Complete"

This is all the data that is typically recorded throughout the process when we receive an item, and the information is updated as it reaches the next stage (arrival to processing, then processing to complete meaning we have finished and returned the item). I would like to be able to set it up where I can eventually click a button and see what items are "In House" which ones are "In Processing" and which ones are "complete"

so I believe I am looking to make it where when the item is brought to us, someone can enter in the information up to "Date of Arrival", from there someone would later log the date it was turned over for processing, and finally the date the item was completed and returned, but I'm not sure if all of this information should be broken out into tables or if I should have it all in one table

[ranman256]

you need some tables:
tCompany table
tEquip table
tTicket table


tEquip table:
------------------
EquipID (auto)
ItemType (computer, printer, MoBo,etc)
make
model
etc...
OwnerID (long)
LocationID (long)

tTicket table:
------------------
TicketID (auto) (aka "Ticket_Number" ?)

EquipID (long)
Company_Name"
"Location"
"Type"
"Priority"
"Date_of_Arrival"
"Date_of_Processing"
Date_Complete"

[Allbutlost]

Awesome, thank you, with having the set-up like this I can actually use tutorials and other examples to figure out what I'm doing from here. If I end up having any questions later on with what I'm trying to do I'll start a different thread more detailed to that.

[ssanfu]

Do not use "Type" as an object (field) name - it is a reserved word. Plus it is not descriptive - "type" of what?? Car? Food? Monitor?
Maybe use "EquipType"?

[Allbutlost]

Do not use "Type" as an object (field) name - it is a reserved word. Plus it is not descriptive - "type" of what?? Car? Food? Monitor?
Maybe use "EquipType"?

I had a user message me explaining this to me, but thank you. The type is more of an in-house thing so we know what the initial service requested on the item was (I.e. Power Supply/Screen Replacment/Bulb Replacment ect.). I haven't actually dove into it yet as I was tasked with a network problem over the weekend so I haven't reached that point yet, but I think I can probable go with something like serviceType ?

Either way, I'm going to set down with a pencil and paper and do a bit more planning for sure.