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 Properties-Fields names, types, properties – default values, format, caption
validation rules Data Entry
Add record, delete record and edit text
Sort
find/replace
filter/select
rearrange columns,
freeze columns
Edit a Tables- copy, 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 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.
UNIT–V
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.