Training Microsoft Access : Advance Queries,Form,Report And Macros

Posted on: November 28, 2017 Posted by: admin diorama Comments: 0

Training Microsoft Access : Advance Queries,Form,Report And Macros

Pelatihan/Kursus Microsoft Access : Advance Queries,Form,Report And Macros

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

  1. 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

  1. 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

  1. 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

  1. 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

  1. 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 cvdior.co.id tahun 2021 :

9 – 11 Februari 2021

30 Maret – 1 April 2021

2 – 4 Juni 2021

6 – 8 Juli 2021

4 – 6 Agustus 2021

31 Agustus – 2 September 2021

13 – 15 Oktober 2021

2 – 4 November 2021

30 November – 2 Desember 2021

21 – 23 Desember 2021

Jadwal tersebut dapat disesuaikan dengan kebutuhan calon peserta

Lokasi Pelatihan Diotraining.com :

  • Yogyakarta, Hotel Dafam Malioboro (7.250.000 IDR / participant)
  • Jakarta, Hotel Amaris Tendean (7.750.000 IDR / participant)
  • Bandung, Hotel Golden Flower (7.750.000 IDR / participant)
  • Bali, Hotel Ibis Kuta (8.500.000 IDR / participant)
  • Lombok, Hotel Jayakarta (8.750.000 IDR / participant)

Investasi Pelatihan tahun 2021 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 di Diorama untuk Paket Group (Minimal 2 orang peserta dari perusahaan yang sama):

  • FREE Airport pickup service (Gratis Antar jemput Hotel/Bandara)
  • FREE Transportasi Peserta ke tempat pelatihan .
  • Module / Handout
  • FREE Flashdisk
  • Sertifikat
  • FREE Bag or bagpackers (Tas Training)
  • Training Kit (Dokumentasi photo, Blocknote, ATK, etc)
  • 2xCoffe Break & 1 Lunch, Dinner
  • FREE 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.

Technorati Tags: training production optimization of oil & gas pasti jalan,training optimalisasi produksi migas pasti jalan,training pengenalan production of oil & gas pasti jalan,training gas well loading prediction pasti jalan,pelatihan production optimization of oil & gas pasti jalan,pelatihan optimalisasi produksi migas pasti running

Leave a Reply:

Alamat email Anda tidak akan dipublikasikan. Ruas yang wajib ditandai *

Tanyakan pada kami ?

Kami di sini untuk membantu Anda! Jangan ragu untuk menanyakan apapun kepada kami. Klik di bawah untuk memulai obrolan.

Marketing

Dian

Online

Marketing

Fauzi

Online

Marketing

Isna

Online

Marketing

Faisal

Online

Dian

Hai, tanyakan pada kami ? 00.00

Fauzi

Hi, What can i do for you? 00.00

Isna

Hi, What can i do for you? 00.00

Faisal

Hai, tanyakan pada kami ? 00.00