ºÝºÝߣ

ºÝºÝߣShare a Scribd company logo

B¨¤i 6: Bi?u m?u

?Download as PPTX, PDF?
?
C
Ch?u Tr?n
1 of 29
B¨¤i 6:
KH?I NI?M BI?U M?U T?O BI?U M?U M?I CH? ?? L?M VI?C V?I BI?U M?U C?NG C?
1. KH?I NI?M BI?U M?U Em h?y so s¨¢nh s? kh¨¢c nhau gi?a 2 c¨¢ch hi?n th?? Home
1. KH?I NI?M BI?U M?U - Bi?u m?u l¨¤ m?t lo?i ??i t??ng trong c? s? d? li?u Access, ???c thi?t k? ?? : u. nh (do ng??i thi?t k? t?o ra). Home
1. KH?I NI?M BI?U M?U ? Bi?u m?u c¨® th? nh?p v¨¤ hi?n th? d? li?u cho c¨¢c tr??ng t? nhi?u b?ng. ? ?? nh?p d? li?u cho m?t b?ng c¨® th? t?o nhi?u bi?u m?u kh¨¢c nhau ph?c v? cho c¨¢c nh¨®m ng??i d¨´ng c¨® quy?n h?n kh¨¢c nhau. Home
2. T?O BI?U M?U M?I ng Forms Create form in Design view Click Forms Create form by Using Wirard Home
2. T?O BI?U M?U M?I u m?i c¨® 2 c¨¢ch: + C¨¢ch 1: Create form in Design view (t? thi?t k?). + C¨¢ch 2: Create form by Using Wizard (D¨´ng thu?t s?) Home
2. T?O BI?U M?U M?I C¨¢c b??c t?o bi?u m?u b?ng c¨¢ch d¨´ng thu?t s?: ? B1: Nh¨¢y ?¨²p v¨¤o Create Form by using Wizard. ? B2: Trong h?p tho?i Form Wizard, nh¨¢y m?i t¨ºn ch? xu?ng trong m?c Tables/Queries ?? ch?n b?ng. Nh¨¢y n¨²t m?i t¨ºn qua l?i ?? chuy?n tr??ng ho?c c¨¢c tr??ng, r?i nh¨¢y Next. ? B3: Trong c¨¢c m¨¤n h¨¬nh ti?p theo ch?n d?ng v¨¤ ki?u cho bi?u m?u. ? B4: G? t¨ºn bi?u m?u. C¨® th? ch?n Open the from to view or enter information ?? xem ho?c nh?p d? li?u ho?c ch?n Modify the from¡¯s design ?? s?a ??i thi?t k? m?u. Cu?i c¨´ng nh¨¢y n¨²t Finish ?? k?t th¨²c.
2. T?O BI?U M?U M?I * T?o bi?u m?u d¨´ng thu?t s?. + B??c 1: Nh¨¢y ?¨²p Create form by Using Wizard xu?t hi?n h?p tho?i Form Wizard Home
2. T?O BI?U M?U M?I + B??c 2: Trong h?p tho?i Form Wizard ta x¨¢c ??nh: - Tables/Queries: ta ch?n b?ng ( bi?u m?u. - Available Fields: ta ch?n c¨¢c tr??ng c?n ??a o bi?u m?u. Home c u i) c?n t?o
2. T?O BI?U M?U M?I + B??c 2: Trong h?p tho?i Form Wizard ta x¨¢c ??nh: - Tables/Queries: ta ch?n b?ng ( bi?u m?u. - Available Fields: ta ch?n c¨¢c tr??ng c?n ??a o bi?u m?u. - Selected Fields: c¨¢c tr??ng ?? ???c l?a ch?n hi?n th? trong bi?u m?u. c Click Next - Ch?n Next Home u i) c?n t?o
2. T?O BI?U M?U M?I + B??c 3: Ch?n c¨¢ch b? tr¨ª bi?u m?u (Form Layout). D?ng c?t (Columnar) D?ng trang d? li?u (Datasheet) D?ng b?ng bi?u (Tabular) D?ng canh ??u (Justified) D?ng b?ng ??ng (PivotTable) D?ng ?? th? (PivotChart) Click Next - Ch?n Next Home
2. T?O BI?U M?U M?I + B??c 4: Ch?n ki?u c?a bi?u m?u (Form Style). Click Next - Ch?n Next Home
2. T?O BI?U M?U M?I + B??c 5: L?u bi?u m?u. Nh?p t¨ºn bi?u m?u v?a t?o Click ch?n ?? xem ho?c nh?p d? li?u Click ch?n ?? s?a thi?t k? bi?u m?u - Ch?n Finish ?? k?t th¨²c t?o bi?u m?u b?ng Wizard Click Finish Home
2. T?O BI?U M?U M?I ?? ch?nh s?a bi?u m?u ta ph?i l¨¤m nh? th? n¨¤o? Home
2. T?O BI?U M?U M?I * Ch?nh s?a bi?u m?u trong ch? ?? thi?t k?. - Ta ch?n v¨¤o n¨²t l?nh Design Home
2. T?O BI?U M?U M?I * Ch?nh s?a bi?u m?u trong ch? ?? thi?t k?. - Ta ch?n v¨¤o n¨²t l?nh Design Khi bi?u m?u ? ch? ?? thi?t k? ta c¨® th? th?c hi?n nh?ng vi?c sau: + Thay ??i n?i dung c¨¢c ti¨ºu ??. + S? d?ng ph?ng ch? ti?ng vi?t. + Thay ??i k¨ªch th??c c?a tr??ng. + Di chuy?n c¨¢c tr??ng. Home
2. T?O BI?U M?U M?I * Ch?nh s?a bi?u m?u trong ch? ?? thi?t k?. - Ta ch?n v¨¤o n¨²t l?nh Design Home
3. C?C CH? ?? L?M VI?C V?I BI?U M?U Ch? ?? bi?u m?u (xem) (Form View) Ch? ?? thi?t k? (ch?nh s?a) (Design View) Home
3. C?C CH? ?? L?M VI?C V?I BI?U M?U Ch? ?? bi?u m?u ? Cho ph¨¦p th?c hi?n c¨¢c thao t¨¢c: ? T¨¬m ki?m. ? L?c. ? S?p x?p th?ng tin gi?ng nh? l¨¤m vi?c v?i b?ng. Ch? ?? thi?t k? ? Khi bi?u m?u ? ch? ?? thi?t k? ta c¨® th? th?c hi?n nh?ng vi?c sau: ? Thay ??i n?i dung c¨¢c ti¨ºu ??. ? S? d?ng ph?ng ch? ti?ng vi?t. ? Thay ??i k¨ªch th??c c?a tr??ng. ? Di chuy?n c¨¢c tr??ng.
3. C?C CH? ?? L?M VI?C V?I BI?U M?U * Ch? ?? bi?u m?u (Form View) - C¨¢ch 1: Nh¨¢y ?¨²p chu?t tr¨¢i l¨ºn t¨ºn c?a bi?u m?u. - C¨¢ch 2: Ch?n bi?u m?u r?i nh¨¢y v¨¤o Open. Home
3. C?C CH? ?? L?M VI?C V?I BI?U M?U * Ch? ?? bi?u m?u (Form View) - C¨¢ch 3: Nh¨¢y v¨¤o Form View (n?u ?ang ? ch? ?? thi?t k?) Home
3. C?C CH? ?? L?M VI?C V?I BI?U M?U * Ch? ?? thi?t k? (Dessign View) - C¨¢ch 1: Ch?n t¨ºn bi?u m?u r?i nh¨¢y v¨¤o Design Home
3. C?C CH? ?? L?M VI?C V?I BI?U M?U * Ch? ?? thi?t k? (Dessign View) - C¨¢ch 2: Nh¨¢y v¨¤o n¨²t Design (n?u ?ang ? ch? ?? bi?u m?u) Home
4. C?NG C? c b?n h?y tr? l?i c¨¢c c?u h?i sau. C?u 1: Cho a ch¨º ?? t k¨º a Home t s? c nhau u u v¨¤ ch¨º ?? u u?
N C?u 1: Ch¨º ?? u u - Xem, a, th¨ºm n ghi, chu u p d? u. Ch¨º ?? - t k¨º o, a u c u u: n ng, thay i ch c ng. - o ng ?¨º c n s? thao c. t nh c t
C?u 2: y p p th? t? c thao c sau ?¨º th¨º o u u ng t si: n Finish. n Next. o Create form by using wizard . n Next. n Next. u
N ?¨¢p ¨¢n: 3 ¨C 5 ¨C 2 ¨C 4 ¨C 6 - 1
B¨¤i 6: Bi?u m?u

