Hi everybody,

I am designing PC inventory database. Butbefore i do, i wanted some suggestions for my reports.
I want to be able to run the following types of reports from my database.

1- I will have a lookup table that will allow me to enter computer's condition (for example New - Good working order - needs replacement - broken)
Then i want to be able to see HOW MANY (i want to see numbers) computers i have that are really old.

2- Another report will be similar that shows how many PCs i have that have Windows 98 - 2000 - XP and Vista (again i am after numbers like 10 PCs with windows 98, 20 with windows xp) - i will have a lookup field where i can select teh version of windows

3- Similar report again that gives me the report showing office versions (example: 10 PCs with Office XP - 20 with Office 2003)

4- How many PCs are in repair? When were they sent?

5- How many PCs have anti-virus software installed. How many of those are up to date with latest virus definitions?

WHAT I NEED YOU GUYS TO HELP ME WITH IS STRUCTURE.
WHAT IS THE BEST STRUCTURE I CAN USE FOR MY DB?

I thought i will have the following tables:
PC info tble:
(which includes PC No - Windows Version - Processor - Memory - Office Version - Antivirus installed? yes/no - antivirus up to date? yes/no

Repair table:
Will have which PC No that's been sent away for repair - When it was sent - how much it will cost - repaired? yes/no

Thanks!