Inventory Database

[roger556]

Hello,


First of all I would like to thank the forum to allowing me to be part of it.I have started to use access for my buisness and I need to create a inventory database of all the hardware computer etcetc in my office.What I have created so far is a master list table accounting all the hardware inventory that I have for example purpose let us take PC's I have 100 now I would like to do is create another table listing each of those pc's with a tag number and also the details.
Now I would like to do is create a relationship between these tables in suck a fashion where by I am able to see the details off all the PC's in the master list under the PC's record.
Please if anyone can give any suggestions or advice will greatly appreciated thanks in advance.

Thanks,
Roger

[orange]

Here's a free model that you may find helpful.
http://www.databaseanswers.org/data_...sets/index.htm

[roger556]

Hello Orange,
Thanks a lot for sharing the model with me it really gives me a idea of how to proceed with the set up of my database.Please have a question if there is any link to access the data type used to set up these field names and data type.
Thanks in advance for all your help really appreciate it.

Thanks,
Roger

[orange]

If you are new to database, as well as Access, you would do yourself a great favor by reading the first 4 Topics of this link
http://www.rogersaccesslibrary.com/forum/topic238.html

When you define your table, and enter field names, Access will allow you to set/modify data types.

[roger556]

Hello,
Thanks a lot for sharing the database model it was really helpful for making my database I still have some loose end though on my project that I need help with,Like I would like to know how to create a sum total of the inventory of computers in my list.If some one could help me I would really appreciate it.

Thanks,
Rajesh

[orange]

You 're going to have to show us your tables and relationships.

To see how to do a query with aggregate functions
http://www.techonthenet.com/sql/sum.php
http://www.techonthenet.com/sql/count.php
http://www.techonthenet.com/sql/index.php

[roger556]

Hello Orange,
I can post what I have worked on so far please give me your advice and opinion.

Thanks

[roger556]

Hi Orange,
Attach you will find the database I know it is a bit crude as it is made by a novice so please bare with me.Thanks for your time and effort in helping me.

Thanks,
Roger

[orange]

Your description indicates you have Acc2003. I have acc2003, so I can not open an accdb file. Sorry.
I thought you'd be sending an mdb.

[roger556]

I am so sorry for that I am creating this database in access2003 at my work place at home I have access 2010 so I was testing it in that version.
I am sorry for that I will try to post the file in access2003 version.

Thanks,
Roger

[roger556]

Hi Orange,
I have converted it in to mdb please try to access it.

Thanks,

Roger

[orange]

I think you still have a 2010 accdb. I dropped the .accdb, but it still gives me an unrecognizable format.

[roger556]

Hello Orange,
I have converted it into pdf file please take a look at it and let me know what changes I should make or if I can do this in a better way.My goal is to just make a list of the inventory that I have of all the pc's etcetc that I am going to assign a unique tag#.But I want to achieve is to be able to auto update all the tables with just one entry in a form and also I would like to have sum total of all the hardware individually.

Thanks,
Roger

[orange]

Good start.

[roger556]

In asset type I am able to open the list of all pc's as I have create a relationship between asset type and it assets.But I am not able to create a sum total of each hardware in Asset type,I have tried all possible ideas I can think of if only I could get another column indicating to me how many pc's I have in total in my IT_asset list that would awesome right now I am able to pull it in the query.

Thanks,
Roger