Create a form called customers

Assignment Help Database Management System
Reference no: EM13867644

Access Assignment

Instructions

1. There are three parts to this assignment: WasteNot Recycling, Scale Classic Cars, and Seminar Database Design (ERD).

2. You will need to use Microsoft Access for this assignment for the queries, reports and forms. Microsoft Access is available for the Windows version of Microsoft Office only. If you do not have Microsoft Access, it is available in all of the computer labs.

3. Download the Access.zip file from Desire2Learn. Extract all of the files and rename the database to databasename_yourinitials.mdb. For example, I would rename the WasteNot Recycling database to WasteNot_DKT.mdb. This is the database used to create your answers for the queries, reports, and forms.

4. You will need to add your name and the date to each report.

5. For the Seminar Database Design, you can use Microsoft Word for the Database Design answers (or Microsoft Visio or an illustration program). If you use Microsoft Visio or an illustration program, please save your answers as a PDF. Use the information in the description to create your answers.

6. Each answer is worth 5 points.

7. For the Seminar Database Design answers, you can print to a PDF by using the doPDF printer in the labs or you can use Microsoft Word.You must upload your Access answers in Access database format.

8. Please put all of the documents and the final database into a folder using Access_yourinitials for the name (mine would be Access_DKT). Compress this folder using Windows 7's built-in compression utility and upload the compressed folder to Desire2Learn.

WasteNot Recycling

WasteNot Recycling picks up recyclables from homeowners inBoulder, Colorado. The CUSTOMER table holds static customer information such as name, address, and phone. The CUSTOMER RECORD table holds dataabout each recyclable pickup. Enough test data has been added to each table to test queries and create forms and reports (use WasteNot.mdb). The owners of WasteNot Recycling have asked you to assist with creating several queries, a form, and a report. Specifically they need you to do the following:

1. Create a query called "01-May Pickup" to list customers whohad their first pickup in May 2004. Sort the records by customer's last name. Include the following fields:
a. Last Name
b. First Name
c. Street
d. City
e. State
f. ZipCode
g. Phone
h. FirstPickup

2. Create a query called "02-Customer Weight" to determine the total weights of paper and other products each customer has had picked up. Include the following fields:
a. Last Name
b. First Name
c. SumOfWeights (Paper)
d. SumOfWeights (Other)

3. Create a query called "03-Low Volume" to display customers with less than 10 pounds in either recyclable field. Include the following fields:
a. Last Name
b. First Name
c. Street
d. City
e. Weight Paper
f. Weight Others

4. Create a form called "Customers" that allows the owners to enter data into the CUSTOMER and CUSTOMER RECORD tables. You can choose the design (aesthetics), however, locate an appropriate graphic to include on the form. All controls must be aligned and sized properly.
a. Customer ID
b. Last Name
c. First Name
d. Street
e. City
f. State
g. ZipCode
h. Phone
i. FirstPickup
j. CUSTOMER RECORD

5. Create a report called "Customer Weights" that groups and sums records by customer. Include your name, the date and time as well as the following fields:
a. Last Name
b. First Name
c. Service Date
d. Weight Paper
e. Weight Other

Scale Classic Cars

Johnny Krol runs a body shop specializing in restoring classic cars. Johnny owns threeand began collecting scale models when his wife put her foot down and said no to building more garage space.

The Scale Classics Web site began as a technology class project for Johnny's son J.J., who created a basic text and graphics informational site. Johnny liked the site, but wanted a complex site dedicated to the serious collector. He envisioned a storefront, auction house, and collector's forums.Unable to find such a site, Johnny hired a local consultant to build the site, found a processing house to manage orders and payments, and began shipping scale models from the body shop.

The storefront largely contains American classic cars, which come in 1/18, 1/24, 1/43, and 1/64 scale. Popular foreign cars are also available. Johnny has hired you to create some business analysis queries, a form and a report using his database, ClassicCars.mdb. Specifically, he wants you to:

1. Create a query called "01-Coupe" to show records with "coupe" in the model name. Include the following fields:
a. Make
b. Model

