Create Table In Microsoft Access SQL

Create Database

1. Open Microsft Access
2. select File > New menu.
3. Select Blank database template.
4. Enter a name for the database inside File Name box, select a location by click the folder icon, and then select Create button.

Create Table In Microsoft Office Access SQL

1. On the Create tab, in the Macros & Code or Other group, click Query Design.
2. Close Show Table dialogue.
3. On the Design tab, in the Query Type group, click Data Definition.
4. Type the following SQL statement:
   CREATE TABLE Kategori (
   KodeKategori CHAR(10)
   NamaKategori CHAR(50), 
   Jumlah INTEGER, 
   CONSTRAINT [PKKodeKategori] PRIMARY KEY (KodeKategori)
   );
   CREATE INDEX IdxKodeKategori ON Kategori WITH DISALLOW NULL
5. On the Design tab, in the Results group, click Run.

Bibliography

https://learn.microsoft.com/

https://support.microsoft.com/

https://blueclawdb.com/

database table, database design, database definition

Related Post

Ribbon In Microsoft Word

Ribbon File Pada Microsoft Office Word

Bagian File Explorer