Excel or Access? View a technicians skills by 3 categories

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have to design a table of our technicians skills by 3 category level so it
makes it easy for the salemen to see what technician would be good for the job

Example:
Equipment (TV) - Equipment Type(Sony,Hitachi,Magnavox,etc) - Skill
Level(Electrical,Mechanical,Programming) - Technician

I need something where the salemen can bring up by Equipment Type and skills
to see which techs would be the man for the job
 
IMO use Access for something like this. Excel is good when you want to
analyze numerical data. It is not really designed for relating items together
(such as a technician to skills). For that a relational database is a much
better choice. Especially since you probably want to have a large number of
users trying to access the data concurrently. Excel is distinctly poor at
allowing concurrent access to a single point source of data.

In Access I would be inclined to set this up as paired values so that you
end up with only two or three columns in your table.
Tech Equipment Brand
John TV Sony
John TV Phillips
John Stereo Sony
Dave TV Sony

This would allow for very simple queries by equipment type or brand... You
could even make the front end in XL to access the data in the Access Tables
if you want.
 
In Access is there a way after I create my tables that I can design a Page
that is more user friendly for the salesmen so they can just bring a piece of
equipment and it will show which techs to use, my salemen are not Access
Friendly, I doubt any of them have ever used it
 
In Access you can create a form or a report that will do exactly that. I
would be more inclined to go with the report as it is a bit easier. The
report will be based off of a query that you create and the query can be
parameter driven. Or if you wish you can use XL as the front end and create a
query back to the database that is parameter driven. The user changes a cell
in XL and it retrieve back the matching values ito your spread sheet.
 
Back
Top