Base Online Store .mdb database

-
RUR
+
Transaction fee is 0%
Minimum amount is 763 RUR
Affiliates: from  0,12 $how to earn
Pay with:
i agree with "Terms for Customers"
Buy this item cheaper:
Sold: 15 last one 33 days ago
Refunds: 0

Uploaded: 01.04.2016
Content: Интернет-магазин 2003.rar 83,36 kB

Description

Base Online Store .mdb database Base Online Store .mdb database

Base Online Store .mdb database
Download the report on the database screen forms for free http://access.avorut.ru/1/internet/228_otchjot_dlja_bd_internet-magazin_2003.doc
Note: If the yellow Message Bar appears when you open a file, you must click on "Enable Content" button.

Additional information

Ready database of access «Internet shop»

Online store
Description of the subject area
You are an employee of the commercial department of the company selling various products through the Internet. Your task is to track the financial component of the company´s work. The work of your company is organized as follows: some products are on the company´s website (for sale). Each of them has some name, price and unit of measurement (pieces, kilograms, liters). To conduct research and optimize the work of the store, you are trying to collect data from your customers. At the same time for you, the standard personal data, as well as the telephone number and e-mail address for communication, are of decisive importance. In the case of the purchase of goods worth more than 5000 rub. the customer goes to the category of "regular customers" and receives a discount for each purchase of 2%. For each sale fact you automatically fix the customer, the goods, the quantity, the date of sale, the date of delivery.
Tables
Goods (Item Code, Name, Price, Unit of Measurement).
Clients (customer code, last name, first name, patronymic, address, telephone, email, permanent customer).
Sales (Sales code, Product code, Customer code, Date of sale, Delivery date, Quantity).
The development of the formulation of the problem
As a result of the operation of the database, it was found out that sometimes there are problems associated with a lack of information about the availability of the necessary goods in the warehouse in the right amount. In addition, usually customers in the same order buy not one type of product, but several types. Based on the total cost of the order, the company provides additional discounts. Add changes to the table structure that take into account these facts, and modify existing queries. Add new queries.

Feedback

0
No feedback yet.
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.)www.plati.market