DATABASE MANAGEMENT SYSTEMS - Practice Mode

1) Which command quickly locates the data is Access table?

Find Locate Search Edit

Correct Answer: Find

2) Which technique prevents invalid data being saved in Access table?

Index Filter Validation rule Input mark

Correct Answer: Validation rule

3) Which validation rule accepts only a - z letters for fields in Access?

Is null or NOT like ?*[! a - z]*? Is null or NOT like ?*[a - z ]*? Is null or NOT like ?*![a - z]*? Is null or NOT like ?[! a - z]?

Correct Answer: Is null or NOT like ?*[! a - z]*?

4) Which validation rule allows only 0 - 9 for fields in Access?

Is Null or Not Like ?*[ ! 0 - 9 ]*? Is Null or Not Like ?[! 0 - 9]? Is Null or Not Like ?*[0 - 9]*? Is Null or Not Like ?*[!0-9]*?

Correct Answer: Is Null or Not Like ?*[!0-9]*?

5) Which validation rule allows only positive numbers for fields in?

Is Null or > = 0 Is Null or Positive Is Null or < 0 Is Null or = ?+?

Correct Answer: Is Null or > = 0

Previous Question Set Back to Question Sets Next Question Set

Try Another Topic

Try Another Quiz