Microsoft Access SQL Sample 2

These following steps are alternative way to create table:

1. Open Microsoft Office Access
2. On the Create tab, in the Macros & Code group, click Query Design.
3. On the Design tab, in the Query Type group, click Data Definition.
4. Type the following SQL statement:
   CREATE TABLE product (
   [Id] INTEGER PRIMARY KEY, Name CHAR(15), Price FLOAT, 
   Stock INTEGER, Category INTEGER
   );
5. On the Design tab, in the Results group, click Run.

To see the result click the hyperlink below:

Next Microsoft Access SQL Sample 2 Result 1 >

Bibliography:

https://support.microsoft.com/

https://www.hp.com/

https://www.pcmag.com/

DDL, SQL command, table sample, data column, data row, data field, field type, field size, field length

Related Post:

• Microsoft Access SQL Sample ( Create Table )
• SQL Queries Command
• How to know Microsoft Access Database File Version
• Top Database Comment Syntax 1
• DDL, DQL, DML, DCL and TCL Commands
• Contoh Desain Tabel Database 1
• Post about Database
• JDBC Class For Name
• Fungsi Menu Pada Microsoft Excel 1
• Fungsi Menu Pada Microsoft Excel 2
• Fungsi Menu Pada Microsoft Excel 3
• Memelihara Kesehatan Lingkungan
• Things In Backyard