Study resources on Kenyaplex

Get ready-made curriculum aligned revision materials

Exam papers, notes, holiday assignments and topical questions – all aligned to the Kenyan curriculum.

Browse exam papers

Or go directly to:

Class notes Holiday assignments Topical questions Other resources

What is the meaning and the use of OR operator in queries?

Discuss the meaning and use of OR operator in queries.

Answers

OR is logical used to test Boolean expression and it will return TRUE if either Expr1 and Expr2 are TRUE (or if both expressions are TRUE).

For example, the expression: (Form=3 OR marks>=350) will return students in either Form 3 or students whose marks is grater than or equals to 350 or both.

maurice.mutuku answered the question on April 12, 2018 at 06:25

Answer Attachments

Next: What is the process of adding a calculated query in the field marked B that will calculate the average mark of a student who does...

Previous: State the components of a cathode ray oscilloscope

View more Computer Studies Questions and Answers | Return to Questions Index

Exams With Marking Schemes

Related Questions

What is the process of adding a calculated query in the field marked B that will calculate the average mark of a student who does... (Solved)

Discuss the process of adding a calculated query in the field marked B that will calculate the average mark of a student who does two CATs namely English and Kiswahili.

Date posted: April 12, 2018 . Answers (1)
What are the stages of activating a calculation for TOTAL sum of cash collected in a FeePayment field? (Solved)

Write the stages of activating a calculation for TOTAL sum of cash collected in a FeePayment field.

Date posted: April 12, 2018 . Answers (1)
How can you write a select query criterion statement that could be used to select data from a "DueDate" field for deliveries placed after 8th... (Solved)

Write a select query criterion statement that could be used to select data from a "DueDate" field for deliveries placed after 8th Dec 2010.

Date posted: April 12, 2018 . Answers (1)
What are the major types of queries in a database? (Solved)

Discuss the major types of queries in a database.

Date posted: April 12, 2018 . Answers (1)
Why would you use queries in databases? (Solved)

Give reasons why you would use queries in databases.

Date posted: April 12, 2018 . Answers (1)
State the applications of digital cameras (Solved)

State the applications of digital cameras.

Date posted: April 11, 2018 . Answers (1)
Giving examples, describe the various classifications of input devices (Solved)

Giving examples, describe the various classifications of input devices

Date posted: April 11, 2018 . Answers (1)
What is a datasheet? (Solved)

Define the term datasheet.

Date posted: April 11, 2018 . Answers (1)
What is a switchboard? (Solved)

Define switchboard.

Date posted: April 11, 2018 . Answers (1)
What are the main categories of controls found used in Ms Access? (Solved)

Discuss the main categories of controls found used in Ms Access.

Date posted: April 11, 2018 . Answers (1)
What is "Control" as used in form design? (Solved)

Define the term "Control" as used in form design

Date posted: April 11, 2018 . Answers (1)
What are the major sections of a form in design view? (Solved)

Discuss the major sections of a form in a design view.

Date posted: April 11, 2018 . Answers (1)
What are the views applicable to a form? (Solved)

List the views applicable to a form.

Date posted: April 11, 2018 . Answers (1)
What is a subform? (Solved)

Define a subform.

Date posted: April 11, 2018 . Answers (1)
What are the steps of creating a new form from a database wizard? (Solved)

Explain the steps of creating a new form from a database wizard.

Date posted: April 11, 2018 . Answers (1)
How would you create a backup copy of your file from your computer to an external storage such as a flash disk in a database... (Solved)

Explain how you would create a backup copy of your file from your computer to an external storage such as a flash disk in a database called CLASS, while using MS Access.

Date posted: April 11, 2018 . Answers (1)
How would you create Command Buttons that open other forms by using a wizard? (Solved)

Clearly describe the steps you would require to create Command Buttons that open the other forms by using a wizard.

Date posted: April 11, 2018 . Answers (1)
What are the steps required in adjusting the row height and column size in the datasheet view environment? (Solved)

Discuss the steps required in adjusting the row height and column size in the datasheet view environment.

Date posted: April 11, 2018 . Answers (1)
What is the difference between Caption and Required properties of a field? (Solved)

Distinguish between Caption and Required properties of a field.

Date posted: April 11, 2018 . Answers (1)
What is the difference between Indexed and default value? (Solved)

Differentiate between Indexed and default value.

Date posted: April 11, 2018 . Answers (1)