Microsoft Access Interview Question:

State some criteria s and their effects on a database?

Submitted by: Administrator

It is possible to enter one or more criteria in the rows which can affect your database significantly.
>=”Callahan” this returns all the various records from Callahan to the end of the alphabet.
Date() This field returns all the data pertaining to the current date.
‘''' This is used when you want to know all records which contain zero length string. This can be useful to know whether your customers have fax numbers or so.
Submitted by: Administrator