PGDCA MS Access Syllabus Notes

PGDCA MS Access Syllabus Notes

UNIT–I

1. Basics of RDBMS

UNIT–II

2. Working with Table

Create a Table in MS Access

Data Types

Field Properties

validation rules Data Entry

Add record delete record and edit text

Sort option

find/replace

What is filter

rearrange columns

freeze columns

Edit a Tables- copy, delete, import

modify table structure

UNIT–III

3. Working with Query

Introduction of relationship

How to Create a Relationship

Types of Relationship

how to Create a relationship

set a rule for Referential Integrity

change the join type

delete a relationship

save relationship

Queries & Filterdifference between queries and filter

What is Query

filter using multiple fields AND, OR

advance filter Queries

create Query with one table

 select query

find duplicate record with query

find unmatched record with query

run query

save and change query

UNIT–IV

4. Working with Forms

UNIT–V

5. Working with Reports

 

Download our Android App

Computer Hindi Notes Android App

Latest update on Whatsapp

अति आवश्यक सूचना

यदि आपको कंप्यूटर विषय से सम्बंधित कोई नोट्स नहीं मिल रहे हैं तो हमें सूचित करें

Request Form / निवेदन फॉर्म 

जिनके नोट्स बन गए हैं वो अपने नोट्स नीचे दी गयी लिंक पर क्लिक करके देख सकते हैं
Requested notes / अनुरोध किए गए नोट