How do you mimic Access' Ignore Null index behavior in SQL Server

What you can do – create a new View with SCHEMABINDING option, which does not return nulls, and create unique index on it. Read more on other 3 ways.