Closed

Front end to Ms Access to reference database

This project received 18 bids from talented freelancers with an average bid price of $194 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
$30 - $250 USD
Total Bids
18
Project Description

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.

Approach.
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
Company 1
Company 2
Company 3 etc
Category
Category 1
Category 2
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

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online