• June 13, 2021

PHSARIT

Bring Technology Ideas with you

 Create SQL Statement in Microsoft Access

Standard alone database is coming up with Microsoft Access for making SQL programming. In order to write SQL statement in MS Access, First of all,

  1. Go to Microsoft Access by type msaccess in Run Dialogue box:

    2. Then Go to Create Tab

      3. Select Query Design then cross the show table Dialogue, after that select SQL View

        4. You can see the coding panel as image

          Example of Create Table Syntax:

          Create Table Tbl_Student ( ID int, Full_Name varchar, Gender varchar)

            Then Click Run

              Related post

              Leave a Reply

              Your email address will not be published. Required fields are marked *