Monday, March 28, 2011

Query

 Creating Select Queries As the Select query is the most common queries and frequently used, the Select Query normally be referred to as a 'query'.



Creating
Queries with the Query Design
The process of making queries to the Query Design started by clicking the Query Design above.
The data used were:Customer
 
Cust_No
Cust_Name
Cust_Address
Cust_Mobile

Product
ID_Product
Product_Name

Booking
BookingNo
Book_Date
Price_Per_Unit
Quantity
Grant_Total










Drop down selected Primary Key

Save As

No comments:

Post a Comment