Page 1119 - Get_Training_Catalogo_presencial_2026

MICROSOFT ACCESS (AVANÇADO) MICROSOFT ACCESS (ADVANCED) 16.01 | Microsoft Office
16.01 | Microsoft Office
Requirements
Knowledge on Base Access

Access is the more used database management system. It can be used to easy and rapidly develop relation database applications that
assist and help to manage information.

CONTENTS
OBJECTIVES
Module 1 - Concepts
This course intends to give trainees advanced knowledge for - Concept of Primary Keys and Secondary
a correct use of Access. - Relationship between Concept Tables and Referential Integrity
Potentialities of Access in its aspect of advanced use and
automation will be presented in the use of macros and Module 2 - Tables and Forms
development of small information systems.
- Relations between Tables
- Creation of Tables and Fields Properties
ADDRESSEES - Form Creation
- Data Entry on Form
Everyone interested in knowing more on the potentialities
made available by Access. - Formatting Structure and Use of Forms Tools
- Data Entry through Form
- Creating Buttons
AVAILABLE IN THE FOLLOWING VERSIONS
- 2007 Module 3 - Consultations
- 2010 - Selection Consultations
- 2013 - Consultations with Formulas
- 2016 - Working with Multiple Tables
- Query Action

Module 4 - Reports
- Report Creation
- Formatting Reporting Framework
- Report Preview

Module 5 - Sort and Filter; Replace
INFORMATION - Sort Records
Hours: 20h - Filters of Use
Time: See Training Plan - Using the Tool Change
Material Delivered: Training Support Material
Training: Attendance Required Module 6 - Introduction to Create Macros
Regime: Working Hours / Post-Working Hours
Module 7 - Data Import

Module 8 - Safety Database
METHODOLOGIES

Methodologies used by the trainer will be
expository, demonstrative and/or active, favouring
the latter whenever possible.

ANGOLA +244 225 400 399 | www.get-ao.com ∙ PORTUGAL +351 244 820 630 | www.get-pt.pt ∙ MOÇAMBIQUE +258 857 367 374 | www.get-mz.com 19