Introduction Access is a ubiquitous database running on Microsoft Windows. It is usually used by a single user. Access provides an intuitive graphical user interface that enables you to create tables and insert, update, and delete data from the windows without using the SQL commands. However, to develop database applications using Java, you still have to learn and use SQL. This tutorial demonstrates using SQL with Access and developing Java programs for Access. 1 Creating a Database and Executing SQL Here are the steps to create a database and execute SQL statements from Microsoft Access: 1. Launch Microsoft Access database as shown in Figure 1.1. Check Blank Access database in the Create a new database section.

Click OK to display the File New Database dialog box, as shown in Figure 1.2. Create and select the directory book in the Save in field and type exampleMDB.mdb in the File name field. Click Create to create a new database. The exampleMDB database is created as shown in Figure 1.3.

Download PDF for Tutorial for MS Access For Introduction to Java Programming, 5E