Quiz 5: Creating Advanced Queries and Enhancing Table Design


Qry Prefix Tag • The qry prefix tag is used for identifying the queries according to the naming conventions used in this session. • It identifies each query in the database. This qry prefix tag is used exclusively for queries.

Like Comparison Operator • Like Comparison Operator is the comparison operator which selects the records by matching values of the field with a specific pattern in Database. • Like pattern comparison operator used to match the string values.

Purpose of Asterisk Symbol • The asterisk (*) is used for representing any string of characters in a pattern match query. • This character much like the MS-DOS asterisk wildcard. This describes the look for the charter asterisk.