Скачать или смотреть How to create Pharmacy Database in Ms Access Part - 3 | With Design Entry Form

Hello everyone, You can learn from my tutorial video how to create Pharmacy Database in access -all version . So In this Demo video tutorial i am going to show you the details process for creating Pharmacy Database in Ms Access .

Step 1 - First Create table like Product, Expired Date, Order, Customer, and Stock Table.

Step 2- After create these table i already relationship between one
to another - where you see details for relationship table go
to my last video tutorial - How to create Pharmacy
Database Table relationships in Ms Access | Part 2 or
PART -1 see below link -

Step 3 - ADD PRODUCT Form - Create form design view-Right click
mouse - Add field
a. Product/medicine table Fields and
b. Expired Date table fields/subform
Drag the mouse to adding fields from Add existing fields

Step 4 - STOCK/PURCHASE PRODUCT Form - Create form design
view - Right click mouse and Add field
a. Product/medicine table Fields and
b. Stock table fields/subform
Drag the mouse to adding fields from property sheet

Step 5 - CUSTOMER NEW ORDER Form- Create form design view -
Right click mouse and Add field
a. Product/medicine table Fields and
b. Order table fields/sub form with add Customer table
fields. Drag the mouse to adding fields from Add existing
fields
Step 6 - Finally Right click the form
command from control
toolbar and designing the form from property sheet with
required format list which i showing you in this video please watch this video tutorial for detail practice .
I hope you like this video tutorial

Thank you

Click here to download PHARMACY DATABASE Full version...https://nekiburs333.stores.instamojo....

Get help practice these video link - ----------------

How to create Pharmacy Database Table relationships in Ms Access Part 2

   • How to create Pharmacy Database Table rela...  

Create Pharmacy Database in Ms Access Part 1

   • Create Pharmacy Database in Ms Access | Pa...