Criminal Case Tracking

Zamknięty Opublikowano Aug 30, 2013 Płatność przy odbiorze
Zamknięty Płatność przy odbiorze

I need an Access database built!

Overview:

I work for a county in Texas. One of my main duties is to keep track of when and where District Attorney files go out, to whom they go out to, and when they come back into my possession. Basically, I need a tracking system that I can also enter new data into on a daily basis. Every morning, I have a stack of request sheets from different DA secretaries. On each request sheet is a cause number and the defendant's name. I pull these requested records and send them to the requester. I have an Excel spreadsheet right now to keep track of these records, but the data is constantly growing.

Current Excel Setup:

I have two Excel documents; one for Misdemeanors and one for Felonies.

Felonies:

CauseNumber DefendantFristName DefendantLastName DateOut RequestedBy DateIn

12-2416-B John Smith 8/30/13 Loretta

Misdemeanors:

CauseNumber DefendantFirstName DefendantLastName DateOut RequestedBy DateIn

06-0364-1 Jane Doe 4/12/13

Each year has its own sheet within the Excel document. The first two digits in the CauseNumber represents the year. If the CauseNumber ends in a number, it’s a misdemeanor. If the CauseNumber ends in a letter, it’s a felony.

Cases come in daily. Some have never been to the warehouse (where I am located), so when I enter them into the Excel spreadsheet, it’s a new record. If this is a file that went out to someone, then the date out and the name of the requester is already entered. I just add the DateIn record.

Some things to know:

A CauseNumber can have many defendants.

A defendant can have many CauseNumbers associated with their name.

I need to answer the following questions:

-Who has the file?

-When did the file go out?

-When did the file come in?

-Is this file a Multi-File? (Explained below)

-Which files are out to (particular secretary)?

Multi-File

A multi-file is a file (cause number) that is too large to fit in the box that it’s supposed to be in. I store these in a different location. I simply just need a field that specifies whether or not this file is a multi-file. The location of the multis can stay on an Excel spreadsheet.

The only table that I do have is the Secretary Table:

Secretary

SecID FirstName LastName Phone Email

I have been racking my brain for the last couple of months trying to get this database started. I have gotten further than I would have ever imagined but when it came time to run a query, I realized that I had failed. I have started from scratch trying to properly relate the tables but I am stumped. BAD. I need a pro.

I hope I have provided enough information.

Microsoft Access

Numer ID Projektu: #4879868

O projekcie

25 ofert Zdalny projekt Aktywny Oct 6, 2013

25 freelancerów złożyło ofertę za $242 w tym projekcie

illuminesoft

Do you want to keep information about Location into this database ? the IN/OUT data it will be only date ? or with time stamp needed ? We are amongst top 1% global outsourcing providers. We have successfully finishe Więcej

$216 USD w ciągu 15 dni
(238 Oceny)
7.4
torajiv

MS Access specialist here with over 100 such projects complete. Details in PM - Thanks - Rajiv

$166 USD w ciągu 3 dni
(60 Oceny)
5.6
instech

13+ years of Access/VBA programming. Please see the PM for comments and suggestions.

$28 USD w ciągu 3 dni
(7 Oceny)
4.8
expertcoder1vw

I can deliver a professional and robust database to suit your needs. Bests, Larry

$378 USD w ciągu 3 dni
(11 Oceny)
4.4
sinfulm3

Hello Sir, kindly check PMB.

$130 USD w ciągu 8 dni
(11 Oceny)
4.0
davidt999

Hi! I can do this for you. Please see PM for a sample of my work. Thanks! David

$30 USD w ciągu 7 dni
(5 Oceny)
3.9
adaytay

Access Developer for 15 years, across a range of industries... I can help! Please see PM for more information

$277 USD w ciągu 5 dni
(5 Oceny)
3.6
pddonnelly

My name is Paul and I'm a business analyst with 7 years experience building custom VBA applications and databases for one of Ireland's largest trading firms. I'd love the opportunity to discuss this bid further with yo Więcej

$150 USD w ciągu 3 dni
(2 Oceny)
3.6
dpune

Hi, I am expert in this kind of work and already completed more than 200 projects. Please look at my feedback to know more about my work. Waiting for more details. tks.

$166 USD w ciągu 3 dni
(3 Oceny)
2.0
chrishugo

I'm new to FreeLancer but not new to IT. I have 25+ years of experience in IT. I currently have my IT career on hold to homeschool my son with learning disabilities. I've done many projects in Access and this sounds Więcej

$222 USD w ciągu 3 dni
(0 Oceny)
0.0
ljupcob

We have 15 years of experience in creating and managing databases. We are your choice.

$111 USD w ciągu 7 dni
(0 Oceny)
0.0
mrintelligence

Look for LIVE DEMO in PMB for exactly similar Application

$100 USD w ciągu 11 dni
(0 Oceny)
0.0
Steponitgal

Hi there! I understand your pain - it must be very hard to keep track of all the files in Excel. Access is the tool you need. A good friend of mine is involved with policeing and I built a street crime incident t Więcej

$205 USD w ciągu 7 dni
(0 Oceny)
0.0
MSExcelPro

Specialist in design of databases and reporting. I can do that for you in Access or as an Excel Application. It can be done very quickly if needed. Really low bid because I'm new to freelancer.

$145 USD w ciągu 3 dni
(0 Oceny)
0.0
jubieta

Hello: I have been working with Microsoft Access (with VBA) since 1997. I have already been SQL Server DBA for 3 years Actually, a part of my job is being a consultant for developers and advanced users on problems th Więcej

$222 USD w ciągu 3 dni
(0 Oceny)
0.0
albertzakhia

I am ready for this project. Kindly check my PM.

$1666 USD w ciągu 30 dni
(0 Oceny)
0.0
asb31

Thank you for the opportunity to bid on this project. Please see my PM for more details.

$20 USD w ciągu 3 dni
(0 Oceny)
0.0
dbFred

I have been doing this work for over ten years. Please read my PM. It will save you money and heartache in the long and short term.

$555 USD w ciągu 3 dni
(0 Oceny)
0.0
sunshinelabs

Hello. I have a BS, live in NY, am American, have a day job, and need extra projects this month (or ASAP). You want an MSSQL (Microsoft SQL) solution, not an access database. Access is really low-end and for the sam Więcej

$555 USD w ciągu 3 dni
(0 Oceny)
0.0
akayasolutions

Hey clumz27, How are you? , look no further! Your search ends with me. I am able to build you your new Criminal Case Tracking within budget and timeframe. I would be more than happy to submit a demo, my portfolio, prop Więcej

$133 USD w ciągu 3 dni
(0 Oceny)
0.0