Av. de Cabo Verde 1, 4900-568
Viana do Castelo
info@datacolab.pt
Ph: +351 258 824 281
recrutamento@datacolab.pt
#CertifiedModularTraining

Database Management System

Enroll now!

Duration

50 hours

UFCD

0759

Credit Points

4.5

Objectives

  • Design relational database tables.

  • Create filters for data queries.

  • Develop forms for data entry.

Content
  • Fundamental Principles of DBMS
    • Database Design
    • Objects
    • Tables
    • Forms
  •  Tables
    • Field Attributes
    • Data Validation
    • Error Messages
    • Input Masks
    • Table Relationships
    • System Tables
    • Relationships Between Tables
    • Data Entry and Display
    •  
  • Queries
    • Simple Parameterization
    • Multiple Parameterization
    • Cross Queries
    • Formulas
    • Totals
    • Updating Records
    • Deleting Records
    • Adding Records
  • Forms
    • Toolbox
    • Control Types
    • Form Interlinking
  • Application Menus
    • Reports
    • Report Types
    • Modifying Reports
    • Reports Based on Tables
    • Reports Based on Queries

First Edition

North

4th of July

Enrollments Open

Center

4th of July

Enrollments Open

South

4th of July

Enrollments Open
See Courses
Enroll now!

Avenida de Cabo Verde 1
4900-568, Viana do Castelo
Portugal

Contacts

Useful Links

Portuguese Data Academy

Media

About

© 2022  Data CoLAB  All rights reserved

Terms and Conditions   |   Privacy and Personal Data Policy   |   Complaints Book