MS ACCESS WITH SQL

Introduction

Understanding Database Terminologies

DBMS & RDBMS

Normalization,

Data Integrity, Database Relationship

Understanding Screen Layout

Creating a Database

Data Import & Export from Various Data sets

Getting Started

File Menu Tab

The Ribbon

Quick Access Toolbar

Customize

Options

General

Current Database

Datasheet

Object Designers

Proofing

Client Settings

Customize

Database Terms

Table

Query

Recordset

Form

Report

Creating a New Database

New Database Database Templates

Working with Table

Table Views

Adding New Fields

Data Types

Editing Data Types in Fields

Creating, Save, Rename Table

Understanding Various Data types

Setting field properties

Setting Field properties & Validation Rules

Modify Table Structure

Keys

Primary Key

Composite Key

Foreign Key

Table Relationships

One-to-One Relationship

One-to-Many Relationship

Creating a Table Relationship

Print a Table Relationship Report

Managing Data

Add Records to a Table

Find and Replace

Totals

Sort Records

Filter

Understanding SQL

DML (Data Manipulation Language)

DDL (Data Definition Language)

Querying a Database

Query Wizard

Query Design Feature

Query Criteria

Writing Queries using SQL & Design View

Using WHERE, GROUP, ORDER BY, HAVING

Different Types of JOINS

Creating a Multiple Table Query

Expressions & Expression Builder

Using an IIF Function

Displaying Top or Bottom Values

Crosstab & Parameter Queries

Make-Table, Delete, Append, Update Queries

Calculated Fields

Expressions

Zoom

Designing Forms

Form Views

Create a Form

Form Wizard

Generating Reports

Report Views

Create a Report

Report Wizard

Custom Calculated Fields

Print a Report

Print a Report