"A Training Solution Provider delivering Learning Skills to keep forever"

Call the JCS training team free now 0800 5425 150 Or mail Email | training@jcstraining.com

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.