DATABASE MANAGEMENT SYSTEMS - Quiz

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

Find Locate Search Edit

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

Index Filter Validation rule Input mark

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]?

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]*?

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 = ?+?