For new project - I am very new to ms-access

[deen]

Dear All,

I am planing to start the project for store keeping, in excel i have
little bit good knowledge so i have explain the project compare to
excel.
1. I NEED 2 USER FORM FOR , INCOMING MATERIAL AND OUTGOING MATRIAL,
ONCE CLICK THE INCOMING METRIAL (BUTTON) THIS ARE THE FIELD ARE
CONTAIN LIKE, DATE,MATRIAL NAME,INCOMING
TIME,QUANTITY,REMARK , THIS ARE THE DATA IN SHEET1(I NEED IN ACCESS),
OUTGOING MATRIAL, ONCE CLICK THE OUTGONING METRIAL (BUTTON) THIS ARE
THE FIELD ARE CONTAIN
LIKE,
DATE,MATRIAL NAME,OUT GOING TIME ,QUANTITY,REMARK , THIS ARE THE DATA
IN SHEET2(I NEED IN ACCESS),

2. WEATHER I WILL CLICK THE REPORT BUTTON,HAVE SHOW REPORT SHEET
BASED ON SELECTION OF PRODUCT, I WILL SHOW ENTRIE DETAILS EG:RUBBER
INCOMING IS 3,OUT GOING IS 2 SHOW BALANCE IT WILL SHOW 1 AVAILABLE IN
STOCK.

CAN ANY ONE DO THE NEEDFUL, THIS PROJECT WILLING DO IN ACCESS WITH
MACRO ONLY.

REGARDS,

DEEN