Do some Excel Work
$10-30 USD
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.
Project ID: #10063229
About the project
10 freelancers are bidding on average $23 for this job
I have the expertise n Access and can do this task of queries, quickly an effectively. Ready to start work now.
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.
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
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