Microsoft Access. Level 3. Database development. Forms, reports and macros - course RUB 23,990. from Specialist, training, Date: December 2, 2023.

A true expert teacher, Microsoft Certified Trainer. Andrey Nikolaevich has more than 15 years of teaching experience. He is able to present the most complex material in an accessible manner. Its grateful graduates invariably note the friendliness towards students, the use of practical examples from life in the classroom and the desire to convey all their vast experience and deep knowledge.
Andrey Nikolaevich graduated with honors from the Moscow State Aviation Technological University (RGTU named after. TO. E. Tsiolkovsky). He worked as a research assistant at the Central Institute of Aviation Engine Engineering (CIAM) named after. P.I. Baranova. He has been teaching at Specialist since 1999. Specializes in providing training on Microsoft Access databases and programming in the Microsoft Office environment in VBA. In addition to teaching at the Center, he provides consulting services and participates in the development of applications for desktop databases and automation projects for Microsoft Office applications.
Author of popular training courses “Visual Basic for Application (VBA). Automation of work in Microsoft Excel", "Microsoft Access. Database development" and many others. The teacher has many publications in the popular computer magazine “Computer Press”.
Over the years of teaching at the center, Andrei Nikolaevich has successfully trained several thousand specialists. Among its graduates are employees of many large companies and organizations, including Coca-Cola, Bosco Sport, Dirol Cadbury, Michelin, Bosch-Siemens, Canon and many others.

Module 1. Creating screen forms (8 ak. h.)

-Creation of forms of different types for working with data
-Adding additional controls to the form and setting their properties
-Calculations in forms
-Creating a form with one or more subforms
-Conditional formatting in forms
-Creating diagrams in forms. Chart types in Access 2019
-Dialog boxes for entering parameters into the request

-Module 2. Creation of printed reports (4 ac. h.)

-Creating reports based on tables and queries
-Elements and sections of reports, their properties
-Setting up grouping and sorting of data in reports
-Calculations in reports
-Types of reports and their use to present information
-Print reports, export reports to PDF format

Module 3. Programming macros in Access (8 ac. h.)

-Creating macros
-Overview of macro commands, working with the catalog of macro commands
-Configure macro security settings, safe and unsafe macros
-Creating embedded macros for processing events in forms
-Managing the progress of macro execution, checking the conditions for executing macro commands
-Error handling and macro debugging
-Macro executed automatically when the database is opened

Module 4. Building a complete application for the user to work with (4 ac. h.)

-Building a button form
-Defining application launch parameters
-Setting the transition area
-Compilation of the ACCDE executable file