Pelatihan Microsoft Access
Training Microsoft Access
Pelatihan Microsoft Access Description of This training will give you comprehensive guides to professionals which using Office application in their work. This training will cover all the features in Microsoft Access .
Course Outline
Understanding Databases
- Starting Access and Opening an Existing Database
- Moving Around in Access
- Understanding Datasheet View and Design View
- Using the Mouse Pointer to Navigate in Datasheet View
- Using the Keyboard to Navigate in Datasheet View
Creating Tables
- Creating a Database
- Creating a Table Using the Table Wizard
- Creating and Modifying a Table in Design View
- Adding Fields to Tables
- Adding and Editing Records
- Printing Tables
- Moving and Deleting Fields; Deleting Records
Working with Tables
- Formatting a Table; Modifying Field Properties
- Sorting Records in a Table
- Finding Records in a Table
- Using Filters with a Table
- Establishing Relationships Between Tables
- Creating Subdatasheets
- Importing Records From an External Source
Creating and Using Queries
- Creating and Running a Query
- Using Comparison Operators in a Query
- Creating a Calculated Field
- Creating a Multiple-Table Query
- Printing a Query
Designing a Form
- Creating a Form Using AutoForm
- Creating a Form Using the Form Wizard
- Adding Controls to a Form
- Modifying Control Properties
- Resizing and Moving Controls
- Navigating in a Form
- Entering Records into a Form
- Creating Calculated Controls
Designing Report
- Creating a Report Using AutoReport
- Creating a Report Using the Report Wizard
- Adding a Control to a Report
- Formatting a Report
- Resizing and Moving Controls in a Report
- Creating Calculated Controls
- Previewing and Printing a Report
Peserta
Peserta dapat diikuti oleh semua yang tertarik pada bidang ini. Selain itu juga dapat diikuti oleh semua yang ingin mengatahui dan mendalami tentang bidang ini.
Instruktur
Instruktur dalam Pelatihan dan Training ini akan dibawakan oleh seorang yang ahli dalam bidang ini.
Metode
- Presentasi
- Diskusi antar peserta
- Studi kasus
- Simulasi
- Evaluasi
- Konsultasi dengan instruktur
Jadwal Pelatihan tahun 2023
Batch 1 : 17 – 18 Januari 2023 | 26 – 27 Januari 2023
Batch 2 : 9 – 10 Februari 2023 | 21 – 22 Februari 2023
Batch 3 : 8 – 9 Maret 2023 | 16 – 17 Maret 2023
Batch 4 : 12 – 13 April 2023 | 20 – 21 April 2023
Batch 5 : 10 – 11 Mei 2023 | 25 – 26 Mei 2023
Batch 6 : 7 – 8 Juni 2023 | 22 – 23 Juni 2023
Batch 7 : 11 – 12 Juli 2023 | 27 – 28 Juli 2023
Batch 8 : 10 – 11 Agustus 2023 | 23 – 24 Agustus 2023
Batch 9 : 6 – 7 September 2023 | 21 – 22 September 2023
Batch 10 : 11 – 12 Oktober 2023 | 26 – 27 Oktober 2023
Batch 11 : 9 – 10 November 2023 | 21 – 22 November 2023
Batch 12 : 6 – 7 Desember 2023 | 21 – 22 Desember 2023
Jadwal tersebut dapat disesuaikan dengan kebutuhan calon peserta
Lokasi Pelatihan
Yogyakarta, Hotel Dafam Seturan.
Jakarta, Hotel Amaris Kemang.
Bandung, Hotel Amaris Setiabudhi.
Bali, Hotel Quest Kuta.
Lombok, Hotel Jayakarta.
Catatan
Waktu pelatihan Dua+1* hari dengan Biaya tersedia untuk Perorangan, Group, dan Inhouse Training, belum termasuk akomodasi/penginapan.
Untuk biaya dan jadwal training harap menghubungi marketing kembali
Investasi training
Investasi pelatihan selama dua hari tersebut menyesuaikan dengan jumlah peserta (on call). *Please feel free to contact us.
Apabila perusahaan membutuhkan paket in house training, anggaran investasi pelatihan dapat menyesuaikan dengan anggaran perusahaan.
Fasilitas training:
Free Penjemputan dari bandara ke hotel*.
Modul / Handout.
Flashdisk*.
Certificate of attendance.
FREE Bag or bagpacker.