A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Newbie table Layout (Posted as suggested by Tom Lake for feedback)



 
 
Thread Tools Display Modes
  #1  
Old December 25th, 2005, 07:04 AM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default 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  
Old December 25th, 2005, 07:52 AM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default 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  
Old December 25th, 2005, 05:44 PM posted to microsoft.public.access.forms
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 02:21 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.