Access

MICROSOFT ACCESS ( 1 Day )

COURSE OVERVIEW

Microsoft Access helps you analyze large amounts of information, and manage related data more efficiently than Microsoft Excel or other spreadsheet applications. Access is a Relational Database Management System or RDBMS that is used to create tables where data can be stored and related to each other.

COURSE CONTENT

Database Overview

What is a database?

Creating a database

Tables – Exploring design view

Forms

Basic form controls

The Form Wizard

Advanced form controls

Formatting the form and form controls

Queries

Basic queries

The Query Wizard

Make tables

Update queries

Append queries

Delete queries

The SQL View

Reports

Organizing report data

Formatting reports

Report forms