Table creation using Design View and Wizard

Different data types in Access

Manipulation of data using Access facilities-Inserting,Updating, Deleting data

Creating Relationships between Tables

Form creation using Design View and Wizard

Query generation using Design View and Wizard

Report generation using Design View and Wizard

Concept of Workbook, Worksheet, Row, Column, Cell

Creating, Opening, Editing, Saving a Workbook

Changing Row and Column widths

Formatting cells

Different data types in Excel

Entering labels and values

Use of formulas – SUM, PRODUCT, AVERAGE, MAX, MIN, ROUND, COUNT, COUNTIF, CONCATINATE, AND, OR, NOT, RAND, SQRT, TDEVA

Copying Cells – Relative and Absolute referencing

Making calculations and re-calculations

Conditional Formatting

Sorting and Filtering Data

Hiding Rows and Columns

Use of Macros