More Related Content

B¨¤i 6: Bi?u m?u

  • 2. KH?I NI?M BI?U M?U T?O BI?U M?U M?I CH? ?? L?M VI?C V?I BI?U M?U C?NG C?
  • 3. 1. KH?I NI?M BI?U M?U Em h?y so s¨¢nh s? kh¨¢c nhau gi?a 2 c¨¢ch hi?n th?? Home
  • 4. 1. KH?I NI?M BI?U M?U - Bi?u m?u l¨¤ m?t lo?i ??i t??ng trong c? s? d? li?u Access, ???c thi?t k? ?? : u. nh (do ng??i thi?t k? t?o ra). Home
  • 5. 1. KH?I NI?M BI?U M?U ? Bi?u m?u c¨® th? nh?p v¨¤ hi?n th? d? li?u cho c¨¢c tr??ng t? nhi?u b?ng. ? ?? nh?p d? li?u cho m?t b?ng c¨® th? t?o nhi?u bi?u m?u kh¨¢c nhau ph?c v? cho c¨¢c nh¨®m ng??i d¨´ng c¨® quy?n h?n kh¨¢c nhau. Home
  • 6. 2. T?O BI?U M?U M?I ng Forms Create form in Design view Click Forms Create form by Using Wirard Home
  • 7. 2. T?O BI?U M?U M?I u m?i c¨® 2 c¨¢ch: + C¨¢ch 1: Create form in Design view (t? thi?t k?). + C¨¢ch 2: Create form by Using Wizard (D¨´ng thu?t s?) Home
  • 8. 2. T?O BI?U M?U M?I C¨¢c b??c t?o bi?u m?u b?ng c¨¢ch d¨´ng thu?t s?: ? B1: Nh¨¢y ?¨²p v¨¤o Create Form by using Wizard. ? B2: Trong h?p tho?i Form Wizard, nh¨¢y m?i t¨ºn ch? xu?ng trong m?c Tables/Queries ?? ch?n b?ng. Nh¨¢y n¨²t m?i t¨ºn qua l?i ?? chuy?n tr??ng ho?c c¨¢c tr??ng, r?i nh¨¢y Next. ? B3: Trong c¨¢c m¨¤n h¨¬nh ti?p theo ch?n d?ng v¨¤ ki?u cho bi?u m?u. ? B4: G? t¨ºn bi?u m?u. C¨® th? ch?n Open the from to view or enter information ?? xem ho?c nh?p d? li?u ho?c ch?n Modify the from¡¯s design ?? s?a ??i thi?t k? m?u. Cu?i c¨´ng nh¨¢y n¨²t Finish ?? k?t th¨²c.
  • 9. 2. T?O BI?U M?U M?I * T?o bi?u m?u d¨´ng thu?t s?. + B??c 1: Nh¨¢y ?¨²p Create form by Using Wizard xu?t hi?n h?p tho?i Form Wizard Home
  • 10. 2. T?O BI?U M?U M?I + B??c 2: Trong h?p tho?i Form Wizard ta x¨¢c ??nh: - Tables/Queries: ta ch?n b?ng ( bi?u m?u. - Available Fields: ta ch?n c¨¢c tr??ng c?n ??a o bi?u m?u. Home c u i) c?n t?o
  • 11. 2. T?O BI?U M?U M?I + B??c 2: Trong h?p tho?i Form Wizard ta x¨¢c ??nh: - Tables/Queries: ta ch?n b?ng ( bi?u m?u. - Available Fields: ta ch?n c¨¢c tr??ng c?n ??a o bi?u m?u. - Selected Fields: c¨¢c tr??ng ?? ???c l?a ch?n hi?n th? trong bi?u m?u. c Click Next - Ch?n Next Home u i) c?n t?o
  • 12. 2. T?O BI?U M?U M?I + B??c 3: Ch?n c¨¢ch b? tr¨ª bi?u m?u (Form Layout). D?ng c?t (Columnar) D?ng trang d? li?u (Datasheet) D?ng b?ng bi?u (Tabular) D?ng canh ??u (Justified) D?ng b?ng ??ng (PivotTable) D?ng ?? th? (PivotChart) Click Next - Ch?n Next Home
  • 13. 2. T?O BI?U M?U M?I + B??c 4: Ch?n ki?u c?a bi?u m?u (Form Style). Click Next - Ch?n Next Home
  • 14. 2. T?O BI?U M?U M?I + B??c 5: L?u bi?u m?u. Nh?p t¨ºn bi?u m?u v?a t?o Click ch?n ?? xem ho?c nh?p d? li?u Click ch?n ?? s?a thi?t k? bi?u m?u - Ch?n Finish ?? k?t th¨²c t?o bi?u m?u b?ng Wizard Click Finish Home
  • 15. 2. T?O BI?U M?U M?I ?? ch?nh s?a bi?u m?u ta ph?i l¨¤m nh? th? n¨¤o? Home
  • 16. 2. T?O BI?U M?U M?I * Ch?nh s?a bi?u m?u trong ch? ?? thi?t k?. - Ta ch?n v¨¤o n¨²t l?nh Design Home
  • 17. 2. T?O BI?U M?U M?I * Ch?nh s?a bi?u m?u trong ch? ?? thi?t k?. - Ta ch?n v¨¤o n¨²t l?nh Design Khi bi?u m?u ? ch? ?? thi?t k? ta c¨® th? th?c hi?n nh?ng vi?c sau: + Thay ??i n?i dung c¨¢c ti¨ºu ??. + S? d?ng ph?ng ch? ti?ng vi?t. + Thay ??i k¨ªch th??c c?a tr??ng. + Di chuy?n c¨¢c tr??ng. Home
  • 18. 2. T?O BI?U M?U M?I * Ch?nh s?a bi?u m?u trong ch? ?? thi?t k?. - Ta ch?n v¨¤o n¨²t l?nh Design Home
  • 19. 3. C?C CH? ?? L?M VI?C V?I BI?U M?U Ch? ?? bi?u m?u (xem) (Form View) Ch? ?? thi?t k? (ch?nh s?a) (Design View) Home
  • 20. 3. C?C CH? ?? L?M VI?C V?I BI?U M?U Ch? ?? bi?u m?u ? Cho ph¨¦p th?c hi?n c¨¢c thao t¨¢c: ? T¨¬m ki?m. ? L?c. ? S?p x?p th?ng tin gi?ng nh? l¨¤m vi?c v?i b?ng. Ch? ?? thi?t k? ? Khi bi?u m?u ? ch? ?? thi?t k? ta c¨® th? th?c hi?n nh?ng vi?c sau: ? Thay ??i n?i dung c¨¢c ti¨ºu ??. ? S? d?ng ph?ng ch? ti?ng vi?t. ? Thay ??i k¨ªch th??c c?a tr??ng. ? Di chuy?n c¨¢c tr??ng.
  • 21. 3. C?C CH? ?? L?M VI?C V?I BI?U M?U * Ch? ?? bi?u m?u (Form View) - C¨¢ch 1: Nh¨¢y ?¨²p chu?t tr¨¢i l¨ºn t¨ºn c?a bi?u m?u. - C¨¢ch 2: Ch?n bi?u m?u r?i nh¨¢y v¨¤o Open. Home
  • 22. 3. C?C CH? ?? L?M VI?C V?I BI?U M?U * Ch? ?? bi?u m?u (Form View) - C¨¢ch 3: Nh¨¢y v¨¤o Form View (n?u ?ang ? ch? ?? thi?t k?) Home
  • 23. 3. C?C CH? ?? L?M VI?C V?I BI?U M?U * Ch? ?? thi?t k? (Dessign View) - C¨¢ch 1: Ch?n t¨ºn bi?u m?u r?i nh¨¢y v¨¤o Design Home
  • 24. 3. C?C CH? ?? L?M VI?C V?I BI?U M?U * Ch? ?? thi?t k? (Dessign View) - C¨¢ch 2: Nh¨¢y v¨¤o n¨²t Design (n?u ?ang ? ch? ?? bi?u m?u) Home
  • 25. 4. C?NG C? c b?n h?y tr? l?i c¨¢c c?u h?i sau. C?u 1: Cho a ch¨º ?? t k¨º a Home t s? c nhau u u v¨¤ ch¨º ?? u u?
  • 26. N C?u 1: Ch¨º ?? u u - Xem, a, th¨ºm n ghi, chu u p d? u. Ch¨º ?? - t k¨º o, a u c u u: n ng, thay i ch c ng. - o ng ?¨º c n s? thao c. t nh c t
  • 27. C?u 2: y p p th? t? c thao c sau ?¨º th¨º o u u ng t si: n Finish. n Next. o Create form by using wizard . n Next. n Next. u
  • 28. N ?¨¢p ¨¢n: 3 ¨C 5 ¨C 2 ¨C 4 ¨C 6 - 1