Microsoft Access Database for Filing System

We need a simple Microsoft Access database to track the location of files in our office and an offsite location. We are a legal firm.

Our office filing system is setup as follows. Each matter has a unique matter number which is assigned by another system.

We have a few locations:

Lawyers desk (onsite)

Central Storage Filing Cabinet (onsite)

Offsite storage

We have five statuses of files:

Active: files are files that are actively being worked on by the lawyer (located at lawyer's own desk)

Keep in View: files that do not require immediate action but need to be followed up kept onsite. (stored at Central Filing cabinet onsite)

Dormant: files that may be dormant for several years but still have some follow up matters to do (stored in offsite location)

Closed: files that have been completed (stored in offsite location and destruction date set for 10 years from the date of closing).

Destroyed: files that have been closed and physically destroyed.

There are two categories of files:

Litigation: those that involve court work

General: everything else

These files will be physically segregated according to the two categories although they are stored in the same location. For e.g. Cabinet A in offsite location has all the Litigation files and Cabinet B has all the General files.

The Microsoft Access Database has to:

a) Be able to easily enter in new Matters and optionally key in the First Party and Second Party of the matter. We should also be able to enter a Category (there will only be two categories at the moment Litigation and General).

b)Track the movement of the physical location of the files and note who has taken the files. Also if taken from Central Storage or Offsite Storage, set a date for it to be returned.

c) If file is put into KIV or Dormant, to optionally set a follow up date.

d) To be able to query for files that need to be destroyed, returned or followed up.

e) Flexibility to add in more locations if we add in more offsite/onsite storage.

f) Form must support batch movement and entry of files (since we may be moving hundreds of matters from Central Storage to Offsite.)

g) For files that have been physically destroyed to record the destruction dates (must be easy to do this in bulk for e.g. if from the query that the closed files need to be destroyed, we should be able to mark all the files

We also need preliminary advice as to how to integrate this system with a barcode system to reduce human error in checking in and out documents. Please let us know in your bid if you'll be able to advise on this (optional).

Evner: Microsoft Access

Se mere: microsoft access filing system, database filing system, filing system access database, access database filing system, access filing system, access database filing, filing system access, filing system microsoft access, filing system database access, filing system database, legal file database, database filing, microsoft access filing, microsoft access office filing system, legal access database, filing database access, access database central filing system office, file cabinet access database, human error filing system, access filing, access database track files filing system, lawyer database access microsoft, microsoft access filing cabinet, access office filing system, central filing system access database

Om arbejdsgiveren:
( 10 bedømmelser ) Kuching, Malaysia

Projekt ID: #967975

Tildelt til:


Please check PM for more details - Thanks

$100 USD in 10 dage
(54 bedømmelser)

22 freelancers are bidding on average $203 for this job


Please check PM!

$245 USD in 5 dage
(49 bedømmelser)

Please check the personal message.

$200 USD in 5 dage
(14 bedømmelser)

Hello Ready to start right now. Please see your PMB for details. Thanks

$150 USD in 10 dage
(22 bedømmelser)

I have been developing applications in MS Access since the year 2003. I can take up this project immediately. Thanks [url removed, login to view]

$360 USD in 30 dage
(3 bedømmelser)

have a glance at PM. Regards,

$250 USD in 8 dage
(10 bedømmelser)

We have done many projects in MS Access. Your requirements are clear enough to start this project. Thanks

$200 USD in 5 dage
(12 bedømmelser)

see pm please

$500 USD in 10 dage
(1 bedømmelse)

Hi there, What your are looking for is a file tracking system. I developed an application for a leading charity for health and medical/legal in uk a file tracking system and am sure I need to customixe the applivaet Flere

$235 USD på 1 dag
(1 bedømmelse)

Ready to start right now.

$250 USD in 10 dage
(2 bedømmelser)

please see PMB for details

$300 USD in 18 dage
(1 bedømmelse)

we hav ea already built in system for tracing files in cabinets, we can do the demo whenever you what and make the necessary chagnes as you need. Please connect with me through PM.

$200 USD in 3 dage
(0 bedømmelser)

Please See PM

$75 USD in 5 dage
(0 bedømmelser)

Sir, Please see PMB

$250 USD in 30 dage
(0 bedømmelser)

Sir, Plz see your pmb for more detail.

$220 USD in 15 dage
(0 bedømmelser)

Hello, Please see PM. Thank you, Emmett

$150 USD in 7 dage
(0 bedømmelser)

Good Morning, Loos Consulting is excited to submit our customized proposal for your project. We have reviewed your project specifications and feel we are in a great position to deliver the services you need within bu Flere

$200 USD in 7 dage
(0 bedømmelser)

Please Check PM

$150 USD in 15 dage
(1 bedømmelse)

Deliverables: 1. Access database, with all tables defined and structural tables populated 2. Form for entering file information 3. Form for querying files by status 4. Form for querying an individual file and Flere

$180 USD in 5 dage
(0 bedømmelser)

I am what you are looking for.

$250 USD in 8 dage
(0 bedømmelser)

See PMB for this solution

$200 USD in 5 dage
(0 bedømmelser)