Microsoft Access Introduction Duration: 1 Day

Course Overview

This course offers a good grounding in creating the core objects of a database and covers data manipulation and extraction at an introductory level. Target student: People who intend to design databases from scratch or improve existing Access database skills. Introduction

• Access basics
• The different database objects
• Finding your way around the navigation pane
• Planning your database

Tables

• Working with records
• Working with columns
• Field Properties
• Creating tables with Table Design
• Relationships between tables

Queries

• Advanced filters
• Creating Simply Queries
• Creating Parameter and Complex Queries
• Using Queries instead of using Calculated fields

Forms

• Using a form
• Form filters
• Create new forms using Form design and Form Wizard

Reports

• Working with reports
• Create a report with report wizard
• Tabular Reports

Action Queries

• Make Table Query
• Delete Query
• Append Query
• Update Query

Others

• Date Formatting
• Number Formatting
• Input Masks
• Validation
• Creating Tables from Text/CSV files.