Print

Kursus Microsoft Access (Asas dan Pertengahan)

Posted in Kursus Pelbagai Pekej

bannerKursus13

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 2007


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