際際滷

際際滷Share a Scribd company logo
sydngsoft.wordpress.com 16
M c l c
1. Th c hi n ch動董ng tr狸nh: ...................................3
2. Ch c nng IN N, NH P LI U ......................3
3. Nh p d li u t Ms EXCELL ..........................4
4. Xu t d li u ra Ms Excel...................................5
5. In B ng t t nghi p, CC......................................6
6. S a m u khi in ...................................................7
7. Tho叩t ch動董ng tr狸nh ...........................................7
8. Ph l c : t o C gi y cho m叩y in Oliveti PR2 15
9. M c l c........................................................... 16
sydngsoft.wordpress.com 1
sydngsoft.wordpress.com
Chuy棚n gia trong l挑nh v c ph n m m POS
H動 ng d n s d ng
Ph n m m in b ng t t nghi p:
i h c, cao ng
Trung h c chuy棚n nghi p
Gi y khen
Ch ng ch : thanh tra, gi叩o d c
qu c ph嘆ng, Gi叩o d c th ch t,
Ch ng ch ngo i ng ,...
sydngsoft.wordpress.com 2
Xin c m 董n Qu箪 kh叩ch 達 quan t但m s d ng Ch動董ng tr狸nh.
M i g坦p 箪 y棚u c u, x但y d ng, ch nh s a.
Ho c c叩c M u bi u kh担ng s n c坦 trong Ch動董ng tr狸nh Qu箪
kh叩ch KHNG NG N NG I g i n ch炭ng t担i qua s m叩y:
0511 370 1857 . Hotline : 0935 800 729
e-mail: sydngsoft@gmail.com
website: sydngsoft.wordpress.com
sydngsoft.wordpress.com 15
Ph l c:
T o C gi y cho M叩y in Olivety PR2
B動 c 1:
Start -> Setting -> Printer and Fax
B動 c 2 :
B m vo bi u t動 ng M叩y in Olivety PR2
B動 c 3 : File -> Server Properties
B動 c 4: Nh n tick vo Create New Form , nh p FormName
B動 c 5: Nh n OK
sydngsoft.wordpress.com 14
3) UPPER(chu i) => t o thnh ch HOA
(ch s d ng cho font VNI
4) PROPER(chu i) => t o thnh c但u c坦
ch c叩ch nhau th狸 k鱈 t u l ch HOA
(ch s d ng cho font VNI. Gi ng Title
Case trong MS WORD.
5) LOWER (chu i) => s thnh c但u ch
th動 ng.
6) date2Str(ngy th叩ng nm, D) => cho
ra ngy c a d li u ngy th叩ng v i qui
t c ngy <10 th狸 th棚m s 0 ph鱈a tr動 c.
7) date2Str(ngy th叩ng nm, M) => cho
ra THNG c a d li u ngy th叩ng v i qui
t c ngy < 3 th狸 th棚m s 0 ph鱈a tr動 c.
V r t nhi u hm kh叩c c坦 th 叩p d ng.
2.11. Tho叩t kh i mn h狸nh: nh n n炭t Tho叩t
3. Tho叩t kh i Ch動董ng tr狸nh: Nh n n炭t Tho叩t
Qu鱈 kh叩ch c坦 th y棚n t但m khi s d ng,
n u c坦 y棚u c u no v vi c b sung ch動董ng tr狸nh,
c叩c t鱈nh nng m i, c p nh t m u m i HO C c叩c y棚u
c u ph叩t sinh kh叩c m ch動a c坦 trong h動 ng d n ny.
Xin Qu箪 kh叩ch vui l嘆ng :
+ G i e-mail v : sydngsoft@gmail.com
+ G i i n tho i n s h tr Duy nh t : 0935 800
729
sydngsoft.wordpress.com 3
1. Th c hi n ch動董ng tr狸nh:
Sau khi th c hi n ch動董ng tr狸nh, Mn h狸nh s hi n th nh動
sau:
T湛y t ng ch c nng in n, m u bi u, c叩c th担ng tin s kh叩c
nhau. Mu n th c hi n ch c nng no , ch c n nh n vo
ch c nng 坦. V Nh n TH C HI N.
2. Mn h狸nh ch鱈nh c a c叩c ch c nng nh動 sau:
2.1. N炭t th棚m: Khi nh n n炭t ny, Ch動董ng tr狸nh s cho
ph辿p th棚m m i 1 th担ng tin, d湛ng bn ph鱈m nh p li u c叩c
th担ng tin t動董ng ng, sau 坦 nh n n炭t L働U l動u th担ng tin
l i.
2.2. S a i th担ng tin 達 c坦: Nh n vo danh s叩ch b棚n
d動 i, th担ng tin s hi n th l棚n b棚n tr棚n, d湛ng bn ph鱈m
nh p s a th担ng tin v nh n n炭t L働U l動u l i.
2.3. N炭t H y l nh: trong tr動 ng h p Th棚m m i hay S a
i (m c 2.1 v 2.2) s cho ph辿p v l i Ban u (kh担ng
l動u)
2.4. X坦a d li u: x坦a d li u c n nh n n炭t CH N,
CH N H T b棚n d動 i, khi c坦 n炭t TICK s 動 c x坦a.
sydngsoft.wordpress.com 4
2.5. Nh p d li u t EXCELL:
Ch動董ng tr狸nh cho ph辿p nh p danh s叩ch t Ms EXCELL
2002 tr v tr動 c.
2.5.1. th c hi n i u ny , nh n n炭t EXCELL >>
2.5.2. Khi 坦 s hi n th mn h狸nh OPEN
Ch炭 箪 : Khi d li u b x坦a th狸 kh担ng kh担i
ph c 動 c
C叩c file m u 動 c l動u th動 m c DATA
Tr棚n thanh ti棚u hi n th T棚n file c n m
sydngsoft.wordpress.com 13
M t s HM 動 c s d ng trong khi S a m u bi u:
1) DMY2S(ngy th叩ng) : t o ra ngy
th叩ng d ng DD / MM / YYYY
N u ngy <10 -> c坦 s 0 ph鱈a tr動 c
N u th叩ng < 3 c坦 s 0 ph鱈a tr動 c
V鱈 d : DMY2S(2/12/2010) => 02/12/2010
DMY2S(12/2/2010) => 12/02/2010
2.1) ABC2VNI( chu i font ABC) -> Chu i
fonts VNI
2.2) ABC2BK2( chu i font ABC) -> Chu i
fonts BK HCM 2
H T棚n
(1
(1
(2
(2
Ch炭 箪 : xoay ch kh担ng b m t ch 働, 
(h n ch c a fonts 1 BYTE), ta s d ng hm ABC2VNI
(t棚n bi n) dung.
+ Ph但n bi t FONTS TCVN3, VNI: xem t棚n fonts bi t:
 TCVN3 (hay c嘆n g i l ABC), t棚n font b t u b ng
d u CH M ..
 VNI : t棚n font b t u b ng ch VNI
+ i v i FONTS TCVN3, in Ch Hoa ta d湛ng t棚n fonts
v i ch H i sau. V鱈 d : fonts .vnTimeH
+ i v i fonts VNI in ch HOA ta d湛ng hm
UPPER(ABC2VNI(t棚n bi n))
sydngsoft.wordpress.com 12
Mn h狸nh s a m u in
Qui t c:
L y i m O lm g c, ch動董ng tr狸nh s xoay i t動 ng 270
theo chi u cao (1) t o thnh (1) , v (2) thnh (2).
Nh動 v y, ta c n d ch chuy n lm sao cho Kho ng c叩ch X
n 動 ng LINE (d嘆ng s in) 炭ng b ng chi u cao c a i
t動 ng. V kho ng c叩ch t u trang gi y n i m O , s l
chi u di t B棚n ph i c a d嘆ng LINE n b棚n tr叩i.
sydngsoft.wordpress.com 5
2.5.3. Nh n n炭t OPEN m .
D li u s 動 c 動a vo danh s叩ch.
2.6. Xu t d li u ra file EXCELL:
Trong tr動 ng h p D li u 達 動 c nh p t Ch動董ng tr狸nh,
Mu n 動a ra Ms EXCELL s a i b sung cho nhanh
ch坦ng. Ta th c hi n c叩c b動 c sau:
2.6.1. Nh n n炭t EXCELL >>
Khi 坦 s hi n th c a s SAVE nh動 sau:
2.6.2. G探 t棚n file vo 担 L動u file
1) Ti棚u File
DAIHOC.XLS
Tr棚n thanh ti棚u hi n th T棚n file c n L動u
2) Ch n
炭ng FILE
3) Nh n OPEN
sydngsoft.wordpress.com 6
2.6.3. Nh n SAVE
2.7. Sao l動u d li u: M c 鱈ch nh m chuy n sang m t file
kh叩c l動u tr , tr叩nh tr動 ng h p b h ng d li u.
2.8. Ch n, Ch n h t, B , B h t: Nh m ch n / b ch n
c叩c H c sinh, h c vi棚n, Sinh vi棚n , C叩n b t danh s叩ch .
Th c hi n c叩c t叩c v In CC hay X坦a
2.9. In B ng t t nghi p, ch ng ch : 3 b動 c
2.9.1. Ch n t danh s叩ch b ng ch c nng 2.8
2.9.2. Ch n ch c nng In theo m u ch NGANG , hay m u
ch NG.
Xem th棚m : http://my.opera.com/sydngsoft/blog
http://my.opera.com/sydngsoft/blog/2010/10/01/tai
2.9.3. Nh n In CC
Mn h狸nh hi n th m u in xem tr動 c
1) Thanh ti棚u
c坦 T棚n file
2) G探 vo
T棚n file
3) Nh n
Save
sydngsoft.wordpress.com 11
2. S a m u v i ch in ng
s a m u v i ch ng ch炭ng ta c n xem m担 h狸nh sau:
Mn h狸nh xem tr動 c khi in
sydngsoft.wordpress.com 10
Canh cho th ng hng C叩c
i t動 ng ang ch n!
LEFT : tr叩i
RIGHT : Ph i
TOP : tr棚n nh
BOTTOM : d動 i ch但n
sydngsoft.wordpress.com 7
2.9.4. Nh n n炭t h狸nh MY IN in ra M叩y in
2.10. S a m u Khi in: nh n n炭t S a m u
Ph n m m cung c p m t GIAO DI N H A cho ph辿p
s a ch a m u khi in cho ph湛 h p v i kh gi y, l , trang in,
kho ng c叩ch c叩c d嘆ng ch鱈nh x叩c n t ng i m nh
(PIXEL).
1. t o cho M u In b ng:
Report -> properties -> ruler
Ch n Ruler & Grid
Ch n Metric / Cm (nh動 h狸nh)
Nh n OK
N炭t in
N炭t 坦ng mn h狸nh
C叩c n炭t ti n - lui
sydngsoft.wordpress.com 8
2. Ch nh cao cho M u In b ng:
Nh n S a m u -> 動a tr chu t n d嘆ng Detail cho
xu t hi n m滴i t棚n 2 u
K辿o xu ng n s 20cm (c坦 s 20 b棚n tr叩i)
3. S a m u v i ch in Ngang TEXT
Thanh Detail
sydngsoft.wordpress.com 9
D湛ng ph鱈m m滴i t棚n
LN XU NG di
chuy n.
SHIFT + ph鱈m m滴i t棚n
m r ng SIZE.
CLICK ch n i t動 ng
+ Nh n ph鱈m SHIFT + click
ch n nhi u i t動 ng.
Ch n thay i Font Ch

