Std 11 Chapter 11 Different Operator Used in Base ?

• Different Operation Use in Base :

 

Operator	Symbols
Comparison	=,  >,  <,  >=, <=, <>
Logical	And, Or, Not
Special	Like, Is, Between, In

Std 11 Chapter 11 Write Criteria Condition on Particular Field Value

• Different Ways to Write Criteria Condition on Particular Field Value :

1. Text:            Write Condition value in Single Quotation.

          For e.g. ‘Ahmedabad’

                        2. Number:      Write Condition value as per your Condition.

                                                  For e.g. 12

                        3. Date:           Write Condition Value Before and After Hash Sign (#).

                                                For e.g. #1/1/2014#

Std 11 Chapter 11 Steps to Create a Query using Wizard

 Steps to Create a Query using Wizard

1. Field Selection

2. Sorting Order

3. Search Condition

4. Detail or Summary

5. Grouping

6. Grouping Condition

7. Aliases

8. Overview (Query Name to Save Our Query)

• Click on the Run Query Button () on the Query Design Toolbar.

Std 11 Chapter 11 How Many Ways to Create a Query ?

• Ways to Create Query: Three Ways to Create Query. It is As Follows:

1. Design View

2. Use Wizards

3. SQL View

Std 11 Chapter 11 What is Query

What is Query

• Query: Means asking question, doing inquiry or performing analysis.

Write a Java Program to print 1,2,3.. to 10 Using do..While Loop(JAVA Programs)

Write a Java Program to print 1,2,3.. to 10 Using do..While Loop(JAVA Programs)

Write a Java Program to print 1,2,3.. to 10 Using While Loop

Write a Java Program to print 1,2,3.. to 10 Using While Loop(JAVA Programs)

Write a Java Program to Print Item Information(JAVA Programs)

Write a Java Program to Print Item Information ,qty , price and total amount(JAVA Programs)

Write a Java Program to Check Increment And Decrement Operator(JAVA Programs)

Write a Java Program to Check Increment And Decrement Operator(JAVA Programs)

Write a Java Program to Check No is Positive , Negative or Zero (JAVA Programs)

Write a Java Program to Check No is Positive , Negative or Zero (JAVA Programs)

Write a Java Program to Check Minimum Values From Two Numbers (JAVA Programs)

Write a Java Program to Check Minimum Values From Two Numbers (JAVA Programs)

Write a Java Program to Check Maximum Values From Two Numbers (JAVA Programs)

Write a Java Program to Check Maximum Values From Two Numbers (JAVA Programs)