Change the default schema/database.
From SQLZoo
Change the default schema/database.
schema:gisq
In many engines several independant databases may exist. Often each user has his or her own database. This allows different users to use the same names for tables.
N/A. Access is a single user system.
\connect template1 - scott
ALTER SESSION SET CURRENT_SCHEMA = haggis
Use Master
USE scott