navleft
navright
undernavleft
 
undernavright
lnavl
Career
lnavr
   
lnavl
Courses
lnavr
Project Management Professional
   
lnavl
Partners
lnavr
 
 
 
 
 
 
 
 

 

Module 3:      Microsoft Access - 1 Week (14 hours)
  • Introduction to the MS Access Tutorial
    • Intended Audience
    • Pre-Requisite Knowledge
  • Brief overview of Relational Databases and Database Applications
  • A Business Example
  • Starting Microsoft Access
    • Review of Starting Microsoft Access
  • Creating and Viewing Tables
    • Creating a Table Using the Design View
    • Exercise: Creating a Table
    • Viewing and Adding Data to a Table
    • Exercise: Adding Data to a Table
    • Creating Relationships Between tables
    • Review of Creating and Viewing Tables
  • Creating and Running Queries
    • Single Table Queries
    • Exercise: Single Table Queries
    • Multiple Table Queries
    • Exercise: Multiple Table Queries
    • Review of Creating and Running Queries
  • Creating and Running a Data Entry Form
    • Creating a Single Table Form using the Wizard
    • Exercise: Creating a Single Table Form
    • Review of Creating and Running a Data Entry Form
  • Creating and Running a Report
    • Creating a Single Table Report using the wizard
    • Exercise: Creating a Single Table Report
    • Review of Creating and Running a Report
  • Summary
  • Interview questions and answers discussion
  • Written test
  • Oral presentation test

Back to Course Module Previous Module Next Module


© 2009 PeopleNTech, All Rights Reserved