Here is a library of several hundred Access data models, if you click on the contact button the mdb will be emailed to you.
http://www.databaseanswers.org/data_models/ You may have to use a BOM (Bill of Materials) or Parts explosion model The SQL gets a little tricky http://www.mvps.org/access/modules/mdl0027.htm http://www.mvps.org/access/queries/qry0023.htm --- In [email protected], "luvmymelody" <[EMAIL PROTECTED]> wrote: > > Hello all, > > I am developing a database for computer inventory regarding several > departments in different buildings. There are 3 buildings and 10 > departments. There are several departments in one building and each > department has a computer. I have always struggled with the physical > model of designing a database. Can someone take a look at the table > structure and let me know if I am on the right track? I will > probably need to break out the peripherals to different tables also? > Thanks > Jim Wagner > > Building > BuildingID > BuildingName > Address > City > State > Zip > > > Unit > UnitID > UnitName > UnitNumber > UnitPhone > BuildingID > > > Monitor > MonitorID > Manufacturer > ModelNumber > SerialNumber > BuildingID > > > Tower > PCID > Manufacturer > ModelNumber > SerialNumber > CPUSpeed > CPUName > RAM > HardDiskSize > Description > BuildingID > > > Periphials > Mouse > Keyboard > Printer > Fax > BuildingID > > > Printer > PrinterID > Manufacturer > ModelNumber > SerialNumber > BuildingID > > > ProductKey > ProductKeyID > ProductKey > BuildingID > > > Registered Number > RegisteredID > RegistereNumber > BuildingID > > > Software > SoftwareID > Title > SoftwareDescription > Manufacturer > BuildingID >
