MS Access

Introduction to database -What is a Database
Why use a Relational Database
concept of primary key relationship
Introduction to MS Access (Objects, Navigation).
Create a Table in MS Access
Data Types
Field Properties-Fields names, types, properties – default values, format, caption
validation rules Data Entry
Add record, delete record and edit text
rearrange columns,
freeze columns
Edit a Tables- copy, delete, import
Modify table structure
Add a relationship
set a rule for Referential Integrity
change the join type
delete a relationship
save relationship Queries & Filter
difference between queries and filter
filter using multiple fields
Create Query with one table
find record with select query
find duplicate record with query
find unmatched record with query
run query
save and change query.
Introduction to Forms
Types of Basic Forms – Columnar, Tabular, Datasheet, Main/Subforms.
add headers and footers
add fields to form
add text to form use label option button
check box
combo box
list box Forms Wizard
Create Template.
Introduction to Reports
Types of Basic Reports – Single Column, Tabular Report, Groups/Total, single table report, multi table report, preview report print report
Creating Reports and Labels Wizard.

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

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

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

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

CPCT Computer Objective Questions