MS Access DB for organize technicians job
$30-5000 USD
Paid on delivery
Hi all,
I need an access DB that let me organize the loading of our van and the job that my technicians have to do.
It should be pretty simple:
on the main mask I insert in columns the material they have to prepare (42" LCD, 50" Plasma screen, 63" plasma screen, DVD player, laprop, etc.), and on the row I write the name of our customers.
Example: in the line of the Customer X in the column "42" LCD" I write 2, in the column "DVD player" 1 and in the column "laptop" I write 1, so the technician know tha the Customer X wants 2 42" LCD, 1 DVD player and 1 laptop.
Then I need MS Access to create another "view" (one for each customer) where I can put information about the installation of the products for this particolar customer, for example (address where to install, details about the connection of the monitors, etc.) and all the products this customer is renting.
I know this may be a lot confusing, but as soon as I will send you the excel file I'm using right now, I know you'll understand straight away.
I'm waiting for your bid!!!
Project ID: #2743434