Case sensitivity

I am converting data from Access into Postgres and ran into an issue with case sensitivity. Can I write queries in Access that will be case insensitive without rewriting the queries.  So I would like to know if this be handled in Postgres or even if someone knows in Access.  Thank you.