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
Field Properties-Fields names, types, properties – default values, format, caption
validation rules Data Entry
Add record, delete record and edit text
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
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
list box Forms Wizard
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.