CLASSROOM
TENTATIVE

SCHEDULES


Feb 10, 2018 9:00 am 18:00 pm
REGISTER NOW

MICROSOFT

BASIC MS ACCESS 2013

DESCRIPTION
After maximizing the functionality of MS Excel, you may want to explore MS Access as your database
COURSE CONTENT

Module I : Understanding Databases

  • Access Components Overview
  • Creating Databases

Module II : Creating Tables

  • Design View and Data Types
  • Field Properties
  • Establishing Relationships
  • Creating Lookup Fields

Module III : Creating Queries

  • Basic Queries
  • Filtering with Criteria
  • Expressions, Totals, and Concatenating
  • Action Queries
  • Special Select Queries with Wizard

Module IV : Creating Forms and Reports

  • Forms Wizard
  • Reports Wizard
  • Customizing Report Controls

 Module V. More Database Features

  • Importing and Exporting Data
  • Linking Data to an Access Table
  • Linked Table Manager