Goldsmith database .mdb

Affiliates: 0,09 $how to earn
Pay with:
i agree with "Terms for Customers"
Buy this item cheaper:
Sold: 12 (last one 43 days ago)
Refunds: 0

Uploaded: 10.03.2016
Content: Ювелирная мастерская 2003.rar (523,21 kB)

Description

Goldsmith database .mdb Goldsmith database .mdb Goldsmith database .mdb

Goldsmith database .mdb
Download the report on the database screen forms for free http://access.avorut.ru/1/juvelirnaja/224_otchjot_dlja_bd_juvelirnaja_masterskaja.docx

Note: If the yellow Message Bar appears when you open a file, you must click on "Enable Content" button.

Additional information

Ready database access «Jewelery workshop»
Description of the subject area
You work in a jewelry shop. Your workshop carries out the manufacture of jewelry for individuals to order. You work with certain materials (platinum, gold, silver, various precious stones, etc.). When you contact a potential customer, you are determined by what kind of product it needs. All products you manufacture belong to a certain type (earrings, rings, brooches, bracelets), they are made of a certain material, have some weight and price (including the cost of materials and work). Each type of product has a name (earrings, a ring, a brooch, a bracelet, etc.) and an approved manufacturing cost.
Tables
Products (Product Code, Name, Type, Material Code, Weight, Price).
Materials (Material Code, Title, Price per gram).
Sales (Product code, Sale date, Surname of the buyer, Buyer´s name, Patronymic of the buyer).
The development of the formulation of the problem
During the trial operation of the database, it became clear that a piece of jewelry could consist of several materials. In addition, the workshop provides discounts for regular customers. Add changes to the table structure that take into account these facts, and modify existing queries. Add new queries.
Task for creating a database in a Microsoft Access environment
The order of the work:
• Selection of the subject area in accordance with the student´s serial number in the journal;
• Analysis of the textual description of the subject area;
• Selection of table structures and their creation;
• Filling in the data in the tables;
• Development of user interface. Creating forms;
• Creation of calculated queries;
• Creating output reports.

Feedback

0
No feedback yet.
Period
1 month 3 months 12 months
0 0 0
0 0 0
In order to counter copyright infringement and property rights, we ask you to immediately inform us at support@plati.market the fact of such violations and to provide us with reliable information confirming your copyrights or rights of ownership. Email must contain your contact information (name, phone number, etc.)