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

Arranger of holidays crossword climber - Portfolio cover letter for english class - Insert nose radius chart - Describe in detail all the facets of jetblue's product - SMGT 501 - Analysis Paper Week 5 - The leadership experience 7th edition chapter 1 - Genius puff pastry tesco - Annual Updates - Goldfish vs cheez its - Mass of a tennis ball - Importance of play dough - 100 kva ups emerson - Durden junior joiner parts - Tombolo erosional or depositional - Achievement and success american values - Individual & dual movement HW - Meaning of unmisted by love or dislike - 15 72 in simplest form - Pqr is what type of polynomial - Readiness for enhanced breastfeeding nanda - Economics - Capsim - NEED SHORT ESSAYS FOR EACH QUESTIONS MINIMUM OF 150 WORDS IN APA FORMAT WITH CITATIONS AND REFERENCES - The financial staff of cairn communications has identified - Compare athens and sparta - Revolt in the desert pdf - Hit the target math game - Shavepate definition - Antibiotic resistance can we ever win answer key - Jdpi - Costco opti club st jerome - Korean literature in english - Psychcentral com five personality test - Organizational communication approaches and processes 6th edition pdf - Greek alphabet cheat sheet - Feynman rules for qed - Wakefield council tax number - 3-2 - Sia business class baggage allowance - Department of education regional directors - Accounts payable internal control checklist - Schwartz model organizes values into - Karla tanner opens a web consulting business - Essay - PRACTICAL CONNECTION - HRM 500 Words - Cisco 1941 end of life - How to date a browngirl junot diaz analysis - Feast watson floor paint - Research paper literature review outline - C1 june 2008 mark scheme - Wilsons prom information centre - The price of pens and pencils falls dramatically - Which of the following statements about crafting a strategy to be competitively successful - Born haber cycle definition - Manic miner class tools - Read and Answer - Food safety victoria templates - How to check baggage fare in amadeus - Persuasive techniques in advertising - Economic and business - Hyper v gpu virtualization - CT2 Essay - Individual professional development plan for teachers examples - Vold's theoretical criminology 7th edition ebook - Khan academy factoring quadratics - Julie or the new heloise english pdf - Gen Bio Lab - TLMT318 Week 4 Forum - Since you ethan derose lyrics - Red veined sorrel wikipedia - Acap master of social work qualifying - 737 800 startup procedure - New york times summer reading contest week 4 - Close reader mother tongue answers - Venture capital deal terms - Cultural Barriers - Barriers to critical thinking hum 115 - Check for understanding teach like a champion - Mckenna hall notre dame - LEGAL Forum Week 3# - MF 1 - Ronson lighter date codes - Naplan spelling list year 7 - NRS-410V-0L191 Pathophisiology and Nursing Management of Client Health. - One acre fund case study - Hugh trevor roper african history - IA week7 DB - Write an equation for the buoyancy force on the empty barge - Globalization of eating disorders bordo - Evidence for chemical change lab experiment 2 answers - Alan and marcus go forth and multiply - Budget variance analysis excel - Reflective Paper (Cloud Computing) - Amanda todd summary - Downstream processing of penicillin - Dunn inc is a privately held furniture manufacturer - C++ how to program 7 e pdf - Supply chain challenges at leapfrog case study - Connecting with Nursing Students Through Changed Making Sponsorship: A Fundamental Leap into Urgent Clever Resources - What are the administrative system