Manage databases
Modify database structure
 import objects or data from other sources
 delete database objects
 hide and display objects in the Navigation Pane
Manage table relationships and keys
 understand relationships
 display relationships
 set primary keys
 enforce referential integrity
 set foreign keys
Print and export data
 configure print options for records, forms, and reports
 export objects to alternative formats
Create and modify tables
Create tables
 import data into tables
 create linked tables from external sources
 import tables from other databases
Manage tables
 hide fields in tables
 add total rows
 add table descriptions
Manage table records
 find and replace data
 sort records
 filter records
Create and modify fields
 add and remove fields
 add validation rules to fields
 change field captions
 change field sizes
 change field data types
 configure fields to auto-increment
 set default values
 apply built-in input masks
Create and modify queries
Create and run queries
 create simple queries
 create basic crosstab queries
 create basic parameter queries
 create basic action queries
 create basic multi-table queries
 save queries
 run queries
Modify queries
 add, hide, and remove fields in queries
 sort data within queries
 filter data within queries
 format fields within queries
Modify forms in layout view
Configure form controls
 add, move, and remove form controls
 set form control properties
 add and modify form labels
Format forms
 modify tab order on forms
 sort records by form field
 modify form positioning
 insert information in form headers and footers
 insert images on forms
Modify reports in layout view
Configure report controls
 group and sort fields on reports
 add report controls
 add and modify labels on reports
Format reports
 format a report into multiple columns
 modify report positioning
 format report elements
 change report orientation
 insert information in report headers and footers
 insert images on reports

Microsoft Office Specialist: Microsoft Access Expert (Access and Access 2019)

About this Course:

This course covers the ability to create and maintain Access Database objects including tables, relationships, data entry forms, multilevel reports, and multi-table queries.

Course Goals/Skills:

• Manage databases
• Create and modify tables
• Create and modify queries
• Modify forms in layout view
• Modify reports in layout view .

Course Format:

Присъствен (Classroom) Курс в Учебната ни зала или В Офис на Клиент	Онлайн (Online/Virtual) Курс във виртуална зала с инструктор

Course Language Option

Български (Bulgarian)	Английски (English)

You can choose the language in which the training will be conducted – Bulgarian or English. All our instructors are fluent in English.

Student Guides:

The training materials are available in electronic format. They can be used online / offline on any device. Lifetime access.

Lab Environment:

Each student has their own lab environment where the exercises are conducted, part of the course. You do not need to install software on a computer or special hardware requirements.
Participants in a face-to-face format in our Training Center have an individual computer during the training.

At Course Completion:

Lifetime Access - Video Archive 24/7	Certificate of Course Completion

Lifetime access to a video archive with recording of each individual lecture.
Official internationally recognized certificate for completed training course.

Course Duration:

• 2 working days (09:00 – 17:00)
  or
• 16 hours  training (theory and practice) in non-working hours lasting 4 weeks
  Saturday and Sunday 10:00 – 14:00, 14:00 – 18:00, 18:00 – 22:00
  Monday and Wednesday 19:00 – 23:00
  Tuesday and Thursday 19:00 – 23:00

Payments:

An application for an invoice is accepted at the time of enrollment in the respective course.

An invoice is issued within 7 days of confirming the payment.

Next Course:

For more information, use the contact format. We will contact you to confirm the data.