More Related Content
What's hot (16)
Viewers also liked (20)
Similar to 01 modau (20)
![Giao trinh microsoft eccess 2007[bookbooming.com]](https://cdn.slidesharecdn.com/ss_thumbnails/giaotrinhmicrosofteccess2007bookbooming-com-120921152251-phpapp02-thumbnail.jpg?width=560&fit=bounds)
Recently uploaded (20)
01 modau
- 1. Access 2000
- 2. M? ??u
- 3. Khoa C?ng ngh? th?ng tin - Access 2000 3 3/18/2022 1.1 M?t s? v¨ª d? v? b¨¤i to¨¢n qu?n l? 1.1.1 Qu?n l? Nh?n s?. - Th?ng tin l? l?ch c¨¢ nh?n c?a nh?n s?. - Qu¨¢ tr¨¬nh c?ng t¨¢c. - Qu¨¢ tr¨¬nh l??ng c?a nh?n s?. - Theo d?i khen th??ng, k? lu?t ??i v?i nh?n s?. - C¨¢c m?i quan h? x? h?i. - C?ng t¨¢c quy ho?ch c¨¢n b?. - C¨¢c b¨¢o c¨¢o th?ng k¨º v? nh?n s?.
- 4. Khoa C?ng ngh? th?ng tin - Access 2000 4 3/18/2022 1.1 M?t s? v¨ª d? v? b¨¤i to¨¢n qu?n l? 1.1.2 Qu?n l? Th? vi?n - Ngu?n t¨¤i li?u. - Th?ng tin v? ??c gi?. - Theo d?i qu¨¢ tr¨¬nh m??n tr? t¨¤i li?u. - Qu?n l? th?ng tin v? c¨¢c ??c gi? thu?c ¡°Danh s¨¢ch ?en¡± - Qu?n l? c¨¢c t¨¤i li?u m??n qu¨¢ h?n, b? m?t, h?ng. - Th?ng tin v? s¨¢ch m?i. - C¨¢c th?ng k¨º v? ??c gi?, s¨¢ch.
- 5. Khoa C?ng ngh? th?ng tin - Access 2000 5 3/18/2022 1.1 M?t s? v¨ª d? v? b¨¤i to¨¢n qu?n l? 1.1.3 Qu?n l? sinh vi¨ºn - L? l?ch sinh vi¨ºn. - C¨¢c th?ng tin ?¨¤o t?o. - B?ng ?i?m sinh vi¨ºn. - H?c b? sinh vi¨ºn. - C¨¢c b¨¢o c¨¢o th?ng k¨º, b?ng ?i?m h?c k?, b?ng ?i?m t?t nghi?p, v.v...
- 6. Khoa C?ng ngh? th?ng tin - Access 2000 6 3/18/2022 1.1 M?t s? v¨ª d? v? b¨¤i to¨¢n qu?n l? Y¨ºu c?u: - C?u tr¨²c l?u tr? ???c thi?t k? sao cho chi?m ¨ªt kh?ng gian l?u tr?. - Vi?c t¨¬m ki?m c¨¢c th?ng tin ???c th?c hi?n m?t c¨¢ch nhanh ch¨®ng. - Cung c?p c¨¢c giao di?n cho ng??i s? d?ng ?? an to¨¤n, thu?n l?i cho vi?c th¨ºm, b?t hay c?p nh?t th?ng tin. - C¨® c? ch? b?o v? an to¨¤n d? li?u l?u tr?.
- 7. Khoa C?ng ngh? th?ng tin - Access 2000 7 3/18/2022 1.2 C¨¢c kh¨¢i ni?m - C? s? d? li?u: t?p h?p c¨¢c b?n ghi v¨¤ c¨¢c t?p ???c t? ch?c cho m?t m?c ?¨ªch c? th?. - C? s? d? li?u quan h?: m?i b?n ghi trong c? s? d? li?u ch?a c¨¢c th?ng tin li¨ºn quan ??n m?t ch? th? duy nh?t. - H? qu?n tr? c? s? d? li?u: t?p h?p c¨¢c ch??ng tr¨¬nh h? tr? vi?c thi?t k?, l?u tr? v¨¤ b?o v? c? s? d? li?u. C¨¢c ki?u H? qu?n tr? c? s? d? li?u: Foxpro, Access, SQL, Infomix, Oracle,... - H? qu?n tr? c? s? d? li?u quan h?: c¨¢c d? li?u ???c qu?n l? theo c¨¢c b?ng, m?i c?t c?a b?ng l?u m?t th?ng tin c?a ch? th?, m?i h¨¤ng ch?a th?ng tin c¨¢c v? m?t ch? th? ??n l?.
- 8. Khoa C?ng ngh? th?ng tin - Access 2000 8 3/18/2022 1.2 C¨¢c kh¨¢i ni?m - Microsoft Access l¨¤ HQT CSDL tr¨ºn m?i tr??ng Windows, c¨® c¨¢c c?ng c? h?u hi?u v¨¤ ti?n l?i ?? t? ??ng s?n sinh ch??ng tr¨¬nh cho h?u h?t c¨¢c b¨¤i to¨¢n th??ng g?p trong qu?n l?, th?ng k¨º, k? to¨¢n. V?i Access, ng??i d¨´ng kh?ng ph?i vi?t t?ng c?u l?nh c? th? m¨¤ ch? c?n t? ch?c d? li?u v¨¤ thi?t k? c¨¢c y¨ºu c?u c?n gi?i quy?t. Access ???c s? d?ng r?ng r?i trong tr??ng h?p CSDL v?a v¨¤ nh?. Access 2000 l¨¤ m?t trong c¨¢c phi¨ºn b?n c?a Access.
- 9. Khoa C?ng ngh? th?ng tin - Access 2000 9 3/18/2022 1.3 ??c ?i?m c?a MS Access Access qu?n l? 6 ??i t??ng: - Table (B?ng) - Query (Truy v?n) - Form (M?u bi?u) - Report (B¨¢o c¨¢o) - Macro (Chu?i l?nh) - Module
- 10. Khoa C?ng ngh? th?ng tin - Access 2000 10 3/18/2022 1.3 ??c ?i?m c?a MS Access 1.3.1 Table (B?ng): - ???c d¨´ng ?? l?u tr? d? li?u c?a c? s? d? li?u. - M?t CSDL g?m nhi?u b?ng c¨® quan h? v?i nhau.
- 11. Khoa C?ng ngh? th?ng tin - Access 2000 11 3/18/2022 1.3 ??c ?i?m c?a MS Access 1.3.2 Query (Truy v?n): - D¨´ng ?? t?ng h?p, s?p x?p, t¨¬m ki?m d? li?u tr¨ºn c¨¢c b?ng. - K?t qu? c?a truy v?n l¨¤ t?p h?p k?t qu? th? hi?n d??i d?ng b?ng g?i l¨¤ Dynaset.
- 12. Khoa C?ng ngh? th?ng tin - Access 2000 12 3/18/2022 1.3 ??c ?i?m c?a MS Access 1.3.3 Form (M?u bi?u): - D¨´ng ?? nh?p d? li?u cho c¨¢c b?ng v¨¤ thi?t k? giao di?n ch??ng tr¨¬nh. - M?u bi?u cung c?p nhi?u kh? n?ng nh?p li?u ti?n l?i nh?: nh?n d? li?u t? m?t danh s¨¢ch, nh?n c¨¢c h¨¬nh ?nh, nh?p d? li?u ??ng th?i tr¨ºn nhi?u b?ng. - M?u bi?u cho ph¨¦p nh?p c¨¢c gi¨¢ tr? ri¨ºng l? t? b¨¤n ph¨ªm. - M?u bi?u c¨® kh? n?ng t? ch?c giao di?n ch??ng tr¨¬nh d??i d?ng b?ng n¨²t l?nh ho?c m?t h? th?ng menu.
- 13. Khoa C?ng ngh? th?ng tin - Access 2000 13 3/18/2022 1.3 ??c ?i?m c?a MS Access 1.3.4 Reprot (B¨¢o bi?u): - In d? li?u d??i d?ng b?ng, bi?u. - S?p x?p d? li?u tr??c khi in. - Ph?n nh¨®m d? li?u t?i 10 c?p. Cho ph¨¦p th?c hi?n c¨¢c ph¨¦p to¨¢n ?? nh?n d? li?u t?ng h?p tr¨ºn m?i nh¨®m. - In d? li?u c?a nhi?u b?ng c¨® quan h? tr¨ºn m?t b¨¢o c¨¢o. - Vi?c ch?n Font ch?, c? ch?, ki?u in v¨¤ vi?c tr¨¬nh b?y tr¨ºn b¨¢o c¨¢o ???c ti?n h¨¤nh ??n gi?n.
- 14. Khoa C?ng ngh? th?ng tin - Access 2000 14 3/18/2022 1.3 ??c ?i?m c?a MS Access 1.3.5 Macro (chu?i l?nh): - G?m m?t d?y c¨¢c h¨¤nh ??ng d¨´ng ?? t? ??ng ho¨¢ m?t lo?t c¨¢c thao t¨¢c. - Macro th??ng d¨´ng v?i m?u bi?u ?? t? ch?c giao di?n ch??ng tr¨¬nh.
- 15. Khoa C?ng ngh? th?ng tin - Access 2000 15 3/18/2022 1.3 ??c ?i?m c?a MS Access 1.3.6 Module: - L¨¤ n?i ch?a c¨¢c h¨¤m, th? t?c vi?t b?ng ng?n ng? Access Basic. - C¨¢c h¨¤m, th? t?c c?a Access Basic s? tr? gi¨²p gi?i quy?t nh?ng ph?n vi?c kh¨® m¨¤ c?ng c? Access kh?ng l¨¤m ???c.
- 16. Khoa C?ng ngh? th?ng tin - Access 2000 16 3/18/2022 1.3 ??c ?i?m c?a MS Access M?t s? thu?t ng? th??ng d¨´ng: - ??i t??ng (Object): m?t trong c¨¢c th¨¤nh ph?n c? b?n c?a CSDL (m?t b?ng, m?t bi?u m?u hay m?t b¨¢o c¨¢o).
- 17. Khoa C?ng ngh? th?ng tin - Access 2000 17 3/18/2022 1.3 ??c ?i?m c?a MS Access M?t s? thu?t ng? th??ng d¨´ng: - B?ng (Table): M?t nh¨®m c¨¢c d? li?u c¨® li¨ºn quan ???c t? ch?c d??i d?ng c¨¢c h¨¤ng v¨¤ c?t. - Tr??ng (Field): M?t c?t thu?c m?t b?ng. M?i tr??ng quy ??nh m?t ki?u d? li?u cho c¨¢c gi¨¢ tr? thu?c tr??ng ?¨®. - B?n ghi (Record): M?t h¨¤ng thu?c b?ng. M?i b?n ghi l¨¤ t?p h?p c¨¢c gi¨¢ tr? trong c¨¢c tr??ng c?a b?ng.
- 18. Khoa C?ng ngh? th?ng tin - Access 2000 18 3/18/2022 1.3 ??c ?i?m c?a MS Access M?t s? thu?t ng? th??ng d¨´ng: Field Record Table
- 19. Khoa C?ng ngh? th?ng tin - Access 2000 19 3/18/2022 1.3 ??c ?i?m c?a MS Access M?t s? thu?t ng? th??ng d¨´ng: - C?a s? thi?t k? (Design View): C?ng c? d¨´ng ?? thi?t k? c?u tr¨²c c?a c¨¢c ??i t??ng. - C?a s? d? li?u (Datasheet View): C?ng c? d¨´ng ?? c?p nh?t, s?a ho?c xo¨¢ d? li?u t? m?t b?ng.
- 20. Khoa C?ng ngh? th?ng tin - Access 2000 20 3/18/2022 1.3 ??c ?i?m c?a MS Access Design View
- 21. Khoa C?ng ngh? th?ng tin - Access 2000 21 3/18/2022 1.3 ??c ?i?m c?a MS Access Datasheet View
- 22. Khoa C?ng ngh? th?ng tin - Access 2000 22 3/18/2022 1.4 Kh?i ??ng Access - Start|Programs|Microsoft Access
- 23. Khoa C?ng ngh? th?ng tin - Access 2000 23 3/18/2022 1.4 Kh?i ??ng Access Blank Access database (c? s? d? li?u m?i): - Ch? ??nh t¨ºn c? s? d? li?u v¨¤ n?i l?u tr? tr¨ºn m¨¢y - Nh?n n¨²t Create. Th? m?c l?u t?p CSDL T¨ºn c? s? d? li?u
- 24. Khoa C?ng ngh? th?ng tin - Access 2000 24 3/18/2022 1.4 Kh?i ??ng Access Access database wizards, pages, and projects: Ch?c n?ng tr? gi¨²p th?ng minh c?a Access. - L?a ch?n m?t ki?u c? s? d? li?u v¨¤ nh?n OK. C¨¢c ki?u CSDL c¨® s?n
- 25. Khoa C?ng ngh? th?ng tin - Access 2000 25 3/18/2022 1.4 Kh?i ??ng Access Open an existing file: M? c? s? d? li?u hi?n c¨® - Ch?n t¨ºn c? s? d? li?u c?n m? v¨¤ nh?n OK. - Tr??ng h?p m? l?n ??u ti¨ºn: Ch?n "More Files..." v¨¤ nh?n OK. - Trong c?a s? ti?p theo nh?n "Look In:" ?? t¨¬m th? m?c n?i ch?a c? s? d? li?u, ch?n t¨ºn c? s? d? li?u v¨¤ nh?n OK.
- 26. Khoa C?ng ngh? th?ng tin - Access 2000 26 3/18/2022 1.5 Gi?i thi?u m¨¤n h¨¬nh l¨¤m vi?c 1.5.1 Database Window: C?a s? c? s? d? li?u C?a s? c? s? d? li?u ch?a to¨¤n b? c¨¢c ??i t??ng trong CSDL.
- 27. Khoa C?ng ngh? th?ng tin - Access 2000 27 3/18/2022 1.5 Gi?i thi?u m¨¤n h¨¬nh l¨¤m vi?c 1.5.1 Database Window: C?a s? c? s? d? li?u - Menu bar: C¨¢c menu ch?c n?ng c?a ch??ng tr¨¬nh. - Office linhks: T? ??ng xu?t d? li?u sang c¨¢c ?ng d?ng office (Word, Excel) - Properties: B?ng c¨¢c thu?c t¨ªnh c?a c¨¢c th¨¤nh ph?n thu?c ??i t??ng. - Relationships: Hi?n th? c?a s? qu?n l? c¨¢c m?i quan h? gi?a c¨¢c b?ng. - New Object: T?o m?i m?t ??i t??ng (B?ng, truy v?n, form, report...)
- 28. Khoa C?ng ngh? th?ng tin - Access 2000 28 3/18/2022 1.5 Gi?i thi?u m¨¤n h¨¬nh l¨¤m vi?c 1.5.2 Design View: C?a s? thi?t k? C?a s? thi?t k? ???c s? d?ng ?? thi?t k? c¨¢c tr??ng trong CSDL.
- 29. Khoa C?ng ngh? th?ng tin - Access 2000 29 3/18/2022 1.5 Gi?i thi?u m¨¤n h¨¬nh l¨¤m vi?c 1.5.2 Design View: C?a s? thi?t k? - Design/Datasheet view toggle: Chuy?n ??i qua l?i gi?a c¨¢c ch? ?? thi?t k? v¨¤ nh?p d? li?u. -Primary key: Quy ??nh thu?c t¨ªnh kho¨¢ ch¨ªnh cho tr??ng. - Insert/Delete rows: Th¨ºm, b?t tr??ng. - Properties: B?ng c¨¢c thu?c t¨ªnh c?a c¨¢c th¨¤nh ph?n thu?c ??i t??ng. - Field Builder: Tr? gi¨²p vi?c thi?t k? tr??ng. - Database window: Chuy?n v? c?a s? c? s? d? li?u. - New Object: T?o m?i m?t ??i t??ng (B?ng, truy v?n, form, report...).
- 30. Khoa C?ng ngh? th?ng tin - Access 2000 30 3/18/2022 1.5 Gi?i thi?u m¨¤n h¨¬nh l¨¤m vi?c 1.5.3 Datasheet View: C?a s? nh?p d? li?u C?a s? nh?p d? li?u cho ph¨¦p nh?p d? li?u v¨¤o c? s? d? li?u.
- 31. Khoa C?ng ngh? th?ng tin - Access 2000 31 3/18/2022 1.5 Gi?i thi?u m¨¤n h¨¬nh l¨¤m vi?c 1.5.3 Datasheet View: C?a s? nh?p d? li?u - Record selector: ?¨¢nh d?u c¨¢c b?n ghi ???c ch?n. - Sort Ascending / Sort Descending: S?p x?p t?ng/gi?m d?n. - Filter by selection/ Filter by form: C¨¢c ch? ?? l?c d? li?u. - Apply filter: Th?c hi?n l?nh l?c. - Find: T¨¬m ki?m. - New record: Th¨ºm b?n ghi m?i. - Delete record: Xo¨¢ b?n ghi. - Database window: Chuy?n v? c?a s? c? s? d? li?u. - New Object: T?o m?i m?t ??i t??ng (B?ng, truy v?n, form, report...).
- 32. Khoa C?ng ngh? th?ng tin - Access 2000 32 3/18/2022 1.6 Chuy?n ??i v? ki?u c? s? d? li?u Access 2000 - Tools|Database Utilities|Convert Database|To Current Access Database Version. - Ch?n c? s? d? li?u c?n chuy?n ??i v¨¤ nh?n n¨²t Convert. - ??t t¨ºn cho t?p c? s? d? li?u m?i.
- 33. C¨°n ti?p...