Computer Audit

[sdow]

Hi, I am trying to create a database to store all the computer information at
the school I work in.
I have the fields Building, Room, Staff, Subject, Processor, RAM, Make,
Serial Number, Product Key, Office, Networked (yes/no), Printer Make, Printer
Serial No, Black Ink, Colour Ink, Extra Hardware, Extra Info

Just now I have all the details in one database called 'computer audit' and
just created queries eg a query for printers, query for computer specs, etc.

However because there are IT rooms..one member of staff could have 15
computers in their room. So all the details are repeated for each
computer..eg that member of staff and her room number is listed 15 times for
each computer.

Is there anyway to create a database that will let me click on a room, and
it expands to show the computers in that room..without having the Staff's
name listed beside each computer? I think I might have to use relationships
but not sure how to go about it? Would the building no, room no, staff and
subject be stored in a seperate database??

Sorry it's difficult to explain, hope you understand what I mean though?

Thank you for your help.

 

[Chris2]

Hi, I am trying to create a database to store all the computer information at
the school I work in.
I have the fields Building, Room, Staff, Subject, Processor, RAM, Make,
Serial Number, Product Key, Office, Networked (yes/no), Printer Make, Printer
Serial No, Black Ink, Colour Ink, Extra Hardware, Extra Info

Just now I have all the details in one database called 'computer audit' and
just created queries eg a query for printers, query for computer specs, etc.

However because there are IT rooms..one member of staff could have 15
computers in their room. So all the details are repeated for each
computer..eg that member of staff and her room number is listed 15 times for
each computer.

Is there anyway to create a database that will let me click on a room, and
it expands to show the computers in that room..without having the Staff's
name listed beside each computer? I think I might have to use relationships
but not sure how to go about it? Would the building no, room no, staff and
subject be stored in a seperate database??

Sorry it's difficult to explain, hope you understand what I mean though?

Thank you for your help.

sdow,

What you want is more than one table.

Table: Staff
StaffID
FName
LName

Table: Buildings
BuildingID
BuildingNbr
BuildingName
YearBuilt

Table: Rooms
RoomID
BuildingID
Floor

Table: Components
ComponentID
Processor
RAM

Table: RoomStaff
RoomID
StaffID

Table: RoomComponents
RoomID
ComponentID


There, that's one version of a very bare-bones version of what
you'll be wanting (revision may be necessary to fit your
environment).


Sincerely,

Chris O.

 

[mscertified]

And to set up the table relationships, you go into option Tools--Relationships.
Look in Access Help for details on setting up the relationships.

Dorian

 

[sdow]

Thank You both, I'll try that.

sdow,

What you want is more than one table.

Table: Staff
StaffID
FName
LName

Table: Buildings
BuildingID
BuildingNbr
BuildingName
YearBuilt

Table: Rooms
RoomID
BuildingID
Floor

Table: Components
ComponentID
Processor
RAM

Table: RoomStaff
RoomID
StaffID

Table: RoomComponents
RoomID
ComponentID


There, that's one version of a very bare-bones version of what
you'll be wanting (revision may be necessary to fit your
environment).


Sincerely,

Chris O.