• The only worth of the question is the good news:

    "filtered index" (SQL Server 2008).

    This feature is present in MS-ACCESS starting from version 1.0 (year 1990).