Database sales of finished products .mdb

Affiliates: 1,72 $ — how to earn
Pay with:
i agree with "Terms for Customers"
Buy this item cheaper:
Sold: 2
Refunds: 0

Uploaded: 15.06.2016
Content: Реализация готовой продукции 2003.rar (100,62 kB)

Description

Database sales of finished products .mdb Database sales of finished products .mdb

Database sales of finished products .mdb

Download the report on the database screen forms for free http://access.avorut.ru/1/246_realizacija/246_otchjot_bd_realizacija_gotovoj_produkcii.doc

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

Additional information

The task for the database of the access "Realization of finished products"

Subject areas for independent work
Stages of individual self-employment:
1. Create a table structure by means of MS Access;

2. Create a data schema;

3. Develop screen forms for entering and viewing information;

4. Fill in the tables (10-15 records);

5. Develop and execute various types of queries to the database:

• for sample;

• using logical operations in the selection condition;

• with the parameter;

• cross request;

• for updating;

• to add;

• to delete;

• with calculated fields (if this is possible for your predefined area).

6. Develop various types of reports for printing data;

7. Organize work through a button form or headband. The database should look like a complete software product.
Sales of finished products
The company is engaged in wholesale and retail sales of goods from a certain spectrum. Each of the goods is characterized by the name, unit of measurement, wholesale price per unit, retail price per unit, reference information.

The company is addressed by organizations-buyers. Each customer is recorded standard data (Name of the organization-buyer, Address, Telephone, Contact person).

Usually buyers within the limits of one transaction buy not one goods, and a few. Moreover, for each product, the quantity of goods, the sign of wholesale (O) or retail (P) sale, the amount (if "sign =" O ", the sum = wholesale price * the number of units of goods, if the sign =" P " then the amount = retail price * the number of units of the product). When making a transaction, a contract is made that fixes the date of the transaction, the total amount of the transaction.
Sales of finished products
Description of the subject area
You work for a company engaged in wholesale and retail sales of various goods. Your task is to track the financial side of its work. The company´s activities are organized as follows: the company trades goods from a certain range. Each of these products is characterized by name, wholesale price, retail price and reference information. Customers are turning to your company. For each of them you store in the database standard data (name, address, phone, contact person) and make a document for each transaction, memorizing along with the buyer the quantity of the goods purchased by him and the date of purchase.
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 data into tables (at least 5 lines in each table);
• Development of user interface. Creating forms;
• Creation of calculated queries;
• Creating output reports.
Sales of finished products
Description of the subject area
You work for a company engaged in wholesale and retail sales of various goods. Your task is to track the financial side of the company. The activities of your company are organized as follows: your company trades goods from a certain range. Each of these products is characterized by name, wholesale price, retail price and reference information. Your company is turned to buyers. For each of them you store in the database the standard data (name, address, phone, contact person) and make a document for each transaction, memorizing along with the buyer the quantity of the goods purchased by him and the date of purchase.
Tables
Goods (Item Code, Name, Wholesale Price, Retail Price, Description). Buyers (Buyer´s code, Telephone, Contact person, Address).
Transactions (Transaction code, Transaction date, Product code, Quantity, Buyer´s code, Sign of wholesale).
The development of the formulation of the problem

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