Do some Excel Work

Closed Posted Mar 27, 2016 Paid on delivery
Closed Paid on delivery

(Must be an expert in microsoft access)

2. WasteNot Recycling

WasteNot Recycling is an organization that picks up recyclables from homeowners in

Boulder, Colorado, as introduced in Plug-In T6. The CUSTOMER table holds static customer

information such as name, address, and phone. The CUSTOMER RECORD table holds data about each recyclable pickup. Enough test data has been added to each table to test queries

(use the [login to view URL] file associated with this text).

The owners of WasteNot Recycling have asked you to assist with creating several queries.

Specifically they need you to do the following:

1. Create a query using the CUSTOMER data that will select records for customers who

had their first pickup in May 2004. Sort the records by customer’s Last Name. Save the

query as May Pickup Query.

2. Create a query on CUSTOMER RECORD to determine the total weights of paper and

other products each customer has had picked up. Use the CUSTOMER Last Name and

First Name in the query. Save the query as Customer Weight Query.

3. Create a query using the Name, Street, Address, and Weight fields from the CUSTOMER

DETAIL table. Enter the criteria that will select customers with less than 10 pounds in

either recyclable field. Save the query as Low Volume Query.

Data Entry Data Processing Excel

Project ID: #10063229

About the project

10 proposals Remote project Active 7 years ago

10 freelancers are bidding on average $23 for this job

paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have some queries. I have 7 years’ experience designing and developing databases and dealing with SQL queries. I would approach your pro More

$25 USD in 1 day
(329 Reviews)
7.9
surekash7096

I have the expertise n Access and can do this task of queries, quickly an effectively. Ready to start work now.

$25 USD in 1 day
(67 Reviews)
5.4
Nhcuong

I can do it, have more than 10 years in programming and database design. Please send the mdb file, i could not find it. The project is small so please make the milestone for the whole amount requested.

$25 USD in 1 day
(23 Reviews)
4.9
ENRICOJ

HI. I AM ENRICO I WOULD BE HAPPY TO WORK ALONG WITH YOU ON THIS PROJECT. MY SKILLS INCLUDE WEB SCRAPPING ,MS ACCESS,MS EXCEL AND VBA. PLEASE FEEL FREE TO CONTACT ME FOR FURTHER ASSISTANCE . LEAVE ME A MESSAGE,I WIL More

$30 USD in 1 day
(3 Reviews)
3.1
haseriki2001

As a System analyst/Database developer, i have more than 10 years hands on experience in using and working with ms access/vba in designing and developing database applications. I am thoroughly knowledgeable in system a More

$23 USD in 1 day
(1 Review)
0.6
joelrinkoff

Colorado resident looking to do some work for a Colorado company! I will have no problem supplying you with the queries you need (see SQL exam 90% grade score). I'm an expert in T-SQL which translates into MS Access. I More

$19 USD in 1 day
(0 Reviews)
0.0