Database Cafe.mdb
Replenishment date: 09.01.2021
Content: IS.zip (226.13 KB)
️Automatic issue of goods ✔️
️Automatic issue of goods ✔️
Sales:
0
Refunds:
0
Reviews:
0
Views:
109
Description
The "Cafe" database is intended for cafe automation. Allows you to process information about orders, types of dishes, types of dishes, types of cuisine, dishes, tables, customers.
The "Cafe" database contains the following tables: type; dish; specification; order; table; customer; type of kitchen; kind of dish.
The analytical capabilities of the database include the formation of the following queries and reports: search for dishes that contain all the ingredients specified by the user during the search; displaying all information about those orders where at least one dessert was ordered for the time period specified by the user; withdrawal of all products that are part of the first courses.
Development environment: Microsoft Office Access.
The "Cafe" database contains the following tables: type; dish; specification; order; table; customer; type of kitchen; kind of dish.
The analytical capabilities of the database include the formation of the following queries and reports: search for dishes that contain all the ingredients specified by the user during the search; displaying all information about those orders where at least one dessert was ordered for the time period specified by the user; withdrawal of all products that are part of the first courses.
Development environment: Microsoft Office Access.
Additional Information
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.