Create microsoft access database

Assignment Help Database Management System

Reference no: EM1358100

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, fi elds, data types, and primary key(s) for the database.
3. Create the relationship(s) needed between the tables.
4. Add two additional customer records, one with your name (MICHELLE FITZHENRY & SARAH PHIPPS) and one with a friend's name. (MICHELLE FITZHENRY & SARAH PHIPPS)

Add an additional 14 records to the Customer Service record table. These records should indicate service dates in January and February of 2007. They should also be related to existing customers in the Customer table (including the customer record for you and your friend).
5. Populate the database with the data provided above

Reference no: EM1358100

Questions Cloud

What size of the labor force in a community : The size of the labor force in a community is 500, and 400 of these folks are gainfully employed. In this community, 100 people over the age of 16 do not have a job.

Roi and persuasive arguments to see more possibilities : You manage an investment center (evaluated based on the return on investment). Your production manager brings you a potential deal, a large piece of equipment that can help the company save money.

Financial statement application : The information from these statements is used to analyze and establish budgets, forecast, variance reports, and ratios, among other things, with the key being that they are only used internally)

Evaluate the firm approach to pollution control : Loren Seguara and Dale Johnson both work for Sports Products, Corporation, a major producer of boating machine and accessories. Loren works as a clerical assistant in the Accounting Department, and Dale works as a packager in the Shipping section.

Create microsoft access database : Create a Microsoft Access database. Create the tables, fi elds, data types, and primary key(s) for the database. Create the relationship(s) needed between the tables.

Show classify labor costs : Explain how would you classify these labor costs: Variable, Mixed, Step or Fixed Costs? Please defend your classification.

Developing a tax file memorandum : Donovan Corporation, a calender year-end company, operates a profitable division in Jurisdiction A. In January 2010, Jurisdiction A enacted a tax law that changed the tax rate structure from 30% to 35%. Develop a tax file memorandum for a client ba..

Treatment plan for an individual having schizophrenia : How do you present a treatment plan for an individual who has schizophrenia using family focused therapy and CBT?

How fast something is moving and in direction it is moving : assume that you are swimming in a river while a friend watches from the shore. In calm water, you swim at a speed of 1.25 rm m/s . The river has a current that runs at a speed of 1.00 rm m/s.

User Account

All Pages