2. Create a query called "02-Less than $35" to show models that cost less than $35 and sort from highest to lowest price. Include the following fields:
a. Car ID
b. Make
c. Model
d. Price

3. Create a query called "03-Model" that lists cars grouped by their make. Sort by model and calculate the average price for each make. Include the following fields:
a. Make
b. Model
c. Price

4. Create a form called "Catalog" that allows Johnny to enter new classic cars and update existing records. Use a Columnar format and the Sandstone style. Include the following fields:
a. Car ID
b. Make
c. Model
d. Scale ID
e. Price

5. Create a report called "Cars by Model" that lists cars grouped by their make. The report should display all fields from the CATALOG table, sort by model name, and calculate the average price for each make. Use the Formal style. Include your name, the date and time.

Seminar Database Design (ERD)

Instructions

You can use Microsoft Word for the Seminar Database Design answers. Use the information in the description to create your answers. If you draw your diagrams on a piece of paper, then please scan the drawings or photograph them and add them to your Word document.
Please answer the questions based on the information in the Description. Note that this is hypothetical and not based in reality.

Description

In conjunction with taking an introductory computer concepts course, DePaul has decided to test the idea of offering weekend seminars to cover the basics of the Internet and the Web. Initially, DePaul will offer two such seminars:

• Web101 - The Basics of the Web and Internet
• Web205 - Building a Web Site

Web101 will have five different sections, and Web 205 will have four different sections.

Although they are not required to, students can enroll in one or both seminars. The seminars are held for eight hours on a single day. There is no cost associated with taking the seminars. One teacher, from a pool of qualified teachers, will be assigned to each section of each seminar. Some teachers will obviously not be assigned to teach any of the sections, and some teachers may be assigned to several different sections.

Finally, the system should track the final grades assigned to each student. One more thing, DePaul is simply testing this idea in this particular term. So, do not worry about the term (e.g., Fall, Winter, Spring, or Summer) or the year.
Business Rules

1. Record as many business rules as you can based oninformation in the description.
Entity Classes

1. Create a simple two-column table that lists all the entity classes in the left column and their associated primary keys in the right column.

Entity Relationship Diagrams

1. Define and draw the basic relationships among the entity classes.
2. Define among which of those entity classes relationships exist and then write some verbs that describe each relationship just as in Figure C.4 in the textbook.Draw these.
3. Define and draw the relationships among the entity classes as in Figure C.6 in the textbook.
4. Define and draw the cardinality among the entity classes as in Figure C.8 in the textbook.
5. Provide a narrative description of each numerical relationship in Question 4.
6. Eliminate the many-to-many relationship between Student and Seminar Section by creating acomposite entity. Follow the guidelines in the text. Name the composite entity.
7. Draw the entity relationship diagram for Question 6 including the composite entity from Question 6, Student and Seminar Section. Use Figure C.7 as an example.
8. Create a table for the Student relation. Fill in the column headings by identifying what information belongs in the Student relation. Use simple attributes. Then, add some data in the remaining rows. Limit it to five rows of information.

Attachment:- Assignment.rar

Verified Expert

The task of the assignment involves solving the Microsoft access database. The task involves 4 parts. Part 1, Part 2 and Part 4 involves creating database in access database and creating queries, forms and reports using the tables in the database. The Part 3 invlves doing data design model for the Seminar database. All 4 parts are complete and outputs are attached in the documentation of the assignment.

Reference no: EM13867644

Questions Cloud

