bài tập tin học nâng cao, Exercises of Information Systems

Download bài tập tin học nâng cao and more Exercises Information Systems in PDF only on Docsity! BANG BAO CAO BAN s61T MA MA _TEN |DON VI KHACH HANG SAN PHAM SAN PHAM | TiNH 2|KHO2 B400 4|KHO4 B400 8|KHO3 B400 BS 6|KHO6 BL1 9|KHO1 BL1 5IKHO5 HS4P. 10|KHO7 HS4P. 3|KHO3 QD1 7|KHO2 QD1 1[KHO1 QTL BANG 1 MA TEN DON GIA SAN PHAM SAN PHAM NHAP Yéu cau thiét ké : 1/. Tén san phdm : Dua vao MA san pham tra trong BANG 1 (14) 2/. Bon vi tinh : Néu la canh quat ban thi don vi tinh la "cai" con lai la ""c 3/. Don gia ban: Don gia nhap *1.1 Biét rang : Don gid nhap duoc dua vao Ma san pham tra tim tre 4/.Tién van chuyén:Néu s6 luong >110 thi tign van chuyén la 20000 ng 5/. Thanh tién : S6 lvong * Don gia ban + tién van chuyén (1d) 6/.Sap xép cOt Ma san phdm theo tht? tw gidm dan. (1d) 7/. Rut trich cac thong tin lién quan dén mat hang Quat hoi nuéc (2d) 8/. Théng ké bang tinh theo mau sau: (24) DON _ TIEN _ |THANH GIA__| VAN CHUYEN | TIEN THONG KE ay” (1d) ong BANG 1) (1d) jwoc lai tién van chuyén= 0 (1d) BANG CHI TIET BAN HANG Stt Ma hang Mat hang Ngay ban | S6 luong Don gia 1/BDDQ 5/15/2009 12) 2|/BDNT 5/18/2009 25 3|CT 5/23/2009) 10) A4|IBDGN 5/23/2009 60 5|BDTS 5/28/2009 22 6|BDGN 6/1/2009} 24 7|CT 6/3/2009} 100 8|BDTS 6/6/2009} 240 9IBDTS 6/8/2009} 15) 10|CT 6/8/2009} 5) DANH MUC BONG MUC BONG DEN _ Ma hang _| Yéu cau: 1/,Mat hang : Tén hang & Nhan hiéu (2d) Tén hang : Néu 2 ky ty dau ctia Ma hang la "CT" ghi la "C6ng Tac" con lai ¢ Nhan hiéu : Dua vao 2 ky tw cudi cla Ma hang tra tim trong BANG DANH \ Vd: Ma hang BDDQ =>" Bong dén - dién quang" 2/.Bon gia: Dua vao 2 ky tw cudi cla Ma hang tra tim trong BANG DANH WV 3/.Thanh tién: S6 lwong * Don gia. Néu ngay ban sau ngay 01/06/2009 thi « 4./ Sap xép bang tinh tang dan theo ma hang (14) 5./Rut trich nhteng mat hang ban sau ngay 01/06/2009 (1d) 6/.Tinh bang théng ké theo mau trén (2d) Thanh Tién IG THONG KE | jhi la "Bong Den" AUC BONG DEN 1UC BONG DEN (24) giam 10% thanh tién (2d) BANG BAO CAO DOANH SO NHAP HAI MAT HANG THU'C PHAM MA TEN NGAY « DON DON VI STT | HANG | HANG NHAP SO LUONG GIA TINH 1721 2/15/2007) 40 2/032 2/19/2007) 10 3/732 3/17/2007 80) 4|M11 4/24/2007 50) 5/31 4/22/2007 45 622 5/25/2007) 35) 7711 7/26/2007, 30) 8|012 7/27/2007) 70) giM22 9/30/2007) 25) BANG 1 MA TEN DON GIA HANG | HANG - - x = Loai 1 Loai 2 [MIEN THUE Yéu cau : 1/. Tén hang : Dua vao ky tv dau cia Ma hang tra tim trong BANG 11 (1d) 2/. Bon gid : Dua vao ky tu dau , ky ty cudi cla Ma hang tra tim trong BANG : 3/.Bon vi tinh : Néu hang thuéc loai dau thi don vi tinh la Lit con lai la Kg (1d) 4/.Thanh tién : S6 lvong *Don gia Nhung néu sé lvorng >=50 thi giam 10% c 5/. Mién thué : Dua vao ky tu dau cla Ma hang tra tim trong BANG 11 (1) 6/.Thué:Thanh tién * ti lé thué . Chi tinh thué nhing mat hang khéng duoc mién thué nguoc lai dé tré Biét rang : Ti1é thué duoc dua vao ky ty tht? 2 cla ma hang tra tim tr 7./ Sap xép bang tinh tang dan theo ma hang (14) 8/. Rut trich nhtrng mat hang nhap trong Thang 7 va co s6 lvong>15 (1d) Thanh tién YN GIA éu 2 ky tu cudi ng BANG BON GIA(2d) giam 5% cua 3n (1d) Quéc(1d) ‘ « x x MUA DON NGAY KA sé MALOAI |=.) 03 MA NHA i BAN MAHANG | tyonG | HANG | TEN HANG) can xuAT (wep) 1/5/2007|KDB-DELL 120 2/19/2007|SCN-BENQ 25) 2/20/2007|SCN-UMAX 50) 1/5/2007|/MAI-DELL 115) 1/15/2007|SCN-BENQ 30) 3/8/2007|KDB-DELL 230 2/19/2007|MOU-UMAX 100 /27/2007|KDB-BENQ 40 3/1/2007|MAI-UMAX 56 BANG DON GIA ® Inni ha an pa Don gia theo Ma nha san xuat Ma loai hang] Tén hang DELL BENO UMAX Yéu cau : 1/._Ma loai hang : La 3 ky ty dau cla Ma hang (0.5d) 2/. Tén hang : Dua vao ma loai hang tra tim trong BANG DON GIA (1d) 3/. Ma nha san xuat : La 4 ky ty cudi cua Ma hang (0.54) 4/. Bon gid : Dua vao ma loai hang , MA nha san xuat tra tim trong BANG DON GI 5/. Tién giam: Néu mat hang ban ra cd sé Ivong Ién hon 200 thi tién giam bang 1 -Nguoc lai tién giam la 0 (1.54) 6/. Thanh tién (USD) : s6 lwo'ng * don gia (USD) - Tién giam (0.54) 7/. Thanh tién (VNB) : thanh tién (USD) * ty gia. Biét rang : Néu hang ban ra tlr thang 1 dén thang 2 thi ty gid 15000 con lai la 15300 (2d) 8/._ Rut trich nhtrng mat hang ban ra vao thang 3 va c6 sé lvong >=200 (1d) 9/. Lap bang théng ké theo mau sau (1d) BANG THONG KE MAT HANG Keyboard scanner Mainboard Mouse S6 lvong UT THANH PHi VAN TIEN CHUYEN !) athanh tién, nguocc lai khéng giam (2d) tién , con lai la 1%* thanh tién (2d) TINH HINH NHAP BIA QUI | NAM 2007 Mas6 /|Tén Dia ‘Don gia Ngay nhap S6 luong AOL 8000 1/12/2007) Bo2 7000 2/5/2007) C03 10000 3/9/2007) Do4 12000 1/1/2007 lbo5 11000 3/24/2007 \AOG 8000 1/29/2007) DO7 12000 2/2/2007) Bos 7000 2/5/2007) BANG 1 BANG SO LUONC Maia [Tenia Yéu cau: 1/. Tén dia : Dua vao Ma dia tra tim trong BANG 1 (14) 2/. S6 Iwong : Dua vao Ma dia, thang nhAp tra tim trong BANG SO LUON( 3/. Thanh tién : S6 lwong * Don gia Nhung néu mat hang nhap truéc than: 4/.Ghi chi : Néu mat hang duoc nhap trong thang 1 thi ghi" Co khuyén ir 5/._Rut trich nhtrng mat hang co ky tu dau cla Ma dia la A va co sé luong : 6/. Sap x6p bang tinh tang dn theo tén dia va gidm dan theo sé lvong (1d) 7/.Lap bang th6ng ké theo mau sau: (1d) BANG THONG KE Ma dia Tong s6 lueng > 010 |B 8/._Rut trich_cac mat hang c6 tén dia la don xuan va ban trong thang 1 (1d) Thanh tién Ghi cha 3 DIA NHAP THEO THANG 3 DIA NHAP THEO THANG (24) g 3 thi giam 5% cla thanh tién .Nguoc lai khong giam (1d) 1ai", nguo'c lai dé trong (1d) >=10 (2d) ) “HAO THANH TIEN DON GIA | THUE 1(14) 32(14) 1 (1d) ing BANG1 (2d) ) va ban vao ngay 20/11/2005 SO BAN HANG A 5 TEN |DON VI A sé NGAY HOABON | yang | tind | PONSA | LUoNG 11/5/2007|0010T 25 11/18/2007|002TN 40 11/20/2007|002BL 10 11/25/2007|003TC 8 11/29/2007|001HL 20 11/30/2007|002TC 9 1/1/2008|003PV 45 1/5/2008|002TN 42 1/9/2008|003TC 11 BANG 2 Ma nhom BANG 1 én nhom on vi tinh Th6ng ké thanh i Tén hang | Tam Chau M6 ta: Trung nguyén 2 ky tu cudi cla hoa don cho biét M4 San pham Ky tu tht? 3 cla hda don cho biét Ma nhom Yéu cau: 1/. Tén hang : Tén nhom & Tén san pham . Biét rang : Tén nhém : Dua vao Ma nhom tra tim trong BANG 2 Tén sn phdm : Dua vao Ma san pham tra tim trong BANG 1 Vd: Héa don la : O02TN => Tén hang " Ca Phé - Trung Nguyén" 2/. Don vi tinh : Dwa vao ma nhom tra tim trong BANG 2 3/ Bon gia : Dua vao mA san pham tra tim trong BANG 1 4/. Thanh tién : S6 lvong * Don gia . Biét rang : Néu s6 lvong >40 va ban va thi thanh tién duoc giam 5%. Nguoa lai khong giam 5/. Khuyén mai: Nhivng mat hang ban trong khoang thoi gian tly 30/11/2007 ¢ thi ghi "C6 qua tang" , cn lai dé tréng. 6/.Rut trich théng tin cac mat hang ca phé va ban trong nam 2007 7/. Lap bang théng ké theo mau trén