access_denied
New member
- Local time
- Today, 17:17
- Joined
- Aug 14, 2013
- Messages
- 7
Hi guys, I really need you help here please!
First off: this is gona be a long-ish post and very likely to be totally confusing as well... you have been warned!
Ok, so I started building a database for work to log the assets we have and to make it easier to supply things like ink toner for a specific printer within the organisation.
I have very limited Access knowledge but I have just started reading The Missing Manual 2010 (very handy book)
Basically we have about 30 residential houses, a bunch of workshops and some office building.
These premises are scattered over a large area and so are divided up into areas/location.
Each location will have 1 or more PC’s and Printer’s as well as some other items like network equipment.
The assets are not associated with a user unless there are multiple items in the same building, and then its manly for location purposes within the said building.
The Database will be many used for Asset recording and Printer information. Being able to supply the correct Printer Consumables for the right printer by only knowing its location (and possibly its user). Most users don’t know what model printer they have but they do know their own location thankfully!
I have started few a database designs but keep scrapping them and starting over as things just don’t seem to hang together.
I have now been trying to design on paper what info I need the final form to hold (may change)
Information needed on the form:
AssetType (will just be a pick list of Types…PC, Monitor, Printer etc)
AssetName (Basic info like Make, Model. Not available if Printer is selected in AssetType)
PrinterManufature (If Printer is selected in AssetType then all printer option become available)
PrinterModel (After choosing a PrinterManufacture this list should show relevant printers)
PrinterType (After selecting PrinterModel this will auto fill to correct type, ie laser, inkjet)
PrinterConsumables (As above, it will auto fill correct Printer Consumables)
AssetSerialNo (optional field if Asset Serial number is available)
AcquiredDate (Date Asset was acquired)
ReplacementDate (Date Asset should be replaced)
User (Normally user field will be the Asset Location as multiple users have access)
Ownership (Ownership field is needed as a few items are personal items used for work)
Loaction (Pick list of Locations, select one to auto fill other location related fields)
LocationType (Will be auto filled by selecting a Location in the Location field)
Neighbourhood (Will be auto filled by selecting a Location in the Location field)
HomeplugType (Will be auto filled by selecting a Location in the Location field)
AssetNotes (Any extra info needed about the Asset)
I have put together a bunch of forms that I think I need but now can’t get them to all tie up together with relationships.
Ultimately I would like to enter the info into a form and have as much of the printer info auto entered after selecting the right printer ect…
I hope all that makes sense and I have tried to upload my database but if that fails please contact me and I can provide a dropbox link.
Thanks in advance for any help!!
First off: this is gona be a long-ish post and very likely to be totally confusing as well... you have been warned!
Ok, so I started building a database for work to log the assets we have and to make it easier to supply things like ink toner for a specific printer within the organisation.
I have very limited Access knowledge but I have just started reading The Missing Manual 2010 (very handy book)
Basically we have about 30 residential houses, a bunch of workshops and some office building.
These premises are scattered over a large area and so are divided up into areas/location.
Each location will have 1 or more PC’s and Printer’s as well as some other items like network equipment.
The assets are not associated with a user unless there are multiple items in the same building, and then its manly for location purposes within the said building.
The Database will be many used for Asset recording and Printer information. Being able to supply the correct Printer Consumables for the right printer by only knowing its location (and possibly its user). Most users don’t know what model printer they have but they do know their own location thankfully!
I have started few a database designs but keep scrapping them and starting over as things just don’t seem to hang together.
I have now been trying to design on paper what info I need the final form to hold (may change)
Information needed on the form:
AssetType (will just be a pick list of Types…PC, Monitor, Printer etc)
AssetName (Basic info like Make, Model. Not available if Printer is selected in AssetType)
PrinterManufature (If Printer is selected in AssetType then all printer option become available)
PrinterModel (After choosing a PrinterManufacture this list should show relevant printers)
PrinterType (After selecting PrinterModel this will auto fill to correct type, ie laser, inkjet)
PrinterConsumables (As above, it will auto fill correct Printer Consumables)
AssetSerialNo (optional field if Asset Serial number is available)
AcquiredDate (Date Asset was acquired)
ReplacementDate (Date Asset should be replaced)
User (Normally user field will be the Asset Location as multiple users have access)
Ownership (Ownership field is needed as a few items are personal items used for work)
Loaction (Pick list of Locations, select one to auto fill other location related fields)
LocationType (Will be auto filled by selecting a Location in the Location field)
Neighbourhood (Will be auto filled by selecting a Location in the Location field)
HomeplugType (Will be auto filled by selecting a Location in the Location field)
AssetNotes (Any extra info needed about the Asset)
I have put together a bunch of forms that I think I need but now can’t get them to all tie up together with relationships.
Ultimately I would like to enter the info into a form and have as much of the printer info auto entered after selecting the right printer ect…
I hope all that makes sense and I have tried to upload my database but if that fails please contact me and I can provide a dropbox link.
Thanks in advance for any help!!
