Link to home
Start Free TrialLog in
Avatar of Gearoid Ryan
Gearoid Ryan

asked on

Need an Access database Template

Hi, i need to create an Access database, to collate all the software in use in an organisation, it would need to identify which teams/users use each application, & information on vendors. I'm hoping someone here can point me towards a template I can start with or a good tutorial .

Thanks
Gearoid
Avatar of lcohan
lcohan
Flag of Canada image

Did you had a look first at Microsoft own
Access Asset Tracking template
that can
track of computers, office equipment, or anything else that is owned or maintained by people.

https://support.office.com/en-us/article/use-the-access-asset-tracking-template-6e99a32c-fbda-48a2-89b0-ef0d68b381ec

Few more free templates can be found here https://www.template.net/business/inventory-templates/sample-access-inventory/
Avatar of Gearoid Ryan
Gearoid Ryan

ASKER

Hi Icohan,
 thanks for the response
  I did look at this template but it is very limited and designed for physical assets rather than software, there is no way to record which members of which teams use the asset, no way to have multiple users of an asset..

I had also looked at various inventory templates, they do come a bit closer to what I need but still suffer from the same limitations..

I am surprised I can't find something, it doesn't necessarily have to be Access...

Thanks
Gearoid
This is a many-many relationship.
tblProducts
ProductID
Desc
Version

tblUsers
UserID
.....

tblUserProducts
ProductID (PK fld1)
UserID (PK fld2)
SerialNumber (Pk fld3)
InstallDate
UninstallDate


tblUserProducts is the junction table that relates products to specific users.  Serial Number is used to allow multiple versions to be active at one time.  Depending on how you think of the software, you might want a parent table for tblProducts that does not include version.  So in the case of Access, the parent table contains the value "Access", the product table contains A2016, and the junction table contains the version.  Or maybe, the product table does not include the version and that is stored in the junction table.  Try building some queries to determine which makes more sense to you.  Would you need to know how many people use "Access" or how many use "Access 2016" or perhaps you need both queries.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.