MS Access

UNIT–I
Introduction to database – What is a Database
Why use a Relational Database
Concept of primary key relationship
Introduction to MS Access (Objects, Navigation).
UNIT–II
Create a Table in MS Access
Data Types
Field PropertiesFields names, types, properties – default values, format, caption
validation rules Data Entry
Add record
delete record and edit text
Sort
find/replace
filter/select
rearrange column
freeze columns
Edit a Tablescopy, delete, import, modify table structure.
UNIT–III
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.
UNIT–IV
Introduction to Forms, Types of Basic FormsColumnar, Tabular, Datasheet, Main/Sub- forms. 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.
UNIT–V
Introduction to Reports
Types of Basic ReportsSingle Column, Tabular Report, Groups/Total, single table report, multi table report, preview report print report, Creating Reports and Labels Wizard.

Subscript to our Whatsapp Broadcast List

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

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

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

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