Create a supplier database and related reports

Assignment Help Database Management System
Reference no: EM13750497

Case Study - Supplier Database

As you recall, data is a collection of facts (numbers, text, even audio and video files) that is processed into usable information. Much like a spreadsheet, a database is a collection of such facts that you can then slice and dice in various ways to extract information or make decisions. However, the advantage and primary use of a database over a spreadsheet is its ability to handle a large volume of data and yet allow for quick access to the information that is desired.

Databases are everywhere now and impact our lives in a multitude of ways. It can accurately be said that "your life is in a database" or, more accurately, in multiple databases, and information about you (a retrieval of facts about you) is easily accessible. Your shopping history, credit history, medical history, even your driving history, is stored in one or more databases.

This exercise will introduce you to the basic building blocks of any database - fields, records, and files (also called tables). Although you will create a database with a single table containing a small amount of data about computer component suppliers, the more applicable use of databases involves the creation of many tables linked together with a common field or "key." Regardless of the size of the database, the data is stored in the same way - in fields which are combined to create a record. And those records are stored in a file or table. The data is entered into the field via a data entry form, and the information is extracted (to answer a particular question or need) via reports and/or queries. Specific instructions for the project can be found in the table below.

Create a supplier database and related reports and queries to capture contact information for potential PC component suppliers that might be used to purchase the equipment your specified in your MS Word project - the PC specifications.

This MS Access database assignment has the following parts:

1. a simple database table to hold supplier contact information; some of the required fields in the table require that a Caption be added to the field characteristics. The Caption will be displayed in the report that is to be generated.

2. a simple database form that can be used to enter data into the database table;

3. two simple database reports that can used to present the data as information; and

4. a separate MS Word document answering questions about the database.

Reference no: EM13750497

Questions Cloud

Determine the output displayed : Determine the output displayed when the button is clicked. Determine the output displayed when the button is clicked. Assume the five lines of the file Dates.txt contain the numbers 1492, 1776, 1812, 1929, and 1941 and the file is in the appropriat..
Describe the major network security organizations : As a member of the Network Security group, you have been asked to serve on the committee and to take the initiative in the following: 1. Describe the major network security organizations. 2. Identify risks, threats, vulnerabilities and countermeasu..
Way in which the malware was utilized to steal data : From the selected e-Activity article, describe in detail the way in which the malware was utilized to steal data or gain privileged remote access to a computer or network
Describe each rule and discuss common violations : What are some of the questions that you would ask to determine what should be on the report? For one of your questions, give an example of two different answers the manager might give and tell how each answer would affect the report design.
Create a supplier database and related reports : Create a supplier database and related reports and queries to capture contact information for potential PC component suppliers that might be used to purchase the equipment your specified in your MS Word project - the PC specifications
Access interface element : Which object would you use to retrieve customers who live in Germany and the United States - Which of the following statements is NOT correct about a query?
Create a powerpoint on national youth administration : Create a powerpoints done for a group project that working on these are the topics. National youth, administration, Peurto rico reconstruction admin, Reciprocal tariff act and federal housing admin.
What is the after-tax cost of debt : The 8.5 percent annual coupon bonds of the ABC Co. are selling for $1,179. The bonds mature in 12 years. The bonds have a par value of $1,000. If the tax rate is 30%, what is the after-tax cost of debt?
Udo marian & uduak corporation case study : This assignment is based on the Udo, Marian, & Uduak Corporation (UMUC) Case Study. The focus will be on developing a C-level executive (CEO, CFO, COO, CIO) briefing on an IT best practice and a justification for implementation

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

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