acces

Membuat table barang dgn SQL :

CREATE table barang (kodebarang text (5) primary key,namabarang text (20),harga currency);

Membuat isi table dg SQL ;

INSERT into penjualan

values("k001","keyboard komic","50000")

INSERT into penjualan

values("M001","mouse komic","25500")

INSERT into penjualan

values("p001","printer epson1","400000")

INSERT into penjualan

values("p002","printer hp","452000")

INSERT into penjualan

values("p003","printer canon","463000")

Membuat isi table dg SQL ;

INSERT into penjualan

values("k001","keyboard komic","50000")

INSERT into penjualan

values("M001","mouse komic","25500")

INSERT into penjualan

values("p001","printer epson1","400000")

INSERT into penjualan

values("p002","printer hp","452000")

INSERT into penjualan

values("p003","printer canon","463000")

membuat tabel penjualan dg SQL

CREATE table penjualan (kodebarang text (5) primary key,namabarang text (20),harga currency,jumlahbeli text (5));

membuat isi tabel dg SQL

INSERT into penjualan

values ("k001","keyboard komic","500000","5")
INSERT into penjualan

values ("m001","mouse komic","25500","6")
INSERT into penjualan

values ("p001","printer epson1","400000","3")
INSERT into penjualan

values ("p001","printer hp","452000","6")
INSERT into penjualan

values ("p001","printer canon","463000","5")

 membuat table transaksi dg SQL;

CREATE table transaksi (nofaktur text(5) primary key,tanggal date,kodebarang text(5),jumlahbeli text(5),totalbayar currency);

membuat isi tabel dg SQL;

INSERT into transaksi

values("f01","31/10/2011","k001","5","250000")

INSERT into transaksi

values("f02","31/10/2011","m001","6","153000")

INSERT into transaksi

values("f03","1/11/2011","p001","3","1200000")

INSERT into transaksi

values("f04","1/11/2011","p002","6","2712000")

INSERT into transaksi

values("f05","1/11/2011","p003","5","2315000")