Question

What criteria should be added to the ManagerData query to select only those records where the HireDate field value is greater than 1/1/2008?

a) > #1/1/2008#

b) < #1/1/2008#

c) >= #1/1/2008#

d) <= #1/1/2008#

Answer 1

The correct criteria to select records with a HireDate greater than 1/1/2008 is '> #1/1/2008#'.

Step-by-step explanation:

To select only those records where the HireDate field value is greater than 1/1/2008, the criteria that should be added to the ManagerData query is option a) > #1/1/2008#.

This criteria selects records where the HireDate field value is greater than the specified date. The greater than symbol (>) indicates that the HireDate should be later than 1/1/2008.

For example, if a record has a HireDate value of 1/15/2009, it would be selected with this criteria since it is greater than 1/1/2008.