The below added Counter Details MS Access table provides details about item (food, wine), number, date of purchase, stock details and total quantity of each item for Wine dealer Project.
Counter_Detail
|
ITem_No
|
Date
|
Stock
|
Qty
|
Employee Salary Management MS access database table explains how staff salary calculates, it includes advance taken, advance date, reason for advance, amount paid, remarks, employee number.
Emp_Sal_Det
|
ADV_Taken
|
ADv_Date
|
Reason
|
Amt_Paid
|
Remark
|
Eno
|
Amt_taken
|
Fine
|
Employee information MS access table explains about how total employee details can be stored in the database. Here Employee name, Employee attendance, dates of joining, employee phone number, employee salary, and others.
Employee_Information
|
Ename
|
ET_Add
|
D_O_J
|
Remark
|
Eno
|
ph_no
|
E_sal
|
et_no
|
|
|
|
|
|
|
|
|
Employee Job table explains you about the employment name, duties, number, duties and amount.
Employee_Job
|
ET_Name
|
ET_Duties
|
Et_no
|
Et_period
|
Et_amt
|
Employee Expenses Table Below
Expenses
|
Particular
|
Date
|
total_amt
|
amt_paid
|
Hotel Registration MS access table provides total information about the hotel includes Hotel name, place, Licensee number, etc.
H_Registration
|
H_Name
|
H_add
|
H_city
|
H_state
|
Licence_No
|
Type
|
Remark
|
Pincode
|
Ph_No
|
Fax_No
|
H_No
|
Hotel_Part_Det
|
Part_Name
|
H_Add
|
Cit
|
State
|
Pager_No
|
Per_Buss
|
Comment
|
part_no
|
|
|
|
|
|
Hotel_no
|
pincode
|
ph_no
|
fax_no
|
Mobile
|
Item Information table provides item names and numbers.
Item_Information
|
Item_Name
|
Item_no
|
Item Stock table provides total Item stock, renew items, remarks.
Item_Stock
|
Item_No
|
Total_Stock
|
Re_Level
|
Remark
|
Purchase Item table provides item number, bill number, transaction type, transaction date, Total amount.
Purchase_Item
|
SNo
|
Item_No
|
Bill_No
|
Transe_Type
|
Paid
|
Transition_Date
|
|
|
|
|
|
Total_Amt
|
Last_Pay_Date
|
Check_Cash
|
order_qty
|
Receive_qty
|
Shop Information database table below:
Shop_Information
|
Shop_No
|
Shop_Name
|
Owner_Name
|
Address
|
Mobile_No
|
Fax
|
Remark
|
ph_no
|
Wine dealer information provides below details:
Wine_Dealer_Information
|
D_COmp_Name
|
D_Add
|
City
|
State
|
License_No
|
Mobile_No
|
|
|
|
|
|
|
Pager_No
|
Fax_No
|
Remark
|
D_No
|
pincode
|
ph_no
|
Wine Item Order details below:
Wine_Item_Information
|
Item_No
|
Item_Name
|
company_Name
|
QTY
|
Wine Stock details below:
Wine_Main_Stock
|
T_Stock
|
DT_Purchase_Ord
|
Sell_Price
|
Cost_Price
|
Remark
|
I_No
|
D_NO
|
BROKAGE
|
Download Wine Dealer management System Project Database Tables.