Simple Access database

IN PROGRESS
Bids
26
Avg Bid (GBP)
£57
Project Budget (GBP)
£20 - £250

Project Description:
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

Additional Project Description:
05/26/2011 at 9:33 EDT
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.

Skills required:
Microsoft Access
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


£ 35
in 2 days
Hire TCar
£ 65
in 3 days
£ 90
in 5 days
£ 20
in 1 days
Hire proitagent
£ 50
in 1 days
Hire bestappdev
£ 40
in 1 days
Hire Graven74
£ 20
in 1 days
Hire WesleyTheGeek
£ 75
in 2 days
Hire ronmia
£ 20
in 2 days
Hire rashid141
£ 20
in 3 days