An access database contains a number of documents, in excel, word, pdf etc and in all different versions (doc, docx, xls, xlxs etc).
The requirements are as follows:
1. A front end screen to an access database – screen mock-up in page 2 and the requirements for the screen fields are in Table 1 Page 3. The front end does not need to be developed in Access
2. The front end will be installed on employee’s laptops/pcs but the database will not – need an install EXE file?
3. Need instructions on how to install the front end
4. The user clicks on any of the document link – on any field in the results table (results screen format shown in table 2)– and the document will open in the appropriate format. Note – the installation needs to take account of users having different versions of MS Office / PDF software etc. If this is going to be a problem we need a facility to change the path pointing to the corresponding application.
I’ll supply you with a dummy database and once you’ve completed the development we can switch over to the real version – the database is huge as some of the documents are very large. We’ll need some facility, therefore, to change the location/name of the database.
Front end screen has the following fields
field 1: Search Field - Seach whole database for exact match Not case sensitive
Field 2: Dropdown List
Field 3: Dropdown list Must select field 2 before selecting –
Field 4: Dropdown list Must select field 3 before selecting -
Results screen - will depend on the level of search. If search not refined then 1st level displayed where you can drill down into different levels
Company 3 etc
Category 3 etc
Doc cat 1 llist Checklist_protector Aaaa
Doc cat 2 Form Specific Form ZINSVT_(*&^&
Doc cat 2 Form Specific form 2 BFUQ Q987
Doc cat 2 Brochure Product Features XI3598237498723
Doc cat 1 Brochure Product Guide Xlejroeiurjo34i
17 freelancers are bidding on average $196 for this job
Dear Sir, I am Access Professional Software Developer, I am Linux Advanced Developer, I am Database Developer and designer. I can Handle your job and do everything extremely Grate. Regards,