Basic MS Access 2013

Course Duration

8 hours, 1-day training workshop

Delivery

Face to face training or online training

Regular Price

Php 3, 500 VAT inclusive (price may change depending on headcount and venue)

Course Inclusive

Training materials & certificate of completion

Description

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

Course Content

Module I: Understanding Databases
  1. Access Components Overview
  2. Creating Databases
Module II: Creating Tables
  1. Design View and Data Types
  2. Field Properties
  3. Establishing Relationships
  4. Creating Lookup Fields
Module III: Creating Queries
  1. Basic Queries
  2. Filtering with Criteria
  3. Expressions, Totals, and Concatenating
  4. Action Queries
  5. Special Select Queries with Wizard
Module IV: Creating Forms and Reports
  1. Forms Wizard
  2. Reports Wizard
  3. Customizing Report Controls
More Database Features
  1. Importing and Exporting Data
  2. Linking Data to an Access Table
  3. Linked Table Manager
    • Makati
    • +63 2 8891 0713
    • +63 2 8751 6482

    • Intramuros
    • +63 2 8524-5572
    • Intramuros
    • 658 Muralla St., Intramuros, Manila 1002, Philippines


    • Makati
    • 333 Sen. Gil Puyat Ave., Makati City 1200, Philippines