Re: [belajar-access] Re: contoh database gudang

[aksan kurdin]

anda buat saja dalam format txt, di zip, lalu attachkan ke milis

aksan kurdin

2008/4/16 Marc Christoph <[EMAIL PROTECTED]>:
>
>
>
>
>
>
>
>
>
> Mohon maaf formatnya berantakan, akan saya susun ulang
>
>
>
>
> Best regards,
>
> Marc
>
>
>
>
>
> From: belajar-access@yahoogroups.com [mailto:[EMAIL PROTECTED]
> On Behalf Of Marc Christoph
>  Sent: Wednesday, April 16, 2008 6:29 PM
>  To: belajar-access@yahoogroups.com
>  Subject: RE: [belajar-access] Re: contoh database gudang
>
>
>
>
>
>
>
>
> Hi Bung Aksan,
>
>
>
> Sementara ini berikut dibawah ini contoh laporan yang diperlukan :
>
>
>
>
> belajar-access project
>
>
>
>
> Contoh Laporan : LAP-001 Laporan Stock Counter
>
>
>
>
> Periode : 1 Maret 2008 - 31 Maret 2008
>
>
>
>
> ID Produk
>
> Category
>
> Product
>
> Design
>
> Nama Counter
>
> TOTAL
>
>
>
>
> MDS Padang
>
> MDS Depok TS
>
> MDS Simpang 5 Smrg
>
> MDS Manado
>
> Java Thamrin
>
> Java Artha Gading
>
>
>
>
> 10789
>
> Apron
>
> Celemek 80cm x 92cm Bear Pumpkin
>
> Bear Pumpkin
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> 10790
>
> Apron
>
> Celemek 80cm x 92cm Country Chicken
>
> Country Chicken
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> 10791
>
> Apron
>
> Celemek 70cm x 85cm Bear Pumpkin
>
> Bear Pumpkin
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> 10792
>
> Pot Holder
>
> Cempal 18cm x 18cm Bear Pumpkin
>
> Bear Pumpkin
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> 10793
>
> Table Cloth
>
> Taplak Meja 140cm x 240cm Lebaran
>
> Lebaran
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> 10794
>
> Apron
>
> Celemek 80cm x 92cm Lebaran
>
> Lebaran
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> 10795
>
> Ovenmitten
>
> Sarung Tangan Masak 20cm x 30cm Lebaran
>
> Lebaran
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> belajar-access project
>
>
> Contoh Laporan : LAP-002 Laporan Sales Counter
>
>
> Periode : 1 Maret 2008 - 31 Maret 2008
>
>
> ID Produk
>
> Category
>
> Product
>
> Design
>
> Nama Counter
>
> TOTAL
>
>
> MDS Padang
>
> MDS Depok TS
>
> MDS Simpang 5 Smrg
>
> MDS Manado
>
> Java Thamrin
>
> Java Artha Gading
>
>
> 10789
>
> Apron
>
> Celemek 80cm x 92cm Bear Pumpkin
>
> Bear Pumpkin
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> 10790
>
> Apron
>
> Celemek 80cm x 92cm Country Chicken
>
> Country Chicken
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> 10791
>
> Apron
>
> Celemek 70cm x 85cm Bear Pumpkin
>
> Bear Pumpkin
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> 10792
>
> Pot Holder
>
> Cempal 18cm x 18cm Bear Pumpkin
>
> Bear Pumpkin
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> 10793
>
> Table Cloth
>
> Taplak Meja 140cm x 240cm Lebaran
>
> Lebaran
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> 10794
>
> Apron
>
> Celemek 80cm x 92cm Lebaran
>
> Lebaran
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> 10795
>
> Ovenmitten
>
> Sarung Tangan Masak 20cm x 30cm Lebaran
>
> Lebaran
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> belajar-access project
>
>
> Contoh Laporan : LAP-003 Laporan Retur Counter
>
>
> Periode : 1 Maret 2008 - 31 Maret 2008
>
>
> ID Produk
>
> Category
>
> Product
>
> Design
>
> Nama Counter
>
> TOTAL
>
>
> MDS Padang
>
> MDS Depok TS
>
> MDS Simpang 5 Smrg
>
> MDS Manado
>
> Java Thamrin
>
> Java Artha Gading
>
>
> 10789
>
> Apron
>
> Celemek 80cm x 92cm Bear Pumpkin
>
> Bear Pumpkin
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> 10790
>
> Apron
>
> Celemek 80cm x 92cm Country Chicken
>
> Country Chicken
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> 10791
>
> Apron
>
> Celemek 70cm x 85cm Bear Pumpkin
>
> Bear Pumpkin
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> 10792
>
> Pot Holder
>
> Cempal 18cm x 18cm Bear Pumpkin
>
> Bear Pumpkin
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> 10793
>
> Table Cloth
>
> Taplak Meja 140cm x 240cm Lebaran
>
> Lebaran
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> 10794
>
> Apron
>
> Celemek 80cm x 92cm Lebaran
>
> Lebaran
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> 10795
>
> Ovenmitten
>
> Sarung Tangan Masak 20cm x 30cm Lebaran
>
> Lebaran
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> belajar-access project
>
>
>
>
> Contoh Laporan : LAP-004 Laporan Penjualan Per Counter Per Periode (product
> performance based) <-bisa juga untuk total keseluruhan
>
>
>
>
> Periode : 1 Maret 2008 - 31 Maret 2008
>
>
>
>
> Counter : MDS Padang
>
>
>
>
>
> ID Product
>
> Product
>
> Harga
>
> Stock Awal
>
> Kirim
>
> Jual
>
> Jual (Nilai)
>
> Stock
>
> Sales Performance
>
>
> 10789
>
>
> Celemek 80cm x 92cm Bear Pumpkin
>
> 39900
>
>
>
>
>
>
>
> = [jual]*[harga]
>
> =[stockawal]+[kirim]-[jual]
>
> =[jual/([stockawal]+[kirim]) %
>
>
> 10790
>
>
> Celemek 80cm x 92cm Country Chicken
>
> 39900
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> 10791
>
>
> Celemek 70cm x 85cm Bear Pumpkin
>
> 39900
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> 10792
>
>
> Cempal 18cm x 18cm Bear Pumpkin
>
> 9900
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> 10793
>
>
> Taplak Meja 140cm x 240cm Lebaran
>
> 99900
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> 10794
>
>
> Celemek 80cm x 92cm Lebaran
>
> 39900
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> 10795
>
>
> Sarung Tangan Masak 20cm x 30cm Lebaran
>
> 12900
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> belajar-access project
>
>
>
>
> Contoh Laporan : LAP-005 3Month Sales Analysis
>
>
>
>
> Counter : MDS Padang
>
>
>
>
> For Month : Maret 2008
>
>
>
>
>
> No
>
> Nama Counter
>
> Januari 2008
>
> Februari 2008
>
> Maret 2008
>
> Month Growth
>
> 3 Month Avg
>
> 3 Month Average Growth
>
>
> 1
>
> MDS Padang
>
>
>
>
>
>
>
> =([maret2008]-[februari2008])/[februari2008]
>
> =[jan]+[feb]+[mar]/3
>
> =[maret]-[3MAvg]/[3MAvg]
>
>
> 2
>
> MDS Depok TS
>
>   ...
>
> [Message clipped]



-- 
Aksan Kurdin