More Related Content

What's hot (16)

Bi 16- 畛nh d畉ng vn b畉n
Bi 16- 畛nh d畉ng vn b畉nBi 16- 畛nh d畉ng vn b畉n
Bi 16- 畛nh d畉ng vn b畉n
Bich Tuyen
BI 15: LM QUEN V畛I MICROSOFT WORD
BI 15: LM QUEN V畛I MICROSOFT WORDBI 15: LM QUEN V畛I MICROSOFT WORD
BI 15: LM QUEN V畛I MICROSOFT WORD
Tr畉n Nh但n
Book phan 2_winword
Book phan 2_winwordBook phan 2_winword
Book phan 2_winword
vinhduchanh
Gi叩o tr狸nh word
Gi叩o tr狸nh wordGi叩o tr狸nh word
Gi叩o tr狸nh word
Anh T動
Thvp word
Thvp wordThvp word
Thvp word
Loan Nguyen
際際滷 word
際際滷 word際際滷 word
際際滷 word
lam04dt
tin h畛c l畛p 6
tin h畛c l畛p 6tin h畛c l畛p 6
tin h畛c l畛p 6
H畛c T畉p Long An
Giao an tin hoc van phong ban chuan
Giao an tin hoc van phong ban chuanGiao an tin hoc van phong ban chuan
Giao an tin hoc van phong ban chuan
勳亰亶 丿舒于亢亳亶仆
T畛ng h畛p 畛 c動董ng th畛c hnh c畉 3 ph畉n
T畛ng h畛p 畛 c動董ng th畛c hnh c畉 3 ph畉n T畛ng h畛p 畛 c動董ng th畛c hnh c畉 3 ph畉n
T畛ng h畛p 畛 c動董ng th畛c hnh c畉 3 ph畉n
HG R畛ng Con
Nh畛ng i畛m kh叩c bi畛t t畛 word 2003 v 2007
Nh畛ng i畛m kh叩c bi畛t t畛 word 2003 v 2007Nh畛ng i畛m kh叩c bi畛t t畛 word 2003 v 2007
Nh畛ng i畛m kh叩c bi畛t t畛 word 2003 v 2007
mrtomlearning
Chuong1 Tong quan ve microsft word
Chuong1 Tong quan ve microsft wordChuong1 Tong quan ve microsft word
Chuong1 Tong quan ve microsft word
H嘆a Hong
畛 C動董ng n T畉p Tin H畛c 畛ng D畛ng (C坦 叩p n)
畛 C動董ng n T畉p Tin H畛c 畛ng D畛ng (C坦 叩p n) 畛 C動董ng n T畉p Tin H畛c 畛ng D畛ng (C坦 叩p n)
畛 C動董ng n T畉p Tin H畛c 畛ng D畛ng (C坦 叩p n)
nataliej4
GT Word
GT WordGT Word
GT Word
Nguyen
Word2010
Word2010Word2010
Word2010
H嘆a V探 D動董ng
Tn th 10_hk2
Tn th 10_hk2Tn th 10_hk2
Tn th 10_hk2
V探 T但m Long
Bi 16- 畛nh d畉ng vn b畉n
Bi 16- 畛nh d畉ng vn b畉nBi 16- 畛nh d畉ng vn b畉n
Bi 16- 畛nh d畉ng vn b畉n
Bich Tuyen
BI 15: LM QUEN V畛I MICROSOFT WORD
BI 15: LM QUEN V畛I MICROSOFT WORDBI 15: LM QUEN V畛I MICROSOFT WORD
BI 15: LM QUEN V畛I MICROSOFT WORD
Tr畉n Nh但n
Book phan 2_winword
Book phan 2_winwordBook phan 2_winword
Book phan 2_winword
vinhduchanh
Gi叩o tr狸nh word
Gi叩o tr狸nh wordGi叩o tr狸nh word
Gi叩o tr狸nh word
Anh T動
際際滷 word
際際滷 word際際滷 word
際際滷 word
lam04dt
T畛ng h畛p 畛 c動董ng th畛c hnh c畉 3 ph畉n
T畛ng h畛p 畛 c動董ng th畛c hnh c畉 3 ph畉n T畛ng h畛p 畛 c動董ng th畛c hnh c畉 3 ph畉n
T畛ng h畛p 畛 c動董ng th畛c hnh c畉 3 ph畉n
HG R畛ng Con
Nh畛ng i畛m kh叩c bi畛t t畛 word 2003 v 2007
Nh畛ng i畛m kh叩c bi畛t t畛 word 2003 v 2007Nh畛ng i畛m kh叩c bi畛t t畛 word 2003 v 2007
Nh畛ng i畛m kh叩c bi畛t t畛 word 2003 v 2007
mrtomlearning
Chuong1 Tong quan ve microsft word
Chuong1 Tong quan ve microsft wordChuong1 Tong quan ve microsft word
Chuong1 Tong quan ve microsft word
H嘆a Hong
畛 C動董ng n T畉p Tin H畛c 畛ng D畛ng (C坦 叩p n)
畛 C動董ng n T畉p Tin H畛c 畛ng D畛ng (C坦 叩p n) 畛 C動董ng n T畉p Tin H畛c 畛ng D畛ng (C坦 叩p n)
畛 C動董ng n T畉p Tin H畛c 畛ng D畛ng (C坦 叩p n)
nataliej4
GT Word
GT WordGT Word
GT Word
Nguyen

