INTRODUCTION

• Overview
• Architecture

RDBMS  

• Overview
• Data Defniition
• Data Manipulation
• Data Control

OBJECTS  

• Table
• Queries
• Forms
• Reports
• Macros
• Modules

WORKING WITH DATA BASES  ✓ Creating Database

• Data Types in MS Access
• HTML Attributes
• Creating Tables
• Adding, Editing and removing and viewing data
• Filtered Views

QUERIES  

• Introduction
• Select Query
• Setting Criteria
• AND , OR , NOT , IN, NOT IN Operators
• Calculated Expressions as fields
• Action Queries
• Parameterized Queries
• Aggregate Functions
• Pattern Searching Queries
• Duplicate Query Wizard
• Unmatched Query Wizard
• SQL Commands (DDL,DML,TCL)
• SQL Views

DATA GROUPING AND ORDERING  

• Grouping single fields
• Grouping Multiple fields
• Using Aggregate Functions with groups
• Sorting the data
• Sorting Data on Multiple fields
• Sorting and Grouping

DATA RELATIONSHIPS

• Data Normalization
• Data Relationships
• One-to-Many Relationships
• Many-to-Many Relationships
• One-to-One Relationships

INDEXES  

• Simple Index
• Indexing multiple fields
• Composite Indexes

DATA VALIDATION (CONSTRAINTS)  ✓ Introduction

• Primary Key (Auto Increment Column)
• Composite Primary Keys
• Unique
• Not Null
• Default Values for Fields
• Check Constraints
• Check Constraints on multiple fields
• Foreign Key Constraint

FORMS

• Introduction
• Bound Forms
• Unbound Forms
• Creating Forms using Wizards
• Creating form using Design View
• Multiple Forms
• Split Forms
• Master-Detail forms
• Form Components

REPORTS  

• Introduction
• Creating reports using wizards
• Creating Reports using Design Views
• Applying criteria on Reports
• Parameterized Reports
• Master-Detail Reports

MACROS  

• Introduction
• Creating MACROS ✓ Running MACROS

IMPORTING AND EXPORTING ✓ Introduction

• Importing data from Excel
• Importing data from CSV
• Exporting Data to Excel
• Exporting Data to CSV file