SETEC University
Management Information System
Table of Contents Chapter 1 ............................................................................................................................................. 1 Introduction to MS-Access 2007......................................................................................................... 1 1.1. របបៀបបបើកកម្មវ ិធី MS-Access 2007: ................................................................................... 1 1.2.
របបៀបបិទកម្មវ ិធី MS-Access 2007 ...................................................................................... 3
1.3.
របបៀបបប្កើត Database ថ្មី ..................................................................................................... 3
1.4. របបៀបបបើក Database ដែលមានស្រាប់ ................................................................................ 5 Chapter 2 ............................................................................................................................................. 6 Creating and Using Table .................................................................................................................... 6 2.1. របបៀបបប្កើត Table ថ្មីែំបូ្.................................................................................................. 6 2.2.
របបៀបបប្កើត Table ថ្មីបដនែម្ ................................................................................................ 7
2.3.
របបៀបបប្កើត Table ថ្មីបដនែម្ បោយប្បើ Table Templates................................................... 7
2.4.
របបៀបបដនែម្ Field/Column ចូ លកនុ្ Table ......................................................................... 7
2.5. 2.6. 2.7. 2.8. 2.9.
របបៀបបដនែម្ Field/Column ចូ លកនុ្ Table បោយប្បើ Field Templates ............................ 7 របបៀបបដនែម្ Field/Column ពី Table បផេ្បទៀតកនុ្ Datasheet View: ............................... 8 របបៀបលប់ Field/Column បចញពី Table កនុ្ Datasheet View ............................................ 8 របបៀបបប្កើត Table កនុ្ Design View.................................................................................. 9 Primary Key: ...................................................................................................................... 14
2.10. Import Table: ...................................................................................................................... 14 2.11. Export Tables ..................................................................................................................... 21 2.12. ភ្ជាប់បៅកាន់ Table (Link Table): ...................................................................................... 22 2.13. បប្កើត Lookup Wizard ....................................................................................................... 24 2.14. Relationships: ..................................................................................................................... 30 2.15. ការកំនត់ោក់ Password: .................................................................................................... 33 Chapter 3 ........................................................................................................................................... 36 Creating and Using Query ................................................................................................................. 36 3.1. បប្កើត Select Query បោយប្បើ wizard: ............................................................................. 37 3.2.
របបៀប Run query: .............................................................................................................. 39
3.3.
បប្កើត Select Query កនុ្ Design View:. ............................................................................ 40
3.4.
ការ Backup Database ទុក: ................................................................................................. 50
3.5.
បប្កើត Delete Query: .......................................................................................................... 51
3.6.
បប្កើត Update Query: ......................................................................................................... 53
3.7.
បប្កើត Append Query:........................................................................................................ 55
3.8.
បប្កើត Make-table Query: .................................................................................................. 57
3.9.
បប្កើត Parameter Query: .................................................................................................... 60
3.10. បប្កើត Crosstab Query: ...................................................................................................... 62 3.11. Structure Query Language (SQL): ..................................................................................... 67 Table of Contents
I