WellingtonIS
asked on
Creating an access database
I want to create an access database with the following information:
PC NAME
Software installed
Icons
IP address
Department
I basically want to have a table where the machine name pops up and I have pull down menus to added the software and desktop icons and a pull down for the departments. The IP can be added. I'm trying to find some information on how to go about this. Can someone point me in the right direction.
PC NAME
Software installed
Icons
IP address
Department
I basically want to have a table where the machine name pops up and I have pull down menus to added the software and desktop icons and a pull down for the departments. The IP can be added. I'm trying to find some information on how to go about this. Can someone point me in the right direction.
ASKER
So create a table with a list of software, a table with a list of Icons and a table for the departments?
How would you keep track of what is installed on a PC?
That's why you need to have TBL_Installations which links the PC and the software. I assume that each icon goes with some software, so you don't need a separate table for that.
That's why you need to have TBL_Installations which links the PC and the software. I assume that each icon goes with some software, so you don't need a separate table for that.
ASKER
no some of my icons are just shortcuts for web based programs. Is there a website I can vist to see just how to create this stuff? It's been a while since I've done this.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks I'll do some research
TBL_PCS
PC Name
IP Address
DepartmentID (FK)
TBL_Department
DepartmentID
Department
TBL_Software
SoftwareID
SoftwareName
Icon
TBL_Installations
PCName (FK)
SoftwareID (FK)
InstallationDate (maybe)
etc