Microsoft Access. Level 2. Database development. Tables and queries - course RUB 22,990. from Specialist, training, Date: December 2, 2023.
Miscellaneous / / December 05, 2023
One of the most important tasks of any modern organization or enterprise is the task of storing and efficiently processing information. With the latest version of the popular desktop database management system Microsoft Access 2019, you can create a database to store tables from various sources, as well as generate numerous queries for analysis information.
The course program is aimed at users with initial experience in Microsoft Access who want to learn develop your own databases in Microsoft Access and create queries of any complexity for them to process tabular information.
The updated interface of Microsoft Access 2019/2016 will help you focus on the main thing when working with the database and quickly learn its main tools.
After completing the course, you will master not only the basic functionality, but also the excellent capabilities of new versions of Access, which will allow you to more effectively use Microsoft Access 2019 in your daily work.
The course program completely covers the authorized course 50533AC.
-Design Microsoft Access 2019/2016 databases
-Create tables and establish relationships between them
-Import and connect to external data sources
-Create complex selection queries
-Create queries to change the contents of tables
-Create SQL join queries
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. Database design (2 ac. h.)
-Overview of database design methodology
-Stages of database development
-Database schema development
Module 2. Creating tables and working with external data (6 ak. h.)
-Creating tables in Access, defining relationships in a data schema, the concept of data integrity
-Lookup fields, input masks and custom formats
-Creation of indexes
-Working with external data: importing and linking data, saved import operations
-Analysis of tables to eliminate redundancy of stored information
Module 3. Data processing using selection queries (4 ac. h.)
-Creating a query on one table
-Setting selection criteria
-Filtering and sorting data using queries
-Building queries on multiple tables
-Properties of relationships between tables in a query. Influence of connection properties on the result of query execution
-Query to search for records without subordinates
Module 4. Calculations in queries (4 ac. h.)
-Calculated fields in queries. Using the Expression Builder
-Overview of built-in Access functions
-Calculation of totals: queries with grouping
-Getting compact summaries: cross-queries
Module 5. Change requests (4 academic units) h.)
-Processing large volumes of data: change requests (requests-actions)
-Adding, updating, deleting records using queries
-Parametric queries
Module 6. SQL queries. Creating join queries (4 ak. h.)
-Basics of SQL language
-Nested SQL queries
-Query to find duplicate records
-Creating join requests