employee's PC property (1 Viewer)

[Marziya]

hi everyone,
Is there anybody to help me with making this database?
I want to keep the computer hardware ( Keyboard-Case-Monitor-Printer-Mouse) properties of every employee in access.

I create these tables that exist in the attached file.
I want to have a form to define each hardware detail and by entering for example C10 , it already knows that it is for Case and the check box for Case is filled.
also A form for entering the personnel name and their PC properties.
I should say that some of cases and keyboards and mouses are the same. but we want each of them have their unique id.
and in report I want to show each personnel with their PC properties.
and if is possible , the amount of similar keyboard , mouse, monitor, case , printer.
the amount of cases ( and other hardware) that is occupied.
and the amount of hardware that is free.
any help would be appreciated.
thank you

 

[Marziya]

please somebody help me...

 

[bob fitz]

Why are you using short text fields for your Primary Keys rather than Auto-Numbers

 

[Marziya]

Why are you using short text fields for your Primary Keys rather than Auto-Numbers

I want to define the ID like "C-10" or something like this.

 

[bob fitz]

I want to define the ID like "C-10" or something like this.

IMHO it would be better to use Auto-Numbers as PKs

What is "C-10"?

 

[bob fitz]

Also, what does table "tblInfo" represent?

 

[Marziya]

IMHO it would be better to use Auto-Numbers as PKs

What is "C-10"?

C for case
10 for the tenth record that is saved.

 

[Marziya]

Also, what does table "tblInfo" represent?

it represent that what properties does have each employee's computer.

 

[bob fitz]

it represent that what properties does have each employee's computer.

So each record in tblInfo represents a computer and its accessories, like keyboard, mouse, etc?
Does any employee have more than one computer, perhaps a desktop model and a laptop?
If not now, might this be the case at some point in the future?

 

[Marziya]

So each record in tblInfo represents a computer and its accessories, like keyboard, mouse, etc?
Does any employee have more than one computer, perhaps a desktop model and a laptop?
If not now, might this be the case at some point in the future?

at this moment some of employees have 2 monitor ، or 1 printer for 2 persons
but a laptop and a desktop for the 1 employee, I don't think so.

 

[bob fitz]

Sorry to keep questioning you but I'm trying to sort out in my own mind what relationships/ tables you have/need.

What do the following fields in tblInfo represent:
IP
AdimnUser
AdminPass
LocalUser
LocalPass

Just wondering if these are actually attributes of your Personel

 

[Marziya]

Sorry to keep questioning you but I'm trying to sort out in my own mind what relationships/ tables you have/need.

What do the following fields in tblInfo represent:
IP
AdimnUser
AdminPass
LocalUser
LocalPass

Just wondering if these are actually attributes of your Personel

thank you for your responses.

these fields is filled by operator in the related form and I don't know that should be bound control or not.
for example the IPv4 of my network is like 192.168.88.200.
each computer has an admin user account and local. and all employees just access to local user account.
and AdminUser and AdminPass is the user and password account for IT department.

 

[jdraw]

Marziya,
Perhaps you could describe in simple terms the business where these employees -whose PCs you wish to record - work.
Any info on networking, software, number of potential employees, turn over etc. would be helpful.
Good luck with your project.

 

[bob fitz]

Can you give some examples of the data you might have in the following fields:
KeyboardName
KeyboardDetail

MouseName
MouseDetail

CaseName
CaseDetail

 

[Marziya]

Can you give some examples of the data you might have in the following fields:
KeyboardName
KeyboardDetail

MouseName
MouseDetail

CaseName
CaseDetail

monitorName : Samsung
monitorDetail : LED 17 inch

 

[Marziya]

Marziya,
Perhaps you could describe in simple terms the business where these employees -whose PCs you wish to record - work.
Any info on networking, software, number of potential employees, turn over etc. would be helpful.
Good luck with your project.

In our office, there are about 30 desktops connected to our local network and employees work with them.
the IT department wants to keep and save properties of each computer.
they want to know Who works with what computer with what properties quickly.

 

[mike60smart]

hi everyone,
Is there anybody to help me with making this database?
I want to keep the computer hardware ( Keyboard-Case-Monitor-Printer-Mouse) properties of every employee in access.

I create these tables that exist in the attached file.
I want to have a form to define each hardware detail and by entering for example C10 , it already knows that it is for Case and the check box for Case is filled.
also A form for entering the personnel name and their PC properties.
I should say that some of cases and keyboards and mouses are the same. but we want each of them have their unique id.
and in report I want to show each personnel with their PC properties.
and if is possible , the amount of similar keyboard , mouse, monitor, case , printer.
the amount of cases ( and other hardware) that is occupied.
and the amount of hardware that is free.
any help would be appreciated.
thank you

Hi

You need to look at how tables are constructed.

You do not need separate tables for each piece of equipment.

All equipment would be listed in a table using the following structure:-

 

[Marziya]

Hi

You need to look at how tables are constructed.

You do not need separate tables for each piece of equipment.

All equipment would be listed in a table using the following structure:-

this table only represent the type of equipment?

 

[jdraw]

they want to know Who works with what computer with what properties quickly.

How would this be maintained?
Why Access? Have you investigated any network scanning tool(s) that could do some of this automatically?

 

[mike60smart]

this table only represent the type of equipment?

Yes that's correct.

So you have a table listing all Personnel and table listing all Types of Equipment.

Now you need a table to link Personnel to Equipment Details.

Something along the lines of:-

tblEquipmentDetails
-EquipmentDetailID PK - Autonumber Long Integer
-PersonnelID FK - Number - Long Interger (Linked to PersonnelID PK)
-EquipmentTypeID - Number - Long Integer (Linked to EquipmentTypeID PK)
-EquipmentSerialNo
-EquipmentMake
-EquipmentModel

This is just a rough guide