Similar to Huongdan inbang (20)

Bai tap tin a iuh
Bai tap tin a iuhBai tap tin a iuh
Bai tap tin a iuh
H畉i Finiks Hu畛nh
Giaotrinh access 2010_full_3531
Giaotrinh access 2010_full_3531Giaotrinh access 2010_full_3531
Giaotrinh access 2010_full_3531
L棚 Th畉m
H働畛NG D畉N TH畛C HNH 畛NG D畛NG CNTT C B畉N.pdf
H働畛NG D畉N TH畛C HNH 畛NG D畛NG CNTT C B畉N.pdfH働畛NG D畉N TH畛C HNH 畛NG D畛NG CNTT C B畉N.pdf
H働畛NG D畉N TH畛C HNH 畛NG D畛NG CNTT C B畉N.pdf
ssuser4218df
Canban microstaton
Canban microstatonCanban microstaton
Canban microstaton
Ttx Love
Canban microstaton
Canban microstatonCanban microstaton
Canban microstaton
Phi Phi
Huong dan ky_nang_su_dung_excel_2003
Huong dan ky_nang_su_dung_excel_2003Huong dan ky_nang_su_dung_excel_2003
Huong dan ky_nang_su_dung_excel_2003
Nguy畛n Duy H動ng
Nh畛ng ki畉n th畛c c董 b畉n c畉n bi畉t v畛 Microsoft Word
Nh畛ng ki畉n th畛c c董 b畉n c畉n bi畉t v畛 Microsoft WordNh畛ng ki畉n th畛c c董 b畉n c畉n bi畉t v畛 Microsoft Word
Nh畛ng ki畉n th畛c c董 b畉n c畉n bi畉t v畛 Microsoft Word
Teddo Teddo
Giao an tin hoc van phong ban chuan
Giao an tin hoc van phong ban chuanGiao an tin hoc van phong ban chuan
Giao an tin hoc van phong ban chuan
H動ng Tr畛ng
Giao an tin hoc van phong ban chuan
Giao an tin hoc van phong ban chuanGiao an tin hoc van phong ban chuan
Giao an tin hoc van phong ban chuan
H動ng Tr畛ng
K37.103.529 tim hieu ve open office
K37.103.529 tim hieu ve open officeK37.103.529 tim hieu ve open office
K37.103.529 tim hieu ve open office
Tr畉n Nguy畛n Th畛 Tr動畛ng
Giao trinh access 2010
Giao trinh access 2010Giao trinh access 2010
Giao trinh access 2010
tranvuthanhkhiet
530 c3ce7 5a75-bfda-403d-eda9733b6aa8-giao_trinh_access_2010
530 c3ce7 5a75-bfda-403d-eda9733b6aa8-giao_trinh_access_2010530 c3ce7 5a75-bfda-403d-eda9733b6aa8-giao_trinh_access_2010
530 c3ce7 5a75-bfda-403d-eda9733b6aa8-giao_trinh_access_2010
Phi Phi
H動畛ng d畉n s畛 d畛ng access2010
H動畛ng d畉n s畛 d畛ng access2010H動畛ng d畉n s畛 d畛ng access2010
H動畛ng d畉n s畛 d畛ng access2010
B湛i Quang H動ng
畛ng d畛ng cntt qltb-truongmamnon
畛ng d畛ng cntt qltb-truongmamnon畛ng d畛ng cntt qltb-truongmamnon
畛ng d畛ng cntt qltb-truongmamnon
xuan thanh
S畛 d畛ng windows XP
S畛 d畛ng windows XPS畛 d畛ng windows XP
S畛 d畛ng windows XP
Nguy畛n Anh
TL huong dan lam quen va su dung MS word 2013
TL huong dan lam quen  va su dung MS word  2013TL huong dan lam quen  va su dung MS word  2013
TL huong dan lam quen va su dung MS word 2013
Trinh Hung
Tl open office_impress
Tl open office_impressTl open office_impress
Tl open office_impress
Chi L棚 Y畉n
Bai tapwindows 2
Bai tapwindows 2Bai tapwindows 2
Bai tapwindows 2
Hoa C畛 May
Giaotrinh access 2010_full_3531
Giaotrinh access 2010_full_3531Giaotrinh access 2010_full_3531
Giaotrinh access 2010_full_3531
L棚 Th畉m
H働畛NG D畉N TH畛C HNH 畛NG D畛NG CNTT C B畉N.pdf
H働畛NG D畉N TH畛C HNH 畛NG D畛NG CNTT C B畉N.pdfH働畛NG D畉N TH畛C HNH 畛NG D畛NG CNTT C B畉N.pdf
H働畛NG D畉N TH畛C HNH 畛NG D畛NG CNTT C B畉N.pdf
ssuser4218df
Canban microstaton
Canban microstatonCanban microstaton
Canban microstaton
Ttx Love
Canban microstaton
Canban microstatonCanban microstaton
Canban microstaton
Phi Phi
Huong dan ky_nang_su_dung_excel_2003
Huong dan ky_nang_su_dung_excel_2003Huong dan ky_nang_su_dung_excel_2003
Huong dan ky_nang_su_dung_excel_2003
Nguy畛n Duy H動ng
Nh畛ng ki畉n th畛c c董 b畉n c畉n bi畉t v畛 Microsoft Word
Nh畛ng ki畉n th畛c c董 b畉n c畉n bi畉t v畛 Microsoft WordNh畛ng ki畉n th畛c c董 b畉n c畉n bi畉t v畛 Microsoft Word
Nh畛ng ki畉n th畛c c董 b畉n c畉n bi畉t v畛 Microsoft Word
Teddo Teddo
Giao an tin hoc van phong ban chuan
Giao an tin hoc van phong ban chuanGiao an tin hoc van phong ban chuan
Giao an tin hoc van phong ban chuan
H動ng Tr畛ng
Giao an tin hoc van phong ban chuan
Giao an tin hoc van phong ban chuanGiao an tin hoc van phong ban chuan
Giao an tin hoc van phong ban chuan
H動ng Tr畛ng
530 c3ce7 5a75-bfda-403d-eda9733b6aa8-giao_trinh_access_2010
530 c3ce7 5a75-bfda-403d-eda9733b6aa8-giao_trinh_access_2010530 c3ce7 5a75-bfda-403d-eda9733b6aa8-giao_trinh_access_2010
530 c3ce7 5a75-bfda-403d-eda9733b6aa8-giao_trinh_access_2010
Phi Phi
H動畛ng d畉n s畛 d畛ng access2010
H動畛ng d畉n s畛 d畛ng access2010H動畛ng d畉n s畛 d畛ng access2010
H動畛ng d畉n s畛 d畛ng access2010
B湛i Quang H動ng
畛ng d畛ng cntt qltb-truongmamnon
畛ng d畛ng cntt qltb-truongmamnon畛ng d畛ng cntt qltb-truongmamnon
畛ng d畛ng cntt qltb-truongmamnon
xuan thanh
S畛 d畛ng windows XP
S畛 d畛ng windows XPS畛 d畛ng windows XP
S畛 d畛ng windows XP
Nguy畛n Anh
TL huong dan lam quen va su dung MS word 2013
TL huong dan lam quen  va su dung MS word  2013TL huong dan lam quen  va su dung MS word  2013
TL huong dan lam quen va su dung MS word 2013
Trinh Hung
Tl open office_impress
Tl open office_impressTl open office_impress
Tl open office_impress
Chi L棚 Y畉n
Bai tapwindows 2
Bai tapwindows 2Bai tapwindows 2
Bai tapwindows 2
Hoa C畛 May

