Advanced training program "Processing and analysis of information in MS Access and MS Excel"

Program content:

SECTION 1. Process modeling in MS Excel (12 training hours)
Setting up the Excel work environment. Creating a table and working with its main parameters
Using built-in functions
Optimization problems. Add-on “Search for a solution”
Developer tab. Form controls

SECTION 2. Working with a table as a database (4 training hours)
Sorting and filtering data.
Document merging technology

SECTION 3. Graphical presentation of data in Excel (4 training hours)
Construction of graphs and diagrams of varying complexity
Using Macros

SECTION 4. Working with MS Access databases (16 training hours)
Creating tables in Access and working with external data
Requests for selecting and editing data
Multi-Table Database Basics
Forms.
Generating reports

Preliminary class schedule:

• April 29 (Wed) 9.00 – 16.00 (8 hours);
• April 30 (Thursday)  9.00 – 16.00 (8 hours);
• May 4 (Mon) 9.00 – 16.00 (8 hours);
• May 5 (Tue) 9.00 – 16.00 (8 hours)
• May 6 (Wed) 9.00 – 12.00 (4 hours) + test.