Std 11 Chapter 11 Wild Card Character

• Wild Card Character Asterisk (*) sign Returns Remaining Character of the Conditions Value.

For e.g. Like ‘M*’: They Returns Name Start with M but Remaining Character after M is Any Character.

Std 11 Chapter 11 Operators Examples in Base

• Some Important Operators Examples:

 

No.	Name of Operators	Examples
1	And	1. 100 And 200 2. ‘Anand’ And ‘Nadiad’
2	Or	1. 100 Or 200    2. ‘Maulik’ Or ‘Paresh’
3	Not	1. Not 5             2. Not(‘Anand’)
4	Like	1. Like ‘M*’
5	Is	1.Is Not Empty (The Field Value is not Set Empty)
6	In	1.In(‘Anand’)
7	Between	1.Between #1/6/2005# And #11/1/2012#

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.