Structured Query Language (SQL) tutorial
Using SQL to Access Microsoft Access Databases
Selecting the database to use
It is not yet time to start working on your new database. First, you must indicate which database you want to work with. Access assumes that you want to work on the open database, or the database you just created. Other databases don’t for various reasons. For most database management systems, you must select a database before you start adding data or querying your database, even if you have just set up the database.
You can create three types of password on this database:
- Database password which must be entered by all users to open the database;
- User-specific security passwords; and
- Code-protecting passwords.
These are generally set up interactively in Access, rather than using SQL, so will not be considered further in this course. You will be able to access your database without passwords after you log in to your computer.
Once you have established that you can access your database,
- Close the database by selecting File > Exit or clicking the Access window Close button,
.