Grade 8 IT Term Two Exam

The question that is represented in such a way that MS-Access can understand

• Query

• Form

• Reports

• Access

There are ................... major parts of Query window in MS-Access

• Two

• Three

• Four

• Seven

The query type that helps to find the records that have same values in one or more fields.

• Simple query

• Unmatched query

• Duplicate query

• None of these

There are ......................... types of queries.

• Two

• Three

• Five

• Six

Run button is present on

• Home tab

• View tab

• Design tab

• Help tab.

These are the conditions that identifies the records that you want to find.

• Query

• Criteria

• Records

• Statement

AND criterion and OR criterion are the two examples of

• Comparison Criteria

• Compound criteria

• Complex criteria

• Unmatched Criteria

In MS-Access, the operator that is assumed that the criterion which you have entered must be equal (must of exact matches).

• Arithmetic operators

• Logical operators

• Boolean operators

• Comparison operators

In Access, these are used to show the characters or collection of characters in the form of symbols.

• Wild cards

• Wild characters

• Wild text

• Wild criteria.

The wild card that shows the collection/group of characters.

• Exclamation mark(!)

• Asterisk (*)

• Comma (,)

• Full stop or period (.)