1. Creating A New Database

Field Size TextBOX

Using Simple Query Wizard:

# Modifying Query to Implement Sorting

Required Clause

Open the Pending Table change 5th & 7th of Pqty column to 0.

Close the Database view open Queries window- Click New button & Design View.

Add the Pending Table

Create an Item Table:

Modifying the Structure of the Pending Table

Create Look-up List.

More Queries

Changing the Order of the Field

Validation :

Double Click

Advance Queries:

Total Option ;

Create a Form from a Table