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.