I want to know if the registered version will analyze the queries of a .mdb before I attempt to upsize them into views or store procedures.
Yes. SSW Upsizing PRO! analyzes all Access queries to find any references to VBA functions that don't have their equivalent Transact-SQL functions.
You could remove any references to those VBA functions manually before upsizing your database to Access Data Project using Microsoft Upsizing Wizard.
For more info see http://www.ssw.com.au/ssw/kb/KB.aspx?KBID=Q1682093