Ten serwis używa plików cookies. Brak zmiany ustawień przegl±darki oznacza zgodę na ich używanie.
Więcej informacji o plikach cookies znajdziesz tutaj
Kliknij ZGADZAM SIĘ, aby ta informacja nie wyświetlała się ponownie
Cognity.pl
You are here: home pageAccess TrainingAdvanced Access Training

Advanced Access Training


Will the Advanced Access Training be suitable for me?


The Advanced Access Training is for those who:

  • have a basic knowledge of working in MS Access,
  • want to learn good design the database structure using advanced tools.

 

After the Advanced Access Training You will know how to:

  • use advanced MS Access tools,
  • create advanced queries, also using SQL
  • prepare database for external users,
  • create complex forms and reports with graphs,
  • protect data and privileges.

 

 

 

 

What makes us different from other training companies?

 

 

Training needs surveys

Before training, we ask you to specify your expectations and analyse your needs. This way, our trainer will be able to suggest the most suitable kind of training for you and modify the programme according to your needs.

 

 

Training materials

As a participant of our training, you will receive a complete set of carefully developed training materials including:

  • A reference book discussing the issues covered by the training and providing a "step-by-step" description of the respective exercises,
  • Unlimited electronic access to exercises and training materials within the framework of the Cognity Knowledge Zone.

 

Certificate

Having completed a training course, you will receive a certificate confirming the qualifications you gained. The back side of the certificate lists the programme of your training. Cognity certificates are issued pursuant to an entry in the Register of Training Institutions (no. 2.12/00106/2011).

 

 

The comfort of learning

In order to ensure optimum learning conditions, we organise training courses in small groups of no more than 10 participants. We will prepare an individual computer station for you, too.

 

 

Post-training assistance

Having completed our training course, you will be offered the assistance of our trainer. If you have any doubts or questions concerning the subject-matter of your training, you can call us, e-mail us or arrange a personal meeting (in our company) with the trainer, who will be at your service.

 

 

No matter where you choose to have your training...

We offer, as extra service, assistance in finding the right accommodation or restaurant for you and we can organise other attractions as well.


Training courses include lunch and coffee breaks.

Advanced Access Training programme

Basic subjects quick repetition.

Tables

  • selection of data fields to content,
  • input mask,
  • primary keys and foreign keys,
  • indexes,
  • validation rule,
  • enforcing referential integrity .

Queries - advanced topics

  • advanced select queries,
  • parameterized query,
  • calculations in a query,
  • query using the constructor expressions.

Using queries with SQL

  • query connecting,
  • pass-through queries data.

Preparing database for external users

  • creation of the welcome board,
  • creation of a switching form,
  • setting the startup options ,
  • create and use macros,
  • maintenance of the database .

Forms - advanced topics

  • types of forms,
  • create a form using Design view,
  • sections,
  • data validation,
  • broadcast your forms look professional,
  • work with subforms,
  • charts and pivot tables, form.

Reports - advanced topics

  • create and edit reports,
  • subreports,
  • formatting reports,
  • charts on reports.

Safety and streamline

  • securing the database password,
  • encryption and decryption of data,
  • sharing database,
  • database replication,
  • distributor database,
  • working groups and permissions,
  • protection of database design,
  • distribution base.

Day 1

Schedule       Time
Registration 9:00 - 9:15
Classes 9:15 - 11:00
Break 11:00 - 11:15
Classes 11:15 - 12:30
Lunch 12:30 - 13:15
Classes 13:15 - 14:30
Break 14:30 - 14:45
Classes 14:45 - 16:00

 

Day 2

Schedule         
Time
Classes 9:00 - 11:00
Break 11:00 - 11:15
Classes 11:15 - 12:30
Lunch 12:30 - 13:15
Classes 13:15 - 14:30
Break 14:30 - 14:45
Classes 14:45 - 16:00

Upcoming dates

DurationNet:16 lesson units / 2 days
Price per person:2400 zł
Contact phone:12 421 87 54
Application Form
for Training (PDF)
Training
Program (PDF)

Selected clients: