ACCESS 2016

Bucharest 04 November 2019 - 08 November 2019

Trainer: Dana-Maria Boldeanu, Mirela Gheorghe

Details

The program aims to acquire intermediate and advanced concepts and techniques on the practical use of Microsoft Office software - Microsoft ACCESS, enabling end users from financial field to operate in a professional way using database tools

Target group

The direct beneficiaries of the program are persons working in the financial and banking field (in the field of insurance, private pensions and financial investments, related or similar activities, as well as risk management, human resources management and management of the organization) with a basic level of knowledge in using Microsoft Access.

Course objectives

The program provides the opportunity to acquire skills in modeling the economic and financial issues by managing databases using the Microsoft Access 2016

Subjects

Module 1: The Database Concept and Database Management System;
ACCESS 2016 Interface.
Details
- Definition of database concepts and database management system
- Relationships between tables of a database
- Normalization of databases
- ACCESS 2016 interface.
- End of module study case.

Module 2: Creating a database. Create a type object Table.
Details

- Create a database
- Design a new table
- Description of the structure of a table
- Field properties
- Define primary keys and indexes
- Define field integrity restrictions
- Adding / modifying / deleting / searching / sorting / filtering of records in tables
- Saving tables
- Define a foreign key
- Define relationships between tables
- End of module study case.

Module 3: Interrogation Objects
Details

- What is a query?
- Types of queries
- Creating select queries (on a table)
- Defining calculated fields in select queries
- Operators, constant, functions
- creating select queries on 2 or more tables
- saving and running queries
- modify queries
- parameter queries
- total queries (aggregate data)

Module 4: Interrogation Objects II
Details

- create form objects
- creating a simple form (on a table)
- structure, forms controls
- create report objects
- creating a simple report (on a table)
- grouping and sorting data in a report
- end of module study case.

Trainer

Mirela Gheorghe is a professor at the Management Information Systems Department within the Faculty of Accounting and Management Information Systems – Bucharest University of Economic Studies Management Information Systems. She has over 20 years of experience in teaching and research in specializations: Office Applications Technology, Business Databases, Economic Informatics and Analysis Technical data, IT Audit. She obtained the professional qualification of Microsoft Office Specialist certification in 2016 from Microsoft through Learning Solution Training in Romania. Doctor in accounting since 2004, following the doctoral thesis entitled "Audit of accounting information in the conditions of use of information systems". In the period 2011-2013, the postdoctoral courses under the POSDRU project "Postdoctoral Programs in the Forefront of Excellence Research in Information Society Technologies and the Development of Innovative Products and Processes" followed the project "Risk Management - the foundation of sustainable development in a new society based on knowledge".

Author and co-author of university courses, scientific articles and books.

Lecturer (2004, 2014, 2016, 2017) in the training program organized by the Chamber of Financial Auditors in Romania. Lecturer (2008) of the ECDL training course organized by the National Institute of Administration.

Research project director and member of scientific research projects.

Dana-Maria Boldeanu is associate professor at the Management Information Systems Department within the Faculty of Accounting and Management Information Systems – Bucharest University of Economic Studies Management Information Systems. She has over 15 years of experience in teaching and research in specializations: Professional Spreadsheets, Business databases, Business Intelligence, Project Management and Business Services Industry. She obtained the professional qualification of Microsoft Office Specialist certification in 2016 from Microsoft through Learning Solution Training in Romania and also has ITIL® Foundation Certificate (2016) in service management through EXIN/Axelos Global Best Practice. She graduated in 2012 from “Research and Teacher Education for Business & Economics (EDU-RES)” interdisciplinary master program at the Faculty of International Business and Economics. From 2009 Dana Boldeanu is a member of the organizing committee of Accounting and Management Information Systems (AMIS) International Conference and starting with 2014 she is a member of the program committee of IBIMA Conference.

Between 2007 and 2009 she was trainer for ECDL Romania at the National Institute for Administration for: Module 1 and 2 (Computer Essentials), Module 4 and 5 (Excel, Access). She was active since 2002 in numerous research projects gained by competition and financed by the National Research Council or with structural and EU funds. For 2009 Dana-Maria Boldeanu is CEO of Centre for Advanced Services on Electronic Services (E-CAESAR), a non-profit association with researches focus on e-services. She was involved in setting up the research centre, acquiring projects and partnerships, working as leader or member in several projects.