TRUNG TAM TIN HOẽC ẹH KHOA HOẽC Tệẽ NHIEN TP.HO CH MINH
15_SC_B1_0736_0061_200908_74.doc Trang 1/2
thi :
TIN HC B1
Thi gian : 90 phỳt
Ngy thi :
*** Cỏc k
t qu lu vo a l
m vi
c chm im ***

Cõu 1: To c s d liu (CSDL) nh sau (3 im)
- To tp tin CSDL ti th mc lm bi thi vi tờn l <STT>.MDB (<STT>: s th t ca thớ sinh)
- Cỏc field c gch di, in m v nghiờng l khúa chớnh ca bng.
DONVIKD N V KINH DOANH
Field Name Field Type Field Size Caption Description
MADV Text 5 Mó n v Mó n v
QUAN Text 20 Qun Qun
TENDV Text 50 Tờn n v Tờn n v
NGANHNGHE NGNH NGH
Field Name Field Type Field Size Caption Description
MANN Text 4 Mó ngnh ngh Mó ngnh ngh
TENNN Text 50 Tờn ngnh ngh Tờn ngnh ngh
TIENTHUE Number Long Integer Tin thu Tin thu
PHIEUTHUTHUE PHIU THU THU
Field Name Field Type Field Size Caption Description
SOBIENLAI Autonumber Long Integer S biờn lai S biờn lai
MADV Text 5 Mó n v Mó n v
MANN Text 4 Mó ngnh ngh Mó ngnh ngh
THANGNAM Text 6 Thỏng nm Nhp dng MMYYYY
SOTIEN Number Long Integer S tin S tin

N002 Kinh doanh nh hng khỏch sn

1000000
N003 Kinh doanh trung tõm gii trớ 800000

PHIEUTHUTHUE
SOBIENLAI

MADV

MANN

THANGNAM

SOTIEN

1 DV001 N001 072002 210000
2 DV001 N001 082002 880000
3 DV002 N002 092002 1350000

THAMGIA
MADV

MANN

NGAYDANGKY

TIENTHUEPHAIDONG

DV001 N001 09/06/2002 210000