Access Exam Activity 3

What does this image show?

• Sorting

• Parameters

• Wild Card

• Null / Is Not Null

What does this image show?

• Sorting

• Parameters

• Wild Card

• Null / Is Not Null

What does this image show?

• Sorting

• Parameters

• Wild Card

• Null / Is Not Null

What does this image show?

• Concatenation

• Parameters

• Wild Card

• Null / Is Not Null

What does this image show?

• Concatenation

• Parameters

• Wild Card

• Null / Is Not Null

What does this image show?

• Concatenation

• Parameters

• Wild Card

• Null / Is Not Null

Asterisk is a _________ character and can be used in a query to represent ‘any characters’.

• Concatenation

• Parameters

• Wild Card

• Null / Is Not Null

Two or more fields can be combined to create a new calculated field.

• Concatenation

• Parameters

• Wild Card

• Null / Is Not Null

Results from a query can be arranged ascending / descending by using the sort option.

• Sorting

• Parameters

• Wild Card

• Null / Is Not Null

Can be entered to search for empty fields.

• Sorting

• Parameters

• Wild Card

• Null / Is Not Null