More from Sydng Softwaregroup (14)

C叩ch d湛ng th動畛c 畛 o m畉u ph担i Ch畛ng ch畛, Ph担i b畉ng t畛t nghi畛p m叩y Olyverty P...
C叩ch d湛ng th動畛c 畛 o m畉u ph担i Ch畛ng ch畛, Ph担i b畉ng t畛t nghi畛p m叩y Olyverty P...C叩ch d湛ng th動畛c 畛 o m畉u ph担i Ch畛ng ch畛, Ph担i b畉ng t畛t nghi畛p m叩y Olyverty P...
C叩ch d湛ng th動畛c 畛 o m畉u ph担i Ch畛ng ch畛, Ph担i b畉ng t畛t nghi畛p m叩y Olyverty P...
Sydng Softwaregroup
Huong dan cai_dat
Huong dan cai_datHuong dan cai_dat
Huong dan cai_dat
Sydng Softwaregroup
Cach dung-thuoc-de-do
Cach dung-thuoc-de-doCach dung-thuoc-de-do
Cach dung-thuoc-de-do
Sydng Softwaregroup
Huong dan dat co giay-win7
Huong dan   dat co giay-win7Huong dan   dat co giay-win7
Huong dan dat co giay-win7
Sydng Softwaregroup
k鱈ch th動畛c ph担i b畉ng c叩c lo畉i
k鱈ch th動畛c ph担i b畉ng c叩c lo畉ik鱈ch th動畛c ph担i b畉ng c叩c lo畉i
k鱈ch th動畛c ph担i b畉ng c叩c lo畉i
Sydng Softwaregroup
Cach dung-thuoc-de-do
Cach dung-thuoc-de-doCach dung-thuoc-de-do
Cach dung-thuoc-de-do
Sydng Softwaregroup
Phan mem in bang Thac si
Phan mem in bang Thac siPhan mem in bang Thac si
Phan mem in bang Thac si
Sydng Softwaregroup
H動畛ng d畉n t畉o tem v in m達 v畉ch v畛i barttender
H動畛ng d畉n t畉o tem v in m達 v畉ch v畛i barttenderH動畛ng d畉n t畉o tem v in m達 v畉ch v畛i barttender
H動畛ng d畉n t畉o tem v in m達 v畉ch v畛i barttender
Sydng Softwaregroup
Huongdan phanmeminbangtotnghiep-font-unicode
Huongdan phanmeminbangtotnghiep-font-unicodeHuongdan phanmeminbangtotnghiep-font-unicode
Huongdan phanmeminbangtotnghiep-font-unicode
Sydng Softwaregroup
Huong dan-spa
Huong dan-spaHuong dan-spa
Huong dan-spa
Sydng Softwaregroup
Huong dan-dinh-muc
Huong dan-dinh-mucHuong dan-dinh-muc
Huong dan-dinh-muc
Sydng Softwaregroup
Nguyenchi phan-mem-cafe-nha-hang
Nguyenchi phan-mem-cafe-nha-hangNguyenchi phan-mem-cafe-nha-hang
Nguyenchi phan-mem-cafe-nha-hang
Sydng Softwaregroup
Nguyenchi phan-mem-cafe-nha-hang
Nguyenchi phan-mem-cafe-nha-hangNguyenchi phan-mem-cafe-nha-hang
Nguyenchi phan-mem-cafe-nha-hang
Sydng Softwaregroup
Nguyenchi phan-mem-cafe-nha-hang
Nguyenchi phan-mem-cafe-nha-hangNguyenchi phan-mem-cafe-nha-hang
Nguyenchi phan-mem-cafe-nha-hang
Sydng Softwaregroup
C叩ch d湛ng th動畛c 畛 o m畉u ph担i Ch畛ng ch畛, Ph担i b畉ng t畛t nghi畛p m叩y Olyverty P...
C叩ch d湛ng th動畛c 畛 o m畉u ph担i Ch畛ng ch畛, Ph担i b畉ng t畛t nghi畛p m叩y Olyverty P...C叩ch d湛ng th動畛c 畛 o m畉u ph担i Ch畛ng ch畛, Ph担i b畉ng t畛t nghi畛p m叩y Olyverty P...
C叩ch d湛ng th動畛c 畛 o m畉u ph担i Ch畛ng ch畛, Ph担i b畉ng t畛t nghi畛p m叩y Olyverty P...
Sydng Softwaregroup
k鱈ch th動畛c ph担i b畉ng c叩c lo畉i
k鱈ch th動畛c ph担i b畉ng c叩c lo畉ik鱈ch th動畛c ph担i b畉ng c叩c lo畉i
k鱈ch th動畛c ph担i b畉ng c叩c lo畉i
Sydng Softwaregroup
H動畛ng d畉n t畉o tem v in m達 v畉ch v畛i barttender
H動畛ng d畉n t畉o tem v in m達 v畉ch v畛i barttenderH動畛ng d畉n t畉o tem v in m達 v畉ch v畛i barttender
H動畛ng d畉n t畉o tem v in m達 v畉ch v畛i barttender
Sydng Softwaregroup
Huongdan phanmeminbangtotnghiep-font-unicode
Huongdan phanmeminbangtotnghiep-font-unicodeHuongdan phanmeminbangtotnghiep-font-unicode
Huongdan phanmeminbangtotnghiep-font-unicode
Sydng Softwaregroup
Nguyenchi phan-mem-cafe-nha-hang
Nguyenchi phan-mem-cafe-nha-hangNguyenchi phan-mem-cafe-nha-hang
Nguyenchi phan-mem-cafe-nha-hang
Sydng Softwaregroup
Nguyenchi phan-mem-cafe-nha-hang
Nguyenchi phan-mem-cafe-nha-hangNguyenchi phan-mem-cafe-nha-hang
Nguyenchi phan-mem-cafe-nha-hang
Sydng Softwaregroup
Nguyenchi phan-mem-cafe-nha-hang
Nguyenchi phan-mem-cafe-nha-hangNguyenchi phan-mem-cafe-nha-hang
Nguyenchi phan-mem-cafe-nha-hang
Sydng Softwaregroup

