Microsoft Access 2010 Training (Introduction Level)

Other levels, years and dates are available upon request


Overview

 

This course is designed for delegates who wish to gain a basic understanding of the principles of a database using Microsoft Access. Access is a very powerful tool which allows the user to create tables, queries and reports with ease.

 Key Topics

     Database Terminology

  • Terminology & Database Concepts

  • Database Structure

  • Working with Views

  • Backups

     

     Table Section

  • Creating, Viewing & Editing a Basic Table

  • Data Types

  • Field Properties

  • Formatting Data

  • Validations/Rules

  • Default Value

  • Primary Keys

  • Find & Replace

  • Sorting

  • Filter by Selection

  • Print Preview

  • Page Orientation

  • Headers & Footers

 

     Query Section

  • Creating a Simple Query

  • Filtering Options

  • And, Or, Like, Null

  • Greater Than, Less Than

 

     Forms Section

  • Creating/Designing a Basic Form

  • Calculated Fields

  • Printing Forms

 

     Reports Section

  • Designing & Modifying Reports

  • Grouping & Sorting

  • Printing Reports/Labels

     

     Importing/Exporting Data

  • Importing/Exporting/Linking Data

  • Price: £225.00
  • Duration: 1 Day
  • Start Time: 9.30am
  • End Time: 4.30pm

Dates available upon request.