Microsoft Acsess : Advance Queries,Form,Report And Macros
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
Presentation
Discuss
Case Study
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 Informasi Training Tahun 2024 :
16 -17 Januari 2024
13 – 14 Februari 2024
5 – 6 Maret 2024
24 – 25 April 2024
21 – 22 Mei 2024
11 – 12 Juni 2024
16 – 17 Juli 2024
20 – 21 Agustus 2024
17 – 18 September 2024
8 – 9 Oktober 2024
12 – 13 November 2024
17 – 18 Desember 2024
Jadwal training diatas dapat berubah sewaktu-waktu. Untuk memastikan jadwal pelatihan fix running di tahun ini silahkan konfirmasi jadwal dan lokasinya melalui whatsapp marketing kami
LOKASI DAN INVESTASI
Lokasi Pelatihan Diotraining.com :
- Yogyakarta, Hotel Dafam Fortuna Grande Malioboro (6.000.000 IDR / participant)
- Jakarta, Hotel Amaris Kemang (6.500.000 IDR / participant)
- Bandung, Hotel Neo Dipatiukur(6.500.000 IDR / participant)
- Bali, Hotel Ibis Kuta (7.500.000 IDR / participant)
- Lombok, Hotel Jayakarta (7.500.000 IDR / participant)
LOKASI DAN INVESTASI
Investasi Pelatihan tahun 2024 ini :
Investasi pelatihan selama tiga 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 Pelatihan :
- Airport pickup service (Gratis Antar jemput Hotel/Bandara Khusus Bali dan Bandung)
- Akomodasi Peserta ke tempat pelatihan .
- Module / Handout Softcopy ataupun Hardcopy
- Flashdisk atau Link Download Material
- Sertifikat dan dokumentasi
- Bag or bagpackers (Tas Training)
- Training Kit (Blocknote, ATK, etc)
- 2x Coffee Break & 1 Lunch, Dinner
- Souvenir Exclusive
Jadwal Pelatihan masih dapat berubah, mohon untuk tidak booking transportasi dan akomodasi sebelum mendapat konfirmasi dari Marketing kami. Segala kerugian yang disebabkan oleh miskomunikasi jadwal tidak mendapatkan kompensasi apapun dari kami.
