MS Access

Introduction to Database

Database
RDBMS
Object of RDBMS

Introduction to Access
Access
Getting Started
Creating New and Opening Existing Database
Creating DB using Database Wizard
Creating DB without using Database Wizard

Tables
Introduction to table
Creating table
Table in design view*
Working on tables*
Description of design view
Properties of fields
Primary Key
Switching view
Entering data
Manipulation data
Relationships

Handling Queries
Introduction to query
Creating a query in design view*
Query wizards*
Finding duplicate query

Forms
Creating form by using Wizard*
Creating form by design view*
Adding Records using A form
Editing Forms
Form Control
Command Buttons*

Reports
Report using the Wizard*
Creating report in Design view
Printing Reports

Importing exporting
Importing
Exporting
Linking

Sorting and Filtering
Introduction
Sorting
Filter by Selection
Filter by Form
Saving a Filter

Keyboard Shortkeys
How to install MS-Access

* Indicates the Animated Presentation.