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
  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 0722
    • +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