Search In This Website

Selasa, 17 September 2024

Create Table In Microsoft Access SQL

Create Database

  1. Open Microsoft 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.
to learn create database in Microsoft Access 2003 using Windows 8.1, click Create Database In Microsoft Access >

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)
    );
  5. On the Design tab, in the Results group, click Run.
  6. Type the following SQL statement:
    CREATE INDEX IdxKodeKategori ON Kategori WITH DISALLOW NULL;
  7. On the Design tab, in the Results group, click Run.

Bibliography

https://learn.microsoft.com/ ( manual ebook )
https://support.microsoft.com/ ( manual ebook )
https://blueclawdb.com/

database table, database design, database definition

Related Post

Tidak ada komentar:

Posting Komentar