Huongdan inbang

  • 1. sydngsoft.wordpress.com 16 M c l c 1. Th c hi n ch動董ng tr狸nh: ...................................3 2. Ch c nng IN N, NH P LI U ......................3 3. Nh p d li u t Ms EXCELL ..........................4 4. Xu t d li u ra Ms Excel...................................5 5. In B ng t t nghi p, CC......................................6 6. S a m u khi in ...................................................7 7. Tho叩t ch動董ng tr狸nh ...........................................7 8. Ph l c : t o C gi y cho m叩y in Oliveti PR2 15 9. M c l c........................................................... 16 sydngsoft.wordpress.com 1 sydngsoft.wordpress.com Chuy棚n gia trong l挑nh v c ph n m m POS H動 ng d n s d ng Ph n m m in b ng t t nghi p: i h c, cao ng Trung h c chuy棚n nghi p Gi y khen Ch ng ch : thanh tra, gi叩o d c qu c ph嘆ng, Gi叩o d c th ch t, Ch ng ch ngo i ng ,...
  • 2. sydngsoft.wordpress.com 2 Xin c m 董n Qu箪 kh叩ch 達 quan t但m s d ng Ch動董ng tr狸nh. M i g坦p 箪 y棚u c u, x但y d ng, ch nh s a. Ho c c叩c M u bi u kh担ng s n c坦 trong Ch動董ng tr狸nh Qu箪 kh叩ch KHNG NG N NG I g i n ch炭ng t担i qua s m叩y: 0511 370 1857 . Hotline : 0935 800 729 e-mail: sydngsoft@gmail.com website: sydngsoft.wordpress.com sydngsoft.wordpress.com 15 Ph l c: T o C gi y cho M叩y in Olivety PR2 B動 c 1: Start -> Setting -> Printer and Fax B動 c 2 : B m vo bi u t動 ng M叩y in Olivety PR2 B動 c 3 : File -> Server Properties B動 c 4: Nh n tick vo Create New Form , nh p FormName B動 c 5: Nh n OK
  • 3. sydngsoft.wordpress.com 14 3) UPPER(chu i) => t o thnh ch HOA (ch s d ng cho font VNI 4) PROPER(chu i) => t o thnh c但u c坦 ch c叩ch nhau th狸 k鱈 t u l ch HOA (ch s d ng cho font VNI. Gi ng Title Case trong MS WORD. 5) LOWER (chu i) => s thnh c但u ch th動 ng. 6) date2Str(ngy th叩ng nm, D) => cho ra ngy c a d li u ngy th叩ng v i qui t c ngy <10 th狸 th棚m s 0 ph鱈a tr動 c. 7) date2Str(ngy th叩ng nm, M) => cho ra THNG c a d li u ngy th叩ng v i qui t c ngy < 3 th狸 th棚m s 0 ph鱈a tr動 c. V r t nhi u hm kh叩c c坦 th 叩p d ng. 2.11. Tho叩t kh i mn h狸nh: nh n n炭t Tho叩t 3. Tho叩t kh i Ch動董ng tr狸nh: Nh n n炭t Tho叩t Qu鱈 kh叩ch c坦 th y棚n t但m khi s d ng, n u c坦 y棚u c u no v vi c b sung ch動董ng tr狸nh, c叩c t鱈nh nng m i, c p nh t m u m i HO C c叩c y棚u c u ph叩t sinh kh叩c m ch動a c坦 trong h動 ng d n ny. Xin Qu箪 kh叩ch vui l嘆ng : + G i e-mail v : sydngsoft@gmail.com + G i i n tho i n s h tr Duy nh t : 0935 800 729 sydngsoft.wordpress.com 3 1. Th c hi n ch動董ng tr狸nh: Sau khi th c hi n ch動董ng tr狸nh, Mn h狸nh s hi n th nh動 sau: T湛y t ng ch c nng in n, m u bi u, c叩c th担ng tin s kh叩c nhau. Mu n th c hi n ch c nng no , ch c n nh n vo ch c nng 坦. V Nh n TH C HI N. 2. Mn h狸nh ch鱈nh c a c叩c ch c nng nh動 sau: 2.1. N炭t th棚m: Khi nh n n炭t ny, Ch動董ng tr狸nh s cho ph辿p th棚m m i 1 th担ng tin, d湛ng bn ph鱈m nh p li u c叩c th担ng tin t動董ng ng, sau 坦 nh n n炭t L働U l動u th担ng tin l i. 2.2. S a i th担ng tin 達 c坦: Nh n vo danh s叩ch b棚n d動 i, th担ng tin s hi n th l棚n b棚n tr棚n, d湛ng bn ph鱈m nh p s a th担ng tin v nh n n炭t L働U l動u l i. 2.3. N炭t H y l nh: trong tr動 ng h p Th棚m m i hay S a i (m c 2.1 v 2.2) s cho ph辿p v l i Ban u (kh担ng l動u) 2.4. X坦a d li u: x坦a d li u c n nh n n炭t CH N, CH N H T b棚n d動 i, khi c坦 n炭t TICK s 動 c x坦a.
  • 4. sydngsoft.wordpress.com 4 2.5. Nh p d li u t EXCELL: Ch動董ng tr狸nh cho ph辿p nh p danh s叩ch t Ms EXCELL 2002 tr v tr動 c. 2.5.1. th c hi n i u ny , nh n n炭t EXCELL >> 2.5.2. Khi 坦 s hi n th mn h狸nh OPEN Ch炭 箪 : Khi d li u b x坦a th狸 kh担ng kh担i ph c 動 c C叩c file m u 動 c l動u th動 m c DATA Tr棚n thanh ti棚u hi n th T棚n file c n m sydngsoft.wordpress.com 13 M t s HM 動 c s d ng trong khi S a m u bi u: 1) DMY2S(ngy th叩ng) : t o ra ngy th叩ng d ng DD / MM / YYYY N u ngy <10 -> c坦 s 0 ph鱈a tr動 c N u th叩ng < 3 c坦 s 0 ph鱈a tr動 c V鱈 d : DMY2S(2/12/2010) => 02/12/2010 DMY2S(12/2/2010) => 12/02/2010 2.1) ABC2VNI( chu i font ABC) -> Chu i fonts VNI 2.2) ABC2BK2( chu i font ABC) -> Chu i fonts BK HCM 2 H T棚n (1 (1 (2 (2 Ch炭 箪 : xoay ch kh担ng b m t ch 働, (h n ch c a fonts 1 BYTE), ta s d ng hm ABC2VNI (t棚n bi n) dung. + Ph但n bi t FONTS TCVN3, VNI: xem t棚n fonts bi t: TCVN3 (hay c嘆n g i l ABC), t棚n font b t u b ng d u CH M .. VNI : t棚n font b t u b ng ch VNI + i v i FONTS TCVN3, in Ch Hoa ta d湛ng t棚n fonts v i ch H i sau. V鱈 d : fonts .vnTimeH + i v i fonts VNI in ch HOA ta d湛ng hm UPPER(ABC2VNI(t棚n bi n))
  • 5. sydngsoft.wordpress.com 12 Mn h狸nh s a m u in Qui t c: L y i m O lm g c, ch動董ng tr狸nh s xoay i t動 ng 270 theo chi u cao (1) t o thnh (1) , v (2) thnh (2). Nh動 v y, ta c n d ch chuy n lm sao cho Kho ng c叩ch X n 動 ng LINE (d嘆ng s in) 炭ng b ng chi u cao c a i t動 ng. V kho ng c叩ch t u trang gi y n i m O , s l chi u di t B棚n ph i c a d嘆ng LINE n b棚n tr叩i. sydngsoft.wordpress.com 5 2.5.3. Nh n n炭t OPEN m . D li u s 動 c 動a vo danh s叩ch. 2.6. Xu t d li u ra file EXCELL: Trong tr動 ng h p D li u 達 動 c nh p t Ch動董ng tr狸nh, Mu n 動a ra Ms EXCELL s a i b sung cho nhanh ch坦ng. Ta th c hi n c叩c b動 c sau: 2.6.1. Nh n n炭t EXCELL >> Khi 坦 s hi n th c a s SAVE nh動 sau: 2.6.2. G探 t棚n file vo 担 L動u file 1) Ti棚u File DAIHOC.XLS Tr棚n thanh ti棚u hi n th T棚n file c n L動u 2) Ch n 炭ng FILE 3) Nh n OPEN
  • 6. sydngsoft.wordpress.com 6 2.6.3. Nh n SAVE 2.7. Sao l動u d li u: M c 鱈ch nh m chuy n sang m t file kh叩c l動u tr , tr叩nh tr動 ng h p b h ng d li u. 2.8. Ch n, Ch n h t, B , B h t: Nh m ch n / b ch n c叩c H c sinh, h c vi棚n, Sinh vi棚n , C叩n b t danh s叩ch . Th c hi n c叩c t叩c v In CC hay X坦a 2.9. In B ng t t nghi p, ch ng ch : 3 b動 c 2.9.1. Ch n t danh s叩ch b ng ch c nng 2.8 2.9.2. Ch n ch c nng In theo m u ch NGANG , hay m u ch NG. Xem th棚m : http://my.opera.com/sydngsoft/blog http://my.opera.com/sydngsoft/blog/2010/10/01/tai 2.9.3. Nh n In CC Mn h狸nh hi n th m u in xem tr動 c 1) Thanh ti棚u c坦 T棚n file 2) G探 vo T棚n file 3) Nh n Save sydngsoft.wordpress.com 11 2. S a m u v i ch in ng s a m u v i ch ng ch炭ng ta c n xem m担 h狸nh sau: Mn h狸nh xem tr動 c khi in
  • 7. sydngsoft.wordpress.com 10 Canh cho th ng hng C叩c i t動 ng ang ch n! LEFT : tr叩i RIGHT : Ph i TOP : tr棚n nh BOTTOM : d動 i ch但n sydngsoft.wordpress.com 7 2.9.4. Nh n n炭t h狸nh MY IN in ra M叩y in 2.10. S a m u Khi in: nh n n炭t S a m u Ph n m m cung c p m t GIAO DI N H A cho ph辿p s a ch a m u khi in cho ph湛 h p v i kh gi y, l , trang in, kho ng c叩ch c叩c d嘆ng ch鱈nh x叩c n t ng i m nh (PIXEL). 1. t o cho M u In b ng: Report -> properties -> ruler Ch n Ruler & Grid Ch n Metric / Cm (nh動 h狸nh) Nh n OK N炭t in N炭t 坦ng mn h狸nh C叩c n炭t ti n - lui
  • 8. sydngsoft.wordpress.com 8 2. Ch nh cao cho M u In b ng: Nh n S a m u -> 動a tr chu t n d嘆ng Detail cho xu t hi n m滴i t棚n 2 u K辿o xu ng n s 20cm (c坦 s 20 b棚n tr叩i) 3. S a m u v i ch in Ngang TEXT Thanh Detail sydngsoft.wordpress.com 9 D湛ng ph鱈m m滴i t棚n LN XU NG di chuy n. SHIFT + ph鱈m m滴i t棚n m r ng SIZE. CLICK ch n i t動 ng + Nh n ph鱈m SHIFT + click ch n nhi u i t動 ng. Ch n thay i Font Ch