If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Newbie table Layout (Posted as suggested by Tom Lake for feedback)
To just add some info to my earlier post. This is my layout for a database to keep track of computer hardware and software. Just to give a little
info. There are of 1500 workstations, numerous, printers, peripheral and so on. I want to track them from the time they come in the door until the time there discarded. Part of the naming convention in the domain has to do with the building 98% of the time. Oh, by the way there are about 12 different buildings and many different rooms. One thought of I have in mind was to create a relationship from the location table to computer, printer, and monitors tables. Not sure if that is the best way. In quite a few cases, there are more the one users of a computer. Also looking ahead if a person installs a new computer in room 201. Since the computer info is entered once a computer arrives at the warehouse how do I connect the dots with a form. I'm trying to visualize how this happens and what info I need and how do I get it. In my mind I, lookup the computer info by serial number and attach a location and a monitor to it. However, do I have to sort through 4 or 5 hundred locations id number to link them because the are linked by primary key ID which is a number. Maybe someone can elaborate for me. I know I am in over my head but I am learning. Ok here my table layout that Tom Lake suggested I post for feedback. Tables Documentation Table: tbl_Computers (PK) Primary Key Field Name Description Type Length ComputerID (PK) Auto Number 4 Computer_Manufacturer ComputerManufacturer Text 50 Computer_Model Computer model number Text 50 Computer_ProductID Manufacturer Product ID Text 50 Computer_SerialNumber Computer Serial number Text 50 Computer_OperatingSystem Operating System Text 50 Computer_RAM Amount of system RAM Long Integer 4 Computer_CPU_Type Type of Computers processor Text 50 Computer_CPU_Speed Speed of Computers processor Text 50 Computer_HDD_Manufacturer Harddrive Manufacturer Text 50 Computer_HDD_Size Harddrive Space Long Integer 4 Computer_HDD_SerialNumber Harddrive Serial Number Text 50 Computer_HDD_IDE Does computer support IDE? Yes/No 1 Computer_HDD_SCSI Does computer support SCSI? Yes/No 1 Computer_HDD_Serial_ATA computer support Serial ATA? Yes/No 1 Computer_DVDRW computer have a DVD +/- RW? Yes/No 1 Computer_DVD Does Computer have DVD? Yes/No 1 Computer_CDRW Does Computer have CD-RW Yes/No 1 Computer_CDRom Does computer have CD-Rom Yes/No 1 Computer_Floppy computer have floppy Drive? Yes/No 1 Computer_Wired_MAC Network Card Address Text 50 Computer_Wireless_MAC Computers Wireless Mac Address Text 50 Computer_Purchase_Date Date of Purchase Date/Time 8 Computer_Domain_Name DNS Name of computer Text 50 Computer_Firewire Does computer support Firewire Yes/No 1 Computer_USB Does computer support USB Yes/No 1 Computer_Notes Notes about this computer Memo Computer_Barcode Barcode inventory Text 50 Computer_WarrantyEnd_Date Date Warranty Expires Date/Time 8 UserID Long Integer 4 LocationID Long Integer 4 MonitorID Long Integer 4 Table: tbl_Laptop Description: Field Name Description Type Length LaptopID(PK) Auto Number 4 Laptop_Manufacturer Laptop Manufacturer Text 50 Laptop_Model Computer model number Text 50 Laptop_ProductID Manufacturer Product ID Text 50 Laptop_SerialNumber Laptop Serial number Text 50 Laptop_OperatingSystem Laptop Operating System Text 50 Laptop_RAM Amount of system RAM Long Integer 4 Laptop_CPU_Type Type of processor Text 50 Laptop_CPU_Speed Speed of Laptop processor Text 50 Laptop_HDD_Manufacturer Harddrive Manufacturer Text 50 Laptop_HDD_Size Harddrive Size Long Integer 4 Laptop_HDD_SerialNumber Harddrive Serial Number Text 50 Laptop_HDD_IDE Laptopr support Serial IDE? Yes/No 1 Laptop_HDD_SCSI Laptop support Serial SCSI? Yes/No 1 Laptop_HDD_Serial_ATA Laptop support Serial ATA? Yes/No 1 Laptop_DVD Laptophave DVD Rom? Yes/No 1 Laptop_DVDRW Laptop have a DVD +/- RW? Yes/No 1 Laptop_CDRom Does the Laptop have a CDRom Yes/No 1 Laptop_CDRW Does Laptop have CD-RW Yes/No 1 Laptop_Floppy Does Laptop have floppy Drive? Yes/No 1 Laptop_Wired_MAC Laptops Network Card Address Text 50 Laptop_Wireless_MAC Laptop Wireless Mac Address Text 50 Laptop_Purchase_Date Laptop Date of Purchase Date/Time 8 Laptop_NetworkName DNS Name of computer Text 50 Laptop_Firewire Does Laptop support Firewire Yes/No 1 Laptop_USB Does Laptop support USB Yes/No 1 Laptop_Notes Notes about this computer Memo Laptop_Barcode Barcode number Text 50 Laptop_WarrantyEnd_Date Date Warranty Ends Date/Time 8 Laptop_Signature Has User Singed For Laotop Yes/No 1 Laptop_Date_U_Received Date User received Laptop Date/Time 8 Laptop_Date_U_Returned Date User returned Laptop Date/Time 8 UserID Long Integer 4 Table: tbl_Location Description: Field Name Description Type Length LocationID (PK) Auto Number 4 Location_Building Building Text 50 Location_RoomNumber Room Number Text 50 Location_Department Department Text 50 UserID Long Integer 4 ComputerID Long Integer 4 MonitorID Long Integer 4 PrinterID Long Integer 4 PeripheralID Long Integer 4 Table: tbl_Monitor Description: Field Name Description Type Length (PK) Monitor_ID Auto Number 4 Monitor_Manufacturer Monitor Manufacturer Text 50 Monitor_Model Monitor Model Number Text 50 Monitor_ProductID Manufacturer ProductID Text 50 Monitor_Size Monitor Size Text 50 Monitor_SerialNumber Monitor Serial Number Text 50 Monitor_Purchase_Date Date/Time 8 Monitor_WarrantyExpires Date/Time 8 Flat_Screen Yes/No 1 CRT Yes/No 1 Monitor_Notes Memo ComputerID Long Integer 4 LocationID Long Integer 4 Table: tbl_Peripheral Description: Field Name Description Type Length PeripheralID (PK) Auto Number 4 Peripheral_Type Type of Peripheral Text 50 Peripheral_Manufacturer Brand of Peripherals Text 50 Peripheral_Model Model of Peripheral Text 50 Peripheral_ProductID Text 50 Peripheral_SerialNumber Serial Number of Peripheral Text 50 Peripheral_Purchase_Date Date of Purchase Date/Time 8 Peripheral_Notes Notes on this item Memo Peripheral_MAC_Address Mac Address - Where applicable. Text 50 Peripheral_DNS DNS Name, Where applicable. Text 50 Peripheral_IP IP Address, Where Applicable. Text 50 Peripheral_Barcode Barcode Number Long Integer 4 Peripheral_Signature for (Camera, Camcorder etc) Yes/No 1 Peripheral_Date_U_Received Date User Received Date/Time 8 Peripheral_Date_U_Returned Date User Returned Date/Time 8 Peripheral_WarrantyExpires Date/Time 8 UserID Long Integer 4 ComputerID Long Integer 4 LocationID Long Integer 4 Table: tbl_Printers Description: Field Name Description Type Length PrinterID (PK) Auto Number 4 Printer_Manufacturer Printer Manufacturer Text 50 Printer_Model Printer model number Text 50 Printer_ProductID Text 50 Printer_SerialNumber Printer Serial number Text 50 Printer_DNS_Name Network Name Text 50 Printer_Network_Printer Yes/No 1 Printer_Slave Yes/No 1 Printer_IPaddress Text 50 Printer_Wired_MAC Text 50 Printer_Purchase_Date Printer Date of Purchase Date/Time 8 Printer_WarrantExpires Date/Time 8 LocationID Long Integer 4 Table: tbl_Software Description: Field Name Description Type Length SoftwareID (PK) Auto Number 4 Software_Company Text 50 Software_Name Text 50 Software_Version Text 50 Software_ProductID Text 50 ComputerID Long Integer 4 Table: tbl_UserInfo Description: Field Name Description Type Length UserID (PK) Auto Number 4 User_FName Text 50 User_LName Text 50 User_PhoneExt Text 50 User_CellPhone Text 50 User_Pager Text 50 User_Email Text 50 LocationID Long Integer 4 ComputerID Long Integer 4 LaptopID Long Integer 4 PeripheralID Long Integer 4 |
#2
|
|||
|
|||
Newbie table Layout (Posted as suggested by Tom Lake for feedback)
Penny, once you post a question and get one or more responses, it's much
better if you post additional information, comments, etc, in *the same thread*. the folks who responded (and you got two experienced developers posting back, which is excellent) may very well "flag" the original thread, and not see posts in another thread. also, other folks may see and respond to the second thread - now you have two threads running independently, and people working in one can't see and comment on the posts in the other. that leads to duplication of effort and frustration for everyone. suggest you copy your post, that started this thread, back to the original thread. don't be concerned that you haven't got a response in several hours in the original thread. you have to take into account that 1) this is a weekend, and 2) it's a holiday weekend, and 3) folks from all over the world post in these groups, so there's a time difference issue to consider, and 4) even on ordinary days, and weekdays, it's not unusual for a threaded discussion to continue over several days, with large gaps between posts. you're getting free help from folks who volunteer their time and have "day jobs" that demand their attention, just like you, so you'll need to be patient. hth "Little Penny" wrote in message ... To just add some info to my earlier post. This is my layout for a database to keep track of computer hardware and software. Just to give a little info. There are of 1500 workstations, numerous, printers, peripheral and so on. I want to track them from the time they come in the door until the time there discarded. Part of the naming convention in the domain has to do with the building 98% of the time. Oh, by the way there are about 12 different buildings and many different rooms. One thought of I have in mind was to create a relationship from the location table to computer, printer, and monitors tables. Not sure if that is the best way. In quite a few cases, there are more the one users of a computer. Also looking ahead if a person installs a new computer in room 201. Since the computer info is entered once a computer arrives at the warehouse how do I connect the dots with a form. I'm trying to visualize how this happens and what info I need and how do I get it. In my mind I, lookup the computer info by serial number and attach a location and a monitor to it. However, do I have to sort through 4 or 5 hundred locations id number to link them because the are linked by primary key ID which is a number. Maybe someone can elaborate for me. I know I am in over my head but I am learning. Ok here my table layout that Tom Lake suggested I post for feedback. Tables Documentation Table: tbl_Computers (PK) Primary Key Field Name Description Type Length ComputerID (PK) Auto Number 4 Computer_Manufacturer ComputerManufacturer Text 50 Computer_Model Computer model number Text 50 Computer_ProductID Manufacturer Product ID Text 50 Computer_SerialNumber Computer Serial number Text 50 Computer_OperatingSystem Operating System Text 50 Computer_RAM Amount of system RAM Long Integer 4 Computer_CPU_Type Type of Computers processor Text 50 Computer_CPU_Speed Speed of Computers processor Text 50 Computer_HDD_Manufacturer Harddrive Manufacturer Text 50 Computer_HDD_Size Harddrive Space Long Integer 4 Computer_HDD_SerialNumber Harddrive Serial Number Text 50 Computer_HDD_IDE Does computer support IDE? Yes/No 1 Computer_HDD_SCSI Does computer support SCSI? Yes/No 1 Computer_HDD_Serial_ATA computer support Serial ATA? Yes/No 1 Computer_DVDRW computer have a DVD +/- RW? Yes/No 1 Computer_DVD Does Computer have DVD? Yes/No 1 Computer_CDRW Does Computer have CD-RW Yes/No 1 Computer_CDRom Does computer have CD-Rom Yes/No 1 Computer_Floppy computer have floppy Drive? Yes/No 1 Computer_Wired_MAC Network Card Address Text 50 Computer_Wireless_MAC Computers Wireless Mac Address Text 50 Computer_Purchase_Date Date of Purchase Date/Time 8 Computer_Domain_Name DNS Name of computer Text 50 Computer_Firewire Does computer support Firewire Yes/No 1 Computer_USB Does computer support USB Yes/No 1 Computer_Notes Notes about this computer Memo Computer_Barcode Barcode inventory Text 50 Computer_WarrantyEnd_Date Date Warranty Expires Date/Time 8 UserID Long Integer 4 LocationID Long Integer 4 MonitorID Long Integer 4 Table: tbl_Laptop Description: Field Name Description Type Length LaptopID(PK) Auto Number 4 Laptop_Manufacturer Laptop Manufacturer Text 50 Laptop_Model Computer model number Text 50 Laptop_ProductID Manufacturer Product ID Text 50 Laptop_SerialNumber Laptop Serial number Text 50 Laptop_OperatingSystem Laptop Operating System Text 50 Laptop_RAM Amount of system RAM Long Integer 4 Laptop_CPU_Type Type of processor Text 50 Laptop_CPU_Speed Speed of Laptop processor Text 50 Laptop_HDD_Manufacturer Harddrive Manufacturer Text 50 Laptop_HDD_Size Harddrive Size Long Integer 4 Laptop_HDD_SerialNumber Harddrive Serial Number Text 50 Laptop_HDD_IDE Laptopr support Serial IDE? Yes/No 1 Laptop_HDD_SCSI Laptop support Serial SCSI? Yes/No 1 Laptop_HDD_Serial_ATA Laptop support Serial ATA? Yes/No 1 Laptop_DVD Laptophave DVD Rom? Yes/No 1 Laptop_DVDRW Laptop have a DVD +/- RW? Yes/No 1 Laptop_CDRom Does the Laptop have a CDRom Yes/No 1 Laptop_CDRW Does Laptop have CD-RW Yes/No 1 Laptop_Floppy Does Laptop have floppy Drive? Yes/No 1 Laptop_Wired_MAC Laptops Network Card Address Text 50 Laptop_Wireless_MAC Laptop Wireless Mac Address Text 50 Laptop_Purchase_Date Laptop Date of Purchase Date/Time 8 Laptop_NetworkName DNS Name of computer Text 50 Laptop_Firewire Does Laptop support Firewire Yes/No 1 Laptop_USB Does Laptop support USB Yes/No 1 Laptop_Notes Notes about this computer Memo Laptop_Barcode Barcode number Text 50 Laptop_WarrantyEnd_Date Date Warranty Ends Date/Time 8 Laptop_Signature Has User Singed For Laotop Yes/No 1 Laptop_Date_U_Received Date User received Laptop Date/Time 8 Laptop_Date_U_Returned Date User returned Laptop Date/Time 8 UserID Long Integer 4 Table: tbl_Location Description: Field Name Description Type Length LocationID (PK) Auto Number 4 Location_Building Building Text 50 Location_RoomNumber Room Number Text 50 Location_Department Department Text 50 UserID Long Integer 4 ComputerID Long Integer 4 MonitorID Long Integer 4 PrinterID Long Integer 4 PeripheralID Long Integer 4 Table: tbl_Monitor Description: Field Name Description Type Length (PK) Monitor_ID Auto Number 4 Monitor_Manufacturer Monitor Manufacturer Text 50 Monitor_Model Monitor Model Number Text 50 Monitor_ProductID Manufacturer ProductID Text 50 Monitor_Size Monitor Size Text 50 Monitor_SerialNumber Monitor Serial Number Text 50 Monitor_Purchase_Date Date/Time 8 Monitor_WarrantyExpires Date/Time 8 Flat_Screen Yes/No 1 CRT Yes/No 1 Monitor_Notes Memo ComputerID Long Integer 4 LocationID Long Integer 4 Table: tbl_Peripheral Description: Field Name Description Type Length PeripheralID (PK) Auto Number 4 Peripheral_Type Type of Peripheral Text 50 Peripheral_Manufacturer Brand of Peripherals Text 50 Peripheral_Model Model of Peripheral Text 50 Peripheral_ProductID Text 50 Peripheral_SerialNumber Serial Number of Peripheral Text 50 Peripheral_Purchase_Date Date of Purchase Date/Time 8 Peripheral_Notes Notes on this item Memo Peripheral_MAC_Address Mac Address - Where applicable. Text 50 Peripheral_DNS DNS Name, Where applicable. Text 50 Peripheral_IP IP Address, Where Applicable. Text 50 Peripheral_Barcode Barcode Number Long Integer 4 Peripheral_Signature for (Camera, Camcorder etc) Yes/No 1 Peripheral_Date_U_Received Date User Received Date/Time 8 Peripheral_Date_U_Returned Date User Returned Date/Time 8 Peripheral_WarrantyExpires Date/Time 8 UserID Long Integer 4 ComputerID Long Integer 4 LocationID Long Integer 4 Table: tbl_Printers Description: Field Name Description Type Length PrinterID (PK) Auto Number 4 Printer_Manufacturer Printer Manufacturer Text 50 Printer_Model Printer model number Text 50 Printer_ProductID Text 50 Printer_SerialNumber Printer Serial number Text 50 Printer_DNS_Name Network Name Text 50 Printer_Network_Printer Yes/No 1 Printer_Slave Yes/No 1 Printer_IPaddress Text 50 Printer_Wired_MAC Text 50 Printer_Purchase_Date Printer Date of Purchase Date/Time 8 Printer_WarrantExpires Date/Time 8 LocationID Long Integer 4 Table: tbl_Software Description: Field Name Description Type Length SoftwareID (PK) Auto Number 4 Software_Company Text 50 Software_Name Text 50 Software_Version Text 50 Software_ProductID Text 50 ComputerID Long Integer 4 Table: tbl_UserInfo Description: Field Name Description Type Length UserID (PK) Auto Number 4 User_FName Text 50 User_LName Text 50 User_PhoneExt Text 50 User_CellPhone Text 50 User_Pager Text 50 User_Email Text 50 LocationID Long Integer 4 ComputerID Long Integer 4 LaptopID Long Integer 4 PeripheralID Long Integer 4 |
#3
|
|||
|
|||
Newbie table Layout (Posted as suggested by Tom Lake for feedback)
First, I want to apologize for starting a new thread in this subject. Someone else kindly brought it to my attention. Obviously, it shows my lack of
experience in communication in this type of forum. I would like to direct any greatly appreciated comments to the tread subject of "Newbie Looking for Help" Dated 12-24-05 My sincerest apologies George |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help again from Ken Snell (Query) | Randy | Running & Setting Up Queries | 22 | August 29th, 2005 08:15 PM |
Unable to edit records in a form or query | Merlin | Using Forms | 7 | May 10th, 2005 02:00 PM |
Seeking some expert advice. | HD87glide | Using Forms | 14 | March 23rd, 2005 11:11 PM |
unable to repair inobox | Sudheer Mumbai | General Discussion | 1 | February 20th, 2005 12:55 PM |
Newbie? Do I use Report or Query | John Egan | New Users | 11 | June 28th, 2004 08:31 PM |