Microsoft Access 2019 Essential Training - Hurbad

31 Cashir

5 Saacadood

iTUS

Course Certificate

Kusoo dhawaada Koorsadaan ( Microsoft Access 2019 ) Waxaad ku baraneeysaa sida loo abuuro Database, Tables, Queries, Reports, Forms, Printing and Sharing. Waxaad kaloo kubaranee isda loogu sameeyo Database Maintenance. Waxaad kaloo sifiican u fahmi doontaa sida ugu wanaagan oo loo adeegsado tools ka cusub ee lasocda Microsoft Access 2019.

Course Content

Expand All

Course Introduction 3 Cashir

Expand

Cutub Content

0% Complete 0/3 Steps

Access 2019: Course Introduction

Installing Microsoft Office 2019

Access 2019 Exercise Files

Getting Started with Access 7 Cashir

Expand

Cutub Content

0% Complete 0/7 Steps

Database Concept

Creating The Database File

Understand The Trust Centre

Navigating the Access Interface

The Database Navigation Pane

Customise The Quick Access Toolbar

Create a Database Backup

Creating Tables 5 Cashir

Expand

Cutub Content

0% Complete 0/5 Steps

Table Structure and Relationships

Create a Table and Set Data Types

Primary and Foreign Keys

Importing Tables

Setting Field Properties 7 Cashir

Expand

Cutub Content

0% Complete 0/7 Steps

Relationships and Referential Integrity

Editing Table Structure in Design View

Control Input With Masks

Set A Default Value

Data Lookup Fields

Additional Field Properties

Organizing Records

Using Queries 5 Cashir

Expand

Cutub Content

0% Complete 0/5 Steps

What are Queries?

The Simple Query Wizard

Build Queries in Design View

Establishing Constraints with criteria

Incorporating AND & OR Statements

Creating a Forms 2 Cashir

Expand

Cutub Content

0% Complete 0/2 Steps

Generate Forms From Tables

Using the From Wizard

Creating Reports 2 Cashir

Expand

Cutub Content

0% Complete 0/2 Steps

Introducing Reports

The Report Wizard