Find Jobs
Hire Freelancers

Access Data Base

$30-250 USD

Completed
Posted over 10 years ago

$30-250 USD

Paid on delivery
I need someone to go to [login to view URL] and download the SMS summary results for intra state and inter state carriers. Also download the Motor Carrier Census information. There will be two different types of information for carriers based on the same DOT number - i want one company record for each dot showing the information with each dot number. I hope this makes sense? I NEED ALL THIS INFORMATION TO BE ENTERED/IMPORTED INTO AN ACCESS DATA BASE THAT WILL ALLOW ME TO SEND EMAILS/LETTERS RUN REPORTS BASED ON THE DOT NUMBER AN EXAMPLE WOULD BE I NEED A TO QUERY EVERY CARRIER IN FLORIDA WITH A HOURS OF SERVICE BASIC SCORE OVER 70. IF YOU COULD ALSO BUILD BASIC QUERIES - LETS SAY FOUR FOR ME THAT WOULD BE GREAT :) ***Motor Carrier SMS Results These files contain the current SMS results for all active motor carriers. Each zip file consists of two files: 1. A comma delimited “flat” data file with inspection summary data and the SMS results for each publicly available BASIC for each carrier with an active USDOT number. 2. A text file that describes the contents of the data file. ****Motor Carrier Census Information This file contains a subset of FMCSA registration data for all motor carriers. The zip file consists of two files: 1. A comma delimited “flat’” data file with the following information: USDOT Number, company name, address, contacts, number of Power Units, number of drivers, and other registration information. 2. A text file that describes the contents of the data file.
Project ID: 5276584

About the project

14 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
UPDATE: HERE IS LINK TO EXCEL FILES OF DATA WITH INSP SCORE OVER 70 [login to view URL] I have already downloaded the files and imported them to Access. Please see an output file that combines [login to view URL] and [login to view URL] at this dropbox link. [login to view URL] Can add the queries to this - up to 10 would be included in this bid amount. Please let me know if you need any more alrifications/answers. regards Rajiv
$120 USD in 3 days
4.9 (153 reviews)
6.8
6.8
14 freelancers are bidding on average $125 USD for this job
User Avatar
Hi.. I have gone through your project details and feel comfortable in taking up the task. I have done several MS Access projects and can provide you desired output in well time frame. Waiting for your response to discuss further on the project to start the work. Thanks.
$133 USD in 4 days
4.8 (97 reviews)
5.9
5.9
User Avatar
Dear Sir, I'm expert at access,and i'm interesting in on your project. I've imported files into access db its size 679MB, and i'm ready to create search for,But message me to do what you exactly wants. Kind Regards, NourElDeen
$100 USD in 2 days
5.0 (54 reviews)
5.4
5.4
User Avatar
Please let me know if you are okay with my bid price ====================================================================================================
$123 USD in 3 days
5.0 (11 reviews)
4.2
4.2
User Avatar
HI Contact me for an efficient, well documented and perfect solution and development of your project. I ensure quality work with always on time delivery of project and dedicated support and follow up. Thanks Farah Saif
$103 USD in 2 days
5.0 (3 reviews)
3.3
3.3
User Avatar
I am ready to work on this task Tx
$94 USD in 3 days
5.0 (3 reviews)
3.0
3.0
User Avatar
Aucune proposition n'a encore été fournie.
$210 USD in 3 days
3.1 (6 reviews)
4.1
4.1
User Avatar
A proposal has not yet been provided
$155 USD in 3 days
5.0 (1 review)
0.9
0.9
User Avatar
A proposal has not yet been provided
$180 USD in 3 days
5.0 (1 review)
1.0
1.0
User Avatar
I am available right now. I am a expert Database Architect. I have done lots of database design and development for desktop and web based applications using .Net, LAMP, Flash Action Script, HTML 5, Java Script, JQuery, AJAX, CSS, XML,DNS, IIS(Admin),Oracle PL-SQL,Classic ASP, MS SQL (DBA,T-SQL),VB 6.0,VBA,COM/DCOM,VB Script,MS Access, Excel, Macros, Flash (AS2, AS3), Crystal Reports (Designer and Server), ColdFusion
$250 USD in 3 days
5.0 (1 review)
0.6
0.6
User Avatar
Hi I am expert in Access databases. I can download and append data in Access and create the required quries. Ready to start. Waiting your response. Thanks.
$45 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Sir, I am hard working , honest , reliable freelancer . I am experienced in MS Access I have a solid understanding of MS Access and ready to solve any kind of Excel problem .
$35 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I am a software engineer with over 5 years of experience in MS Access, MS Office, VBA (Macros), Oracle and other technologies. I can build the database and the queries as required by you. Please get back to me if you are interested in working with me. Looking forward to discuss further regarding the assignment. Thanks and Regards, Nrupesh
$125 USD in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Tampa, United States
4.9
10
Payment method verified
Member since Jan 2, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.