Microsoft Access. Level 1. Processing and analysis of information in databases - course 17,990 rubles. from Specialist, training 20 ac. h., Date: December 4, 2023.
Miscellaneous / / December 06, 2023
Databases exist in every organization. One of the programs that allows employees to solve problems of data storage and processing is Microsoft Access.
Microsoft Access 2019 is the latest version of the popular database management system, a tool for the rapid development of databases and custom applications for them.
You will learn how to use Microsoft Access 2019 to create databases for storing tabular information from various sources, create queries and reports to analyze information and view results, create screen forms that will turn the database into a convenient application for the end user user.
The updated Microsoft Access 2019 interface will help you focus on what matters most when working with your database and quickly learn its main tools for working both with existing databases and when developing your own databases data.
After completing the course, you will master not only the basic functionality, but also the new features of Access 2019, which will allow you to use Microsoft Access more effectively in your daily work.
This course prepares you for passing the Access exam to obtain the international MICROSOFT OFFICE SPECIALIST certificate.
The course program completely covers the authorized course 50532AC.
-Create new Access 2019/2016 databases using a template
-Work with ready-made Access databases
-Create simple Access 2019/2016 databases for storing, entering and processing information
-Create new tables in the database, configure their properties and establish relationships between them
-Import data from Excel files into Access 2019/2016/2013 database
-Create screen forms for editing tabular data
-Create queries to process information from tables
-Create reports for analyzing and printing tabular data
Experienced and demanding teacher, focused on high results. Author of the only authorized Microsoft Excel training courses in Russia. The training manuals compiled by Olga Vladimirovna have been established by Microsoft as a training standard...
Experienced and demanding teacher, focused on high results. Author of the only authorized Microsoft Excel training courses in Russia. The tutorials compiled by Olga Vladimirovna have been established by Microsoft as the Excel training standard.
He sees his task as a teacher in so that you can say: “I can do it!” I know how to do it! Achieving this result requires extensive teaching experience. Add to this passion for your work, and you get the formula for an ideal teacher!
Graduate of Moscow State Technical University named after N.E. Bauman. Regularly attending conferences gives her a deep understanding of the products taught, revealing the most relevant areas of application of their capabilities. Work experience allows us to achieve the target result in mastering the material with students of various levels of preparedness, ages, professions and interests. Practical assignments allow you to make learning Microsoft Office programs as interesting and effective as possible for each student. The original examples used for training are focused on solving current problems of the modern office.
Olga Vladimirovna implements educational projects of any complexity for leading Russian and foreign companies. Among its more than 14,000 graduates are employees of such companies as Loreal, Tetra Pak, Schneider Electric, Volkswagen Group Rus, Gedeon Richter-Rus, Moscow Interbank Currency Exchange, Australian Embassy, Walt Disney Company CIS, Samsung Electronics Rus Company, BANK URALSIB, MICHELIN Russian Company tire production, Nexia Pacioli Consulting, Air Rianta International Duty Free, Diva, Mobile TeleSystems, Housing Mortgage Lending Agency, Janssen Pharmaceuticals N.V., Robert Bosch, MegaFon, Johnson & Johnson, BSH Household Appliances, Colgate-Palmolive, Mosenergo, Tetra Pak CJSC, Home Credit and Finance Bank LLC, and a lot others.
Olga Vladimirovna is the author of publications:
Author of the Microsoft Excel 2019/2016 course. Level 6. Business analytics using Power Pivot, Power Query and 3D Map.
Author of teaching materials for Microsoft Excel courses:
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...
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. Introduction to Microsoft Access databases 2019/2016/2013 (2 ac. h.)
-Introduction to database technology for storing information
-Difference between Access databases and Excel spreadsheets
-Overview of the main innovations in Microsoft Access 2019/2016/2013
-Creating a Microsoft Access 2019/2016/2013 database using a template
-Working with an existing database
-Purpose of main Access database objects
-Working with database objects in the Navigation Area
Module 2. Creating tables in an Access database and working with them. Importing data into Access (6 ac. h.)
-Creating tables in a Microsoft Access 2019/2016/2013 database: setting data types, field properties
-Entering and editing data in tables
-Import data from other applications into an Access 2019/2016/2013 database
-Types of relationships between tables in a database
-Defining relationships between tables in the Data Schema window, setting data integrity
-Use of substitutions (fields with the ability to select from a list)
-Setting properties that restrict data entry into the table
Module 3. Creating screen forms (4 ak. h.)
-Automatic creation of screen forms of different types: columnar, ribbon and divided
-Creating forms using the Form Wizard
-Working with tabular data using forms
-Changing the design and settings of the form in Layout and Design modes
-Adding additional fields from the table to the screen form
-Representing a one-to-many relationship using a subform
Module 4. Data processing in Access: filters and queries (4 ac. h.)
-Search data in tables
-Sorting and filtering data in tables
-Create simple queries based on one or more tables
-Sorting data using queries
-Setting criteria for selecting records
-Calculations in queries
Module 5. Creation of printed reports. Export report to PDF. Using services (4 ac. h.)
-Create a printed report without grouping
-Creating a report with grouping using the Report Wizard
-Changing report settings in Layout and Design modes
-Export report to PDF format
-Backup and restore the database
-Compression and recovery of Microsoft Access 2019/2016/2013 database