Find the items delivered by all suppliers : Using Access(or your class SQL Server account) create the SQL queries to answer the following questions from your textbook exercises at the end of the Reference 2 chapter which is immediately before Chapter 11.#51 is not in your text. Find the ite..
Plan and execute an interaction design project : Plan and execute an interaction design project at advanced level in the chosen BIT field, individually or in small teams, within the time and resource limitations at hand.
Compute an appropriate measure of central location : Big Orange Trucking is designing an information system for use in "in-cab" communica- tions. Compute an appropriate measure of central location for the variables wind direc- tion, temperature, and pavement.
Brief a medical organization''s executive team on ehr : You are health information management professional who has been asked to brief a medical organization's executive team on the topic of electronic health records (EHR)
Create a form called customers : Create a form called "Customers" that allows the owners to enter data into the CUSTOMER and CUSTOMER RECORD tables. You can choose the design (aesthetics), however, locate an appropriate graphic to include on the form. All controls must be aligned..
What is the breakeven amount : Alternatively, the company can outsource ad development at a fee of $20 per ad regardless of the quantity. The current interest rate is 8% per year. What is the breakeven amount, and which alternative is economically better?
What is the geometric mean annual increase for the period : The information below shows the cost for a year of college in public and private colleges in 1980-81 and 2007-08. What is the geometric mean annual increase for the period for the two types of colleges?
View of mentoring in light of leadership motivation theories : Discuss the value of mentoring in light of leadership motivation theories - Are mentoring, coaching, and discipling the same? If not, what are the advantages of each?
Choose a proplem that a famous company face : You guys to choose me a proplem that a famous company face and how we fix it by technology

Reviews

inf867644

4/16/2018 5:56:13 AM

I just want to know the files types of the solution attachments. When will I receive my order? Ok. Thanks for the feedback. To clarify, the instructions for the assignment are detailed on the web page, not the instructions in the rar file. Thanks. I don’t have these things. Here it is 27785752_1AcademicSoftware Data.xlsx When will it all be done?. It was great getting served by you. Thank you very much for the great support.

Write a Review

 

Database Management System Questions & Answers

  Create a database named ctsdb studentid

Create a text file named Create_ StudentID .sql (for example, Create_3087654.sql) that will contain SQL statements to: Create a database named CTSDB StudentID.

  Create a relationship between the employees and sales tables

Create a relationship between the Employees and Sales tables. Save the relationship. A form and subform of sales by the salesperson. Name this form Employee Sales. Use the attached layout on page 5. (use the Zoom icon to make form readable)

  Explain techniques for distributed data placement

Create a diagram using Visio, Microsoft Paint, or other graphical creation utility of your choosing to illustrate the diagrams supporting your conclusion. Note: The graphically depicted solution is not included in the required page length.

  Design diagram data warehouse using star schema

Assume that data warehouse consists of three dimensions time, customer, and cell phone plan, and two measures number of calls and cell phone bill. Sketch a schema diagram for above data warehouse using star schema.

  List different entities-objects-logical processes-data flows

List the different entities or objects, logical processes, data flows, and data stores that are involved, starting from the time you submitted your time sheet.

  How to change content in order for new list

To what kind of list would you change it? What would you require to change about content in order for new list type to be effective for purpose of list?

  Write sql statements to calculate average salary

Write SQL statements that do the following: Calculate the average salary for all employees. Calculate the maximum salaries for exempt and non-exempt employees.

  Draw an entity relationship diagram

1. Draw an entity relationship diagram (ERD) for the following situation: A company has a number of employees. Each employee is identified by an Employee_Id. The company wants to store Employee_Name, Employee_Address, and Employee_BirthDate in the da..

  How to improve the quality of datasets

Recommend at least three (3) specific tasks that could be performed to improve the quality of datasets, using the Software Development Life Cycle (SDLC) methodology. Include a thorough description of each activity per each phase.

  Why is real-time data warehousing important

what kinds of applications require real-time data warehousing? Discuss applications that do not require real-time data warehousing. What is the difference between the two and why is real-time data warehousing important only to some applications

  Advantages of a database management approach

Discuss the advantages of a database management approach to the file processing approach? Give examples to illustrate your answer. Outline the benefits and limitations of the relational database model for business applications today

  Define security threats as it relate to the operating system

Discuss security threats as it relate to the Operating Systems and Memory Management. Consider a fixed partitioning scheme with equal-size partitions of 2 16 bytes and a total main memory size of 2^24 bytes. A process table is maintained that inc..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd