Đã hoàn thành

Simple Access database

Simple Access database required:

Daily data to be imported by csv 10 fields one of which will be a unique field numeric but starting with 09

Database has to perform two mathematical functions on data input

Database maintenance: Input screen with 10 fields one of which will be a unique field numeric but starting with 09

Reports : Normal reports: Query by Date range, High-Low / Low High on

I could do this in FoxPro in 10 minutes but Access fries my brain

More detailed description :
We receive two csv files a day from 2 separate telephone companies. The fields are:

1 TelNumber: unique label (its 11 character numeric but starts with a zero and is on every record example 09091234567)
2 Date : Call date
3 Number: Number of calls
4 Seconds: ( as in seconds made on a telephone call)
5 Minutes: -calculated field (value of field 4 divided by 60 to show minutes)
6 Gross: monetary field which is in £ GBP per minute, as a label no calculations from this
7 MSISDN: unique telephone mumber inbound ( not on every record)
8 A/C :label
9 Nett RV: value such as 0.05 or 0.85
10 Revenue: Calulated field ( contents of field 5 x field 9)

Report to show:

The report needs to be date range searchable ( Start Date, finish Date) and to be summarised so Revenue, calls and minutes on any given date range can be displayed.

In addition the report needs to be rankable on field 1, sorted low/high over a date range. ( So that the most called number ( field 1) can be shown along with revenue from that number according to the date criteria chosen

A simple screen for importing the data into the application is also required.
For maintenance of the existing data this can be performed wither directly to the access table or via a custom screen.

Please read the specification carefully.

Kĩ năng: Microsoft Access

Xem nhiều hơn: range query, daily access, simple query, simple csv, numeric, foxpro, c# with access database, c with access database, access microsoft, access database, foxpro database, foxpro csv, access functions, input data database, csv screen, access daily, unique simple, access simple, database input screen, simple foxpro database, data input screen, access maintenance database, required access database, database access required, simple microsoft access database

Về Bên Thuê:
( 1 Nhận xét ) Chisinau, Moldova, Republic of

ID dự án: #1071560

Được trao cho:

Graven74

This is pretty basic, I just did a huge project that did this stuff again and again.

£20 GBP trong 1 ngày
(1 Nhận xét)
1.0

26 freelancer đang chào giá trung bình £57 cho công việc này

florinserban

Hi. Please check PM for details. Thanks!

£35 GBP trong 2 ngày
(12 Nhận xét)
4.2
TCar

Hi, please see PM.

£65 GBP trong 3 ngày
(6 Nhận xét)
4.2
braghunath

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]

£90 GBP trong 5 ngày
(3 Nhận xét)
4.1
piyushdpatel

Hi This is Piyush Patel I have 6 yrs of Exp in VBA,VB6,VB.net,SQL and MsAccess. I have developed many applications in VB6,VB.NET. Please Check My PM

£20 GBP trong 1 ngày
(7 Nhận xét)
3.8
proitagent

Hi, I am a Lonodn based database developer and can easily do the job and devliver the task in about 24 hours. REgards

£50 GBP trong 1 ngày
(1 Nhận xét)
1.7
bestappdev

With more than 12 years experience in developing enterprise systems using Access I'd be able to complete this simple project quickly and effectively.

£40 GBP trong 1 ngày
(1 Nhận xét)
1.2
deepaknegi18

Please Check PMB.

£60 GBP trong 2 ngày
(0 Nhận xét)
0.0
sandeep0734

please read my PM

£150 GBP trong 6 ngày
(0 Nhận xét)
0.0
ZhiZhang

hi I have ten years experience on MS Access. I have done serven Access DB for client in 2009 also I have five years in MS Access 2003 and Access 2007 I am sure I can do it well. Let us start now. look f Thêm

£250 GBP trong 5 ngày
(0 Nhận xét)
0.0
neelesh2000

Updated bid. I would be interested to work with you on your Access project. Please check PM and sample work

£35 GBP trong 4 ngày
(0 Nhận xét)
0.0
Mzakapal

Will complete project ASAP. I have extensive experience with Access.

£70 GBP trong 2 ngày
(0 Nhận xét)
0.0
rashid141

I can provide the sample applications for your review.

£20 GBP trong 3 ngày
(0 Nhận xét)
0.0
ronmia

HI, im a new freelancer. pls consider me for this project and make this one my first ever project here. i really want to have part time jobs like this and i believe i can deliver this one having my 7+ years doing MS Ac Thêm

£20 GBP trong 2 ngày
(0 Nhận xét)
0.0
WesleyTheGeek

I have been a data analyst for many years and I could produce a very useful database for you in regards to this request.

£75 GBP trong 2 ngày
(0 Nhận xét)
0.0
nazirulgc

Please see the PM box.......

£29 GBP trong 7 ngày
(0 Nhận xét)
0.0
ayien

i am a rensponsible man,, send me the the example..i think i can do it... thanks

£30 GBP trong 1 ngày
(0 Nhận xét)
0.0
softweb1

hello, I must inform you that I am an expert in ACCESS. read my MP THANKS

£20 GBP trong 1 ngày
(0 Nhận xét)
0.0
mtluan

I have more experience in this area,I can done,let trusts me thks

£20 GBP trong 1 ngày
(0 Nhận xét)
0.0
Shinrabanshou

let me help

£100 GBP trong 10 ngày
(0 Nhận xét)
0.0
RoyalCrownzy

Hi, Please let me do this job, I have sufficient working knowledge of Access to perform this project. Thanks.

£30 GBP trong 1 ngày
(0 Nhận xét)
0.0