Kursus ini direka untuk peserta yang ingin memahami pengunaan Microsof Access. Peserta bakal membina dan menyunting pengkalan data baru, membina dan menyunting tables serta reports. Selain itu peserta juga akan belajar membina form dan queries.
Objektif Kursus
- Mengetahui kegunaan, antaramuka dan ciri-ciri MS Access
- Membina dan merancang pengkalan data
- Mengendalikan data di dalam Table
- Membuat Form dan Queries
- Menghasilkan Reports dari pengkalan data
Kumpulan Sasar
- Pereka dan pembangun aplikasi
- Pengaturcara atau penyelengara data dan rekod
- Pegawai-pegawai IT
- Juruteknik yang mengkhusus bidang penyelengara data dan rekod
- Tenaga pengajar yang ingin membina modul kursus
Silibus
Access Fundamentals
- Introduction to Databases
- Starting Access
- The Getting Started Page and Opening a Database
- What’s New in Access
- Understanding the Access Program Screen
- Understanding the Ribbon
- Using the Office Button and Quick Access Toolbar
- Using Keyboard Commands
- Using Contextual Menus
- Using Help
Database Basics
- Working with Database Tour of a Table
- Adding, Editing and Deleting Tour of a Form
- Tour of a Query
- Tour of a Report
- Previewing and Printing Selecting Data
- Cutting, Copying and Using Undo and Redo
- Checking Your Spelling
- Exiting Access
Creating and Working with a Database
- Planning a Database
- Creating a New Database
- Creating a Table
- Modifying a Table
- Creating a Query
- Sorting a Query
- Using AND and OR Operators in a Query
- Creating a Form with the Form Wizard
- Creating a Report with the Report Wizard
- Creating Mailing Labels with the Label Wizard
- Converting an Access Database
Finding, Filtering, and Formatting Data
- Finding and Replacing Data
- Sorting Records
- Using Common Filters
- Filtering by Selection
- Filtering by Form