Database Grocery store.mdb
Content: БД.zip (725.83 KB)
Uploaded: 10.01.2021
Positive responses: 0
Negative responses: 0
Sold: 0
Refunds: 0
$9
The "Grocery store" database is designed to automate the activities of a grocery store. Allows you to process information about suppliers, customers, employees, goods, units of measure, types of goods, delivery methods, orders.
The grocery store database contains the following tables: position; employee; organization; delivery method; order; product; customer; provider; a type; unit.
The analytical capabilities of the database include the formation of the following queries and reports: displaying information about a product - this request provides the ability to display information about a certain product of a grocery store; search for customer information - this request provides the user with the ability to search for information about customers of a grocery store; information about employees - this report provides the ability to display information about store employees; information about suppliers - this report provides the ability to display information about suppliers of food products; goods in stock - this report provides the ability to display information about the availability of goods.
Development environment: Microsoft Office Access.
The grocery store database contains the following tables: position; employee; organization; delivery method; order; product; customer; provider; a type; unit.
The analytical capabilities of the database include the formation of the following queries and reports: displaying information about a product - this request provides the ability to display information about a certain product of a grocery store; search for customer information - this request provides the user with the ability to search for information about customers of a grocery store; information about employees - this report provides the ability to display information about store employees; information about suppliers - this report provides the ability to display information about suppliers of food products; goods in stock - this report provides the ability to display information about the availability of goods.
Development environment: Microsoft Office Access.
Also, you can order a description of the data schema and a description of how to work with the database in the form of a report (.doc). Updating information in the database, updating dates, full name and other information. It is possible to modify the user interface or refine the presented database according to your requirements. I can offer a large number of ready-made databases on various topics or develop a new one on any topic you suggest.
No feedback yet