SQL view

     

  • Click on "Query Design" Option under CREATE

    •  

     

  • Select SQL VIEW under DESIGN TAB

    •  

     

    Create Table Syntax- SQL View

     

    Syntax:

    Create table Employees(
    ID int Primary key,
    Emp_Name Text,
    Department Text,
    Gender Text,
    Age int)

     

     

    Insert Values Syntax- Insert Values

    Insert into Employees values(1, 'Apple', 'Accounts', 'M', 45)

     

     

    ADD Column Syntax

     

    Alter Table Employees Add Column Location Text

     

     

    DROP Column Syntax

     

    Alter Table Employees Drop Column Location

     

    DROP Table Syntax

     

    Drop Table Employees

     

     

     

Hi Everyone,
Welcome to Access Tutorial. In this tutorial i explained:
(i) How to insert the data into Access Database
(ii) how to extract the Data from Aceess Database to Excel
(iii) How to insert the data into Database by using FORMS by using VBA Macros.
This Tutorial provides comprehensive knowledge on the procedure how to connect\interact with Access Database. Hope it enhances your coding skills. If you like this web page kindly Share this to your near and dear. I Prepared this content as per my level of knowledge, if any changes required kindly bring to my notice. Thanks for visiting this web page

Thanks,
Pavan Kumar Gundlapalli