Training ini memberikan pengetahuan, skill dan praktek untuk mengambil ujian sertifikasi Microsoft Certified Application Specialist (MCAS) dengan materi Access 2007. Topik yang dibahas sesuai dengan Exam Objectives yang dikeluarkan oleh Microsoft.

Durasi : 3 hari

• Structuring a Database
  • Define data needs and types
  • Define and print table relationships
  • Add, set, change, or remove primary keys
  • Split databases

• Creating and Formatting Database Elements
  • Create databases
  • Create tables
  • Modify tables
  • Create fields and modify field properties
  • Create forms
  • Create reports
  • Modify the design of reports and forms

• Entering and Modifying Data
  • Enter, edit, and delete records
  • Navigate among records
  • Find and replace data
  • Attach documents to and detach from records
  • Import data

• Creating and Modifying Queries
  • Create queries
  • Modify queries

• Presenting and Sharing Data
  • Sort data
  • Filter data
  • Create and modify charts
  • Export data
  • Save database objects as other fi le types
  • Print database objects

• Managing and Maintaining Databases
  • Perform routine database operations
  • Manage databases