Answer
No, you don't need the VPN to access any library resources from off-campus, such as article databases.
When you access library resources through the library website or Canvas you'll be asked to enter your A-number and password. If you've already logged into Banner or Canvas, you won't need to enter your A-number again.