Question

Which are the two special wild card for query provided by access are

Answer 1

Access supports two sets of wildcard characters because it supports two standards for Structured Query Language. As a rule, you use the ANSI-89 wildcards when you run queries and find-and-replace operations against Access databases such as *. mdb and *.