Hi there,
I am new to MS Access and want to know is it the right software to do what i want it to do (see below).
We have five engineers who are constantly on the road and visiting properties for routine safety checks. We want to be able to database these checks and be able to have a databse that:
has all the properties that need to be checked
which then has the following sections for each address/property
appointment date arranaged (yes/no)
appointment date (date)
checked (yes/no)
date checked (date)
checked by who (engineer name)
each engineer has to have his own section that calculates the number of properties they have completed per week, which needs to auto completed by the software when each property status (above) has been completed. we will then use the engineer number of properties visited to calculate their wages etc.
also if possible, could the system allow engineers to use palm pc/pilots that they can use to enter property details 9i.e. date visited/customer signature etc.) that then auotmatically completes the database in the main office. alos it would be benficial if the engineers could also view properties that still require work on the pocket pc's.
is this possible in Access or are we looking at some sort of third party software.
any help will be greatly appreciated.
reagrds,
Mark
I am new to MS Access and want to know is it the right software to do what i want it to do (see below).
We have five engineers who are constantly on the road and visiting properties for routine safety checks. We want to be able to database these checks and be able to have a databse that:
has all the properties that need to be checked
which then has the following sections for each address/property
appointment date arranaged (yes/no)
appointment date (date)
checked (yes/no)
date checked (date)
checked by who (engineer name)
each engineer has to have his own section that calculates the number of properties they have completed per week, which needs to auto completed by the software when each property status (above) has been completed. we will then use the engineer number of properties visited to calculate their wages etc.
also if possible, could the system allow engineers to use palm pc/pilots that they can use to enter property details 9i.e. date visited/customer signature etc.) that then auotmatically completes the database in the main office. alos it would be benficial if the engineers could also view properties that still require work on the pocket pc's.
is this possible in Access or are we looking at some sort of third party software.
any help will be greatly appreciated.
reagrds,
Mark