Database Design and Implementation, Summaries of Law

Download Database Design and Implementation and more Summaries Law in PDF only on Docsity!

thiha naing [COMPANY NAME] [Company address]

DATABASE DESIGN AND

IMPLEMENTATION

[Type here] [Type here] [Type here] [Type here] [Type here] [Type here]

Contents

• Import data..............................................................................................................................................
• Data Entry Form..........................................................................................................................................
  • Create Customer form.............................................................................................................................
  • Purchase Form.........................................................................................................................................
  • Sale Form.................................................................................................................................................
  • Stock Form...............................................................................................................................................
  • Supplier Form..........................................................................................................................................

Insert data into Sale Table Insert data into Stock Table

Import data

Purchase Form

Input the data into purchase form

Sale Form

Input the data into sale form

Supplier Form

Input the data into supplier form

Field validation

Enter “is not Null “ function in the customer name in customer table. After using the “is not name” function. When the customer deled customer name in customer table, the system will show warning message as shown in figure.

Filed validation Enter “is not Null “function in the item name in purchase table. After using the validation rule (>1000) in purchase price, when the user enter wrong price, the system will show warning message error “check your price”.

Filed validation Enter “is not Null “function in the item name in sale table. After using the validation rule (>1000) in sale price, when the user enter wrong price, the system will show warning message error “check your price”.

Record Validation Sale Expire date must be grater tan

1.Open sale form. 2.Rightclick layout view 3.Delete item name 4.drag combo box 5.change name in combo box 6.select combo box 7.Row source-click three dots. 8.Select purchase table and double click category

9. close and save