As the reviewing from the previous post about SQL statements, this tutorial will show you how to create Database and Performing SQL Statements in Microsoft Access to create the eight tables in our project.
First you to Window Start + R to run an Open Dialogue Box then type msaccess then click Ok or hit Enter on the key board.
Then in Blank Database, please select and Create Database Name is STU-DBMS. After that you can save and brows for the favorite location in your computer. Click on Ok –> After that Click on Create.
The Last Result will be:
To Create the SQL Statement, you need to follow as the steps:
First go to Create Menu in the Ribbon then select Query Design. Please cross it and you will the icon of SQL. After that select SQL View.
After SQL View selection
After Crossing and Select SQL View
To run the SQL Statement after your coding, please select Run
The next tutorial, we will show you how to create Table Student Info by using SQL Create Statement.
Watch our tutorial: