Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Wastenot recycling access

29/12/2020 Client: saad24vbs Deadline: 24 Hours

Hello,


I need a microsoft access homework, I need someone to do it in Access.




If you are an expert in microsoft access , appreciate your help.






Review the Technology Plug-In 6 - Basic Skills and Tools Using Microsoft Access. Complete exercise 1. WasteNot Recycling.




WasteNot Recycling picks up recyclables from homeowners in Boulder, Colorado. Neighborhoods subscribe to the service so that pickup is cost-effective. WasteNot provides special containers to subscribers for sorting recyclables: a blue container for paper products and a purple container for aluminum, plastic, and glass products.


Subscribers place their recycling containers on the curb for biweekly pickup. Each recycling container is weighed before being emptied. WasteNot drivers carry handheld recording devices used to track each pickup. Subscribers receive quarterly profit-sharing checks based on their contributions. If WasteNot does not make a profit, subscribers are not paid for their recyclables. If WasteNot makes a profit, subscribers share in that profit. WasteNot has asked you to help develop a relational database that will effectively track subscribers, using the data downloaded from the drivers’ devices. WasteNot has provided you with a snapshot of two tables you need to create. The Customer table shown here holds static customer information such as name, address, and phone. The Customer Record table holds data about each recyclable pickup.




Specifically, WasteNot needs you to:


1. Create a Microsoft Access database.


2. Create the tables, fields, data types, and primary key(s) for the database.


3. Create the relationship(s) needed between the tables.


4. Populate the database with the data provided above.






Click on the title link to download associated files and to submit your work






It should look like this:




Name of the datbase = WasteNot.mdb


CustomerTable: Primary Key = CustomerID


Customer ID


CustomerName


Address


Phone


C101


Jack


42nd Street


379924


C102


Jill


5th street


732564


C103


Mary


Murray Avenue


348975


CustomerRecordTable: Primary Key = ShareID


ShareID


PickupDate


Subscriber


Weight in Pounds


ProfitMade $2 per pound


Subscriber'sShare 50%


S501


11 Jan2015


Jack


10


20


11


S502


12 Jan 2015


Jill


20


40


20


S503


13 Jan 2015


Peter


50


100


50


Relationship(s) between the tables:


As the goal is to track the subscribers, we will link the field SubscriberName to the Customer Name.


where,


               Subscriber Name is the field in the Customer Record Table; and


               Customer Name is the field in the Table Customer Table.


In notation,


CustomerTable.CustomerName <-----Linked to -----> CustomerRecordTable.SubscriberName


select crt.SubscriberName, ct.CustomerName, ct.Address, ct.Phone

    from CustomerRecordTabe crt, CustomerTable ct

    where

crt.SubscriberName = ct.CustomerName;


crt is an alias for the table Customer Record Table


and ct is an alias for the table Customer Table


Tracking Subscribers Logic:




Each subscriber will be tracked using the unique Subscriber ID that is related to the customer name as explained above.

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Homework Guru
Helping Hand
University Coursework Help
Best Coursework Help
Calculation Guru
Writer Writer Name Offer Chat
Homework Guru

ONLINE

Homework Guru

Hi dear, I am ready to do your homework in a reasonable price and in a timely manner.

$82 Chat With Writer
Helping Hand

ONLINE

Helping Hand

I am an Academic writer with 10 years of experience. As an Academic writer, my aim is to generate unique content without Plagiarism as per the client’s requirements.

$80 Chat With Writer
University Coursework Help

ONLINE

University Coursework Help

Hi dear, I am ready to do your homework in a reasonable price.

$82 Chat With Writer
Best Coursework Help

ONLINE

Best Coursework Help

I am an Academic writer with 10 years of experience. As an Academic writer, my aim is to generate unique content without Plagiarism as per the client’s requirements.

$80 Chat With Writer
Calculation Guru

ONLINE

Calculation Guru

I see that your standard of work is to get content for articles. Well, you are in the right place because I am a professional content writer holding a PhD. in English, as well as having immense experience in writing articles for a vast variety of niches and category such as newest trends, health issues, entertainment, technology, etc and I will make sure your article has all the key pointers and relevant information, Pros, Cons and basically all the information that a perfect article needs with good research. Your article is guaranteed to be appealing, attractive, engaging, original and passed through Copyscape for the audience so once they start reading they keep asking for more and stay interested.

$75 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

What is meant by impairment of assets - Text - 3 methyl 3 buten 1 ol - Free online graph paper - Ethical principles in business velasquez - Intermodal expressive arts therapy - Progress notes - Up in michigan hemingway pdf - Bpay crn check digit algorithm - Inrush current limiter mosfet - How does francium react with water - Uq my si net - Grade 1 science curriculum - Into thin air comprehension questions - What was the turning point in the book of numbers - Carla furnishers retravision darwin - Advantages and disadvantages of data visualization - Finding equations of tangent lines - Asbestos removal control plan - Bankwest children's savings account - Journal Entry - How to draw an indifference curve - Trouble brews at starbucks case analysis - Analysis of health records - Hadees e kisa full - Certificate iv in video and audio systems - The corporate controller's salary would be considered - Research questions and Survey - Eng 121 week 4 discussion 2 - Food hygiene level 2 answers - Plenty ranges arts & convention centre vic 3752 - Law institue of australia - Double staggered piquet list - Baden company has gathered the following information - Mcdonald's our food your questions case study - The norton introduction to literature portable 13th edition - Nd66 drain cleaner msds - Ahmad sohrabian - Voy a nadar en la piscina necesito - Achebe an image of africa - Business Plan Project - Mansfield woodhouse war memorial - Ingrid jonker poem by sally bryer - Comparative analysis presentation - Why do bacteria produce restriction enzymes - Which statement about the free enterprise system is true - Super teacher worksheets multiplication - Week 4 discussion capstone in CJ - Jumping monkey hill plot summary - Assignment 1 (Evidence-Based Practice Paper Reflection) - Movie - Other things equal diversification is most effective when - Health Assessment Topic Brochure Project - Nucor corporation case study answers - What does a burning cross mean - Class b subnetting examples - HR - Annotated Bibliography 1 - Love vashikaran specialist In ludhiAnA +91[-!-!-9928097710] Top And Best Tantrik Aghori Baba - William shakespeare 7 stages of life poem - At penn foster expanded academic asap is - How does listing effect the reader - Exchange mail flow troubleshooter - Food webs and food chains worksheet - Practical Connection EP - Alto company issued 7% preferred stock with a $100 par value. this means that: - Chemistry: Atoms First, OpenStax - Zipcar creating value in the marketplace - Creative spark ted channel - The term "micro-macro dilemma" means that: - Award winning hospital design - Mini circuits zhdc 10 63 s+ - Filipino tattoos ancient to modern - Baloney detection kit shermer - Syne hills care home - Is calcium hydroxide corrosive - Https course apexlearning com public cpop - Krispy kreme weaknesses - Northumbria university blackboard login - Who stole the golden fleece - Rosary primary school camden - Elearning course review checklist - 2.27 repeating as a fraction - Susan bradford online vacations of america - Borders thomas king summary - Headphones and earbuds paper docx - Scsa media production and analysis - In algae what purpose do chlorophyll and accessory pigments serve - Rick stiggins learning targets - Models of urban structure - Letter Of Intent - Sonnet 43 rhyme scheme - Hplc analysis of aspirin lab - What is policy enactment - Used to carry crockery - When in the cell cycle does replication occur - The century america's time shell shock - How to calculate average voltage of square wave - 2 methyl 1 2 epoxypropane - Ideal Health Care System - Their eyes are watching god questions and answers