I have a exel file with leads and I need to create a simple access database to do the following...search for leads based on the State field. Once the leads from that state are found, I want to be able to select from x to x+1 and view them one per [login to view URL] I would like the option to save the selection to a file that that will show one lead per page, to send to sales staff. Then I want to make sure that if Staff X gets lead 1 to 10, it's tracked.
I'll be receiving new excel files on a weekly bases and would like to have the database know if the leads were already distributed to staff so I don't redistribute the same leads to others.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
## Platform
The database needs to run on MS Windows