Access report from Excel table

$10-20 USD

Completed

Posted

almost 10 years ago

$10-20 USD

Paid on delivery

*****Please read the entire project before give a quote****** Sorry by my english, it's not my native language. I need an MS Access database that provides a report from a MS Excel table. From the original excel table the report must: -Copy 5 columns content. -Copy 3 columns content and add set as uppercase the first character and as lowercase the rest -Copy a column that contains always 2 texts "Masculino" and "Femenino" and convert to "M" and "F" -Calculate age from column that contents a birthdate. The age must be calculated using an specific date (for example, age at 30/06/2015), this date will be specified before run the report. -Create a new column containing a conditional data based on the age. For example, ages from 16 to 20 set as "WILD", from 21 to 32 set as "COOL". This data will be specified before run the report. The report must be a simple table, without format.

Data Processing

Excel

Microsoft Access

Project ID: 6064784

About the project

8 proposals

Remote project

Active 10 yrs ago

Looking to make some money?

Email address

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:

@tdavey

I have worked with Microsoft Access and Excel for many years. I am knowledgable in Visual Basic for Applications within Excel and Access. This is my first bid as at freelancer.com. I am interested in establishing a reputation through hard work and high quality results. You can contact me directly if you would like to discuss further.

$10 USD in 1 day

5.0

(1 review)

0.0

8 freelancers are bidding on average $29 USD for this job

@sergiuloghin

Hello! I understand what I must do. This project is easy for me. I am ready to discuss the details and start...

$20 USD in 0 day

5.0

(293 reviews)

7.8

@nlukovic

Hi, My name is Nebojsa and i am experienced Software developer. I can do this for you and i can start right now. I will be here if you want to discuss. Very Best, Nebojsa Lukovic

$30 USD in 1 day

5.0

(18 reviews)

5.1

@teeares

I have done a lot of projects in Excel . but although I am proficient with Access also, Access projects are hard to comeby. Most projects ask for Excel. Ofcourse this is very simple as far as Access is concerned, I am sure I wull make a good job of it. AS I understand, I first convert the Excel sheet to an Excel table, then from that create a report.

$30 USD in 2 days

4.6

(52 reviews)

5.1

@JonNxt

A proposal has not yet been provided

$20 USD in 1 day

5.0

(34 reviews)

4.9

@acronymsolutions

Hi, I have gone through your requirements and attachment as well.I am a Database programmer at CMMI-5 Company since August 2010.I am working on MS Acceess, MySql,SQL Server,Oracle database, I can do your job confidently. I am very much Interested to do your work,Please revert me if you have any concern .I am ready to start now.

$25 USD in 1 day