TRAINING MICROSOFT ACCESS ADVANCE QUERIES FORM REPORT AND MACROS

TRAINING MICROSOFT ACCESS ADVANCE QUERIES FORM REPORT AND MACROS

TRAINING TROUBLESHOOTING PROCEDURES FOR MACRO ERROS

TRAINING MICROSOFT ACCESS

Deskripsi

Microsoft Access provides a wealth of powerful tools to build, organize, and share databases so that we can work smarter, faster, and more accurately. Corporate that working with sales information, customer records, employee stats, contact management information, product inventory, direct mail results, or other valuable data, Access helps organize it so that it’s easily accessible and readily understandable. Access gives the capability to quickly analyze details, uncover critical relationships, and share the information throughout organization or corporate via customized forms and reports. This course is designed to people who have already mastered the basics of Access and in building a simple database with using Wizards, filters, sorts, and queries or formatting forms, reports, and tables, and this seminar will teach how to transform complicated data into sound business solutions.

Materi

1.  Overview Advanced Ms. Access
2.  Advanced Table Design

* How to create multiple tables and ensure they work in tandem
* Ways to change table designs without compromising data integrity
* A look at refining tables with hyperlink controls, indexes, and properties
* How to edit the properties of linked tables

3.  Complex Relationships Between Databases

* Referential Integrity: how to ensure related tables maintain consistency
* Design technquies for advanced links and table joins
* Options for Autojoin
* How to handle time-dependent data

4.  Advanced Data Manipulation With Queries and Filters

* Queries in multiple tables: what you can and can’t accomplish
* How to replace existing query data
* 3 ways to create efficient table joins
* How to specify record criteria by group, aggregate, and non-aggregate total fields
* Advanced Queries: parameter, data definition, and union queries

5.  Advanced Techniques for Using Forms, Subforms, and Reports

* How to create subforms with and without the Wizard
* Tips for moving and resizing controls
* How to filter records within a form using complex criteria expression
* Actions that create a form for a subform
* How to export reports to dynamic or static HTML format

6.  Expert Macro Techniques
* How to define macros as a group but still activate them individually
* Troubleshooting procedures for macro erros
* How to add actions and arguments to macros
* Guidelines for attaching a macro to controls or forms
* How to set conditional expressions to a macro

7.  Multi-User Systems

* Strategies for determining the configuration that best suits your needs
* How to deploy page locking when multiple users access your information
* Tips for setting defaults for multi-user systems
* How to refresh DAO collections in a multi-user environment
* What you can do to protect your database from outside tampering and unauthorized alterations to information

Metode
1. Presentation
2. Discuss
3. Case Study
4. Evaluation

Instruktur

Budi Sutedjo,S.Kom,M.M

Peserta

Managers Supervisors, Team Leaders, Sales Professionals, Small-Business Owners, Secretaries, Administrative, Assistants and Anyone who’s responsible for organizing, analyzing, and interpreting data swiftly, easily, and accuratel.

Jadwal TMI Consultant 2026

Batch 1 : 7 – 8 Januari 2026

Batch 2 : 11 – 12 Februari 2026

Batch 3 : 4 – 5 Maret 2026

Batch 4 : 8 – 9 April 2026

Batch 5 : 6 – 7 Mei 2026

Batch 6 : 10 – 11 Juni 2026

Batch 7 : 8 – 9 Juli 2026

Batch 8 : 5 – 6 Agustus 2026

Batch 9 : 9 – 10 September 2026

Batch 10 : 14 – 15 Oktober 2026

Batch 11 : 4 – 5 November 2026

Batch 12 : 2 – 3 Desember 2026

Catatan : Jadwal dapat menyesuaikan dengan kebutuhan anda.

Biaya dan Lokasi Pelatihan :

• Jakarta: Hotel Amaris Kemang, Amaris Tendean,Trinity Hotel, Ibis Budget | Biaya Pelatihan : Rp. 7.500.000 / peserta(Minimal 2 Peserta).
• Bandung: Hotel Santika, Hay Hotel,Ibis Style, Novotel Hotel, Golden Flower Hotel, 1O1 Hotel, Grand Tjokro Hotel, Tune Hotel, Four Point by Sheraton Hotel | Biaya Pelatihan : Rp. Rp. 7.000.000 / peserta(Minimal 2 Peserta).
• Yogyakarta : Hotel NEO+ Awana, Cordela Hotel,Ibis Style, Boutique Hotel, Cavinton Hotel, Mutiara Hotel, Dafam Malioboro Hotel, Prima Inn Hotel | Biaya Pelatihan : Rp. 6.500.000 / peserta(Minimal 2 Peserta).
• Surabaya: Novotel Hotel, Ibis Center Hotel, HARRIS Hotel, Favehotel, Alana Hotel | Biaya Pelatihan : Rp. 6.800.000 / peserta (Minimal 2 Peserta).
• Malang : Amaris Hotel, The 1O1 Hotel, Ibis Style Hotel, El Hotel, Whiz Prime Hotel | Biaya Pelatihan : Rp. 6.800.000 / peserta (Minimal 2 Peserta).
• Bali: Ibis Kuta, Fontana Hotel, HARRIS Hotel & Conventions | Biaya Pelatihan : Rp. 6.500.000 / peserta (Minimal 3 Peserta).
• Lombok: Favehotel, Novotel Lombok, D Praya Hotel | Biaya Pelatihan : Rp. 7.000.000 / peserta (Minimal 3 Peserta).

Catatan : Biaya diatas belum termasuk akomodasi/penginapan. Apabila ada pertayaan mengenai materi, biaya, lokasi, jadwal dan penawaran lainnya, hubungi kami di nomor CS kami.

Fasilitas Pelatihan di TMI Consultant:

1. Penjemputan dari Hotel/Bandara/Stasiun/Terminal.
2. Training Kit (Dokumentasi photo, Blocknote, ATK, Flashdisk, dll).
3. Transportasi Peserta ke tempat pelatihan.
4. 2x Coffe Break & 1 Lunch (Makan Siang).
5. Training Room Full AC and Multimedia.
6. Free Bag or Bagpackers (Tas Training).
7. Softfile Foto Training
8. Sertifikat Pelatihan.
9. Souvenir Exclusive.