Bd Factory of toys .mdb

Affiliates: 0,09 $how to earn
Pay with:
i agree with "Terms for Customers"
Buy this item cheaper:
Sold: 5
Refunds: 0

Uploaded: 15.09.2016
Content: Фабрика игрушек 2003.rar (251,04 kB)

Description

Bd Factory of toys .mdb Bd Factory of toys .mdb Bd Factory of toys .mdb

Bd Factory of toys .mdb

Download the report on the database screen forms for free http://access.avorut.ru/1/261_igrushki/261_otchjot_bd_fabrika_igrushek.doc

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

Additional information

Task for the database Toy Factory.

1. Create tables by defining properties for each field in the table.
2. Establish links between tables.
3. Create delete requests, add and update rows
4. Create two forms: simple (based on one table) and complex-subordinate (based on two tables, united by a one-to-many relationship). Place in the forms various control elements: fields with drop-down lists, buttons for launching queries and forms, and so on.

Option 19
Create a database "Toy Factory".
The database stores information about the assortment of manufactured toys (Article, Name, Price per unit), materials for manufacturing (Code, Name, Price), wholesale customers (Passport No., Name, Address).
The toy is made of several materials, each material can be used for making different toys, the amount of material for making each is specified in the table "Making Toys".
Calculate the cost of each toy as a total cost of materials included in it + 35% to pay production costs. Collect statistics on products and orders for it by quarters, months.


The task "Designing a relational database and its implementation in an Access DBMS
General requirements
1. Design a database using any design method. Determine the number, structure, and relationships between tables.
2. Create tables by defining properties for each field in the table. Ensure data consistency (foreign key requirement) by creating fields with substitution.
3. Establish links between the tables.
4. Create multiple queries:
1) Three sampling requests with complex selection criteria;
2) Three queries using group operations and statistical SQL functions;
3) Parametric query;
4) Cross-Request.
5. Create two forms: simple (based on one table) and complex-subordinate (based on two tables, united by a one-to-many relationship). Place in the forms various control elements: fields with drop-down lists, buttons for launching queries and forms, and so on.
Determine the workload of each librarian and the amount of stored literature in each section.
Option 12
Create a database "Toy Factory". DB stores information about the assortment of manufactured toys, materials for manufacturing, wholesale customers. The toy is made of several materials, each material can be used to make different toys, the amount of material for the manufacture of each is specified. Each material is known for its price.
Calculate the cost of each toy as a total cost of materials included in it + 35% to pay production costs. Collect statistics on products and orders for it by quarters, months.

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.)