Microsoft Access SQL Sample

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, Name CHAR, Price FLOAT, 
   Stock INTEGER, Category INTEGER,
   CONSTRAINT [PKid] PRIMARY KEY ([Id])  );
5. On the Design tab, in the Results group, click Run.

Bibliography:

https://support.microsoft.com/

https://www.hp.com/

https://www.pcmag.com/

database, table sample, sequel, structure query language, programmer, administrator, technical support, data, system

Related Post:

• 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
• Posting tentang SQL
• Fungsi Menu Pada Microsoft Excel 1
• Fungsi Menu Pada Microsoft Excel 2
• Fungsi Menu Pada Microsoft Excel 3
• Memelihara Kesehatan Lingkungan