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.