Course CatalogDemo CourseUpcoming CoursesTechnical SupportTraining Center   Back to Training Home


 Other Courses in the Curriculum
 Getting Started with Microsoft Office Access 2007
 Advanced Features of Microsoft Office Access 2007

Course Name Working with Microsoft Office Access 2007
Audience This course is designed for application developers and end users who desire to gain the necessary skills to create and manage a database by using Microsoft Office Access 2007. This course will also help them to understand the advantages that a relational database program can bring to their business processes.
Course Requirements You need Microsoft Internet Explorer 5.0 or above OR Netscape Navigator/Communicator 4.78 or above.

Plug-in Requirements
  ØMacromedia Flash plug-in for Windows for IE/NN
Pre-requisites The user should be familiar with the basics of the Microsoft Office suite and Windows 95/98/XP operating systems. They should have basic knowledge of relational database management systems.
Course Duration 3 hours
Course Objectives Working with Microsoft Office Access 2007 course covers the procedures to manage tables and reports. It also covers procedures for creating different types of queries and securing and validating data in a database.
Course Outline
  1. Managing Tables and Reports
    2.
    1. Managing Data in Tables
    2. Understanding Normalization and Table Relationships
    3. Creating Subreports and Labels
    4. Quiz
  2. Working with Queries
    3.
    1. Creating Simple Queries
    2. Creating the Crosstab, Parameter, and SQL Queries
    3. Finding and Deleting Duplicate Data
    4. Using Joins
    5. Creating Action Queries
    6. Quiz
  3. Validating and Securing Databases
    4.
    1. Validating the Data in a Database
    2. Securing a Database
    3. Do It Yourself
    4. Quiz