COMPUTER QUERIES

Question 1

this is the most common type of query in Microsoft access and is used to extract data from table/s based on the specified criteria.

Answer 1

Select query

Question 2

this type of query enables you to perform an action such as delete, append, and update records, which meets the specified criteria.

Answer 2

Action query

Question 3

this type of query allows for flexibility in manipulating data by prompting for user input in the selection criteria.

Answer 3

Parameter query

Question 4

this type are used to summarize data by grouping data with corresponding summary calculations, such as sum or average, based on the specified criteria.

Answer 4

Crosstab query

Question 5

used, Microsoft access creates the equivalent sql statement automatically:

Answer 5

QBE

Question 6

are binary operators primary because these indicate the relationship between two operands

Answer 6

RELATIONAL OPERATORS

Question 7

>

Answer 7

greater than

Question 8

> =

Answer 8

GREATER THAN EQUAL TO

Question 9

<

Answer 9

less than

Question 10

<=

Answer 10

LESS THAN OR EQUAL TO

Question 11

=

Answer 11

equal to

Question 12

<>

Answer 12

not equal

Question 13

ALL SPECIFIED CRITERIA MUST BE MET

Answer 13

AND

Question 14

EITHER CRITERION MUST BE MET

Answer 14

OR

Question 15

INDICATED CRITERIA SHOULD NOT BE MET

Answer 15

NOT

Question 16

THE VALUE MUST BE FROM X AND Y

Answer 16

BETWEEN X AND Y

Question 17

THE VALUE MUST BE IN THE LIST

Answer 17

IN

Question 18

IN MATCHING CHARACTERS, ARE PROVIDED BY MICROSOFT ACCESS. THE WORD ‘’ LIKE’’ IS AUTOMATICALLY ADDED IN THE GRID SO THE USER NEED NOT TYPE IT

Answer 18

WILDCARD OPERATORS

Question 19

FOLLOW THE RULES OF FORMAL LOGIC

Answer 19

LOGICAL OPERATORS

Question 20

*

Answer 20

MATCHES CHARACTER IN ANY NUMBER

Question 21

?

Answer 21

MATCHES ANY LETTER

Question 22

#

Answer 22

MATCHES ANYNSINGLE-DIGIT NUMBER

Question 23

[]

Answer 23

MATCHES ANY OF THE CHARACTERS WIThIN THE BRACKETS

Question 24

!

Answer 24

MATCHES ANY CHARACTER NOT IN THE LIST INSIDE THE BRACKETS

Question 25

-

Answer 25

MATCHES ONE CHARACTER IN A RANGE OF CHARACTER