Microsoft Office Series:

Microsoft Office Access 2007 (Access07)

Most organizations maintain and manage large amounts of information. One of the most efficient and powerful ways of managing data is by using relational databases. Information can be stored, linked, and managed using a single relational database application and its associated tools. In this course, you will examine the basic database concepts, and create and modify databases and their various objects using the Microsoft® Office Access™ 2007 relational database application.

 

Target Audience

This course is designed for students who wish to learn the basic operations of the Microsoft Access database application to perform their day-to-day responsibilities, and to understand the advantages that using a relational database application can bring to their business processes. The Introduction course is for the individual whose job responsibilities include designing and creating new databases, tables, and relationships; creating and maintaining records; locating records; and producing reports based on the information in the database.

Prerequisites

Access 2007: Basic or equivalent experience

 

Students should have completed the following courses or possess equivalent knowledge before starting this course:
Windows XP: Introduction

Windows Vista: Introduction

 

Module

Managing Databases using Microsoft Access 2007.

 

16 Hours

Rs. 5,000.00

 

Topics

 

Getting started

 Database concepts

 Exploring the Access environment

 Getting help

Using forms

 Creating forms

 Using Design view

 Sorting and filtering records

 

Advanced form design

 Adding unbound controls

 Adding Graphics

 Adding calculated values

 Adding combo boxes

 Advanced form types

Databases and tables

 Planning and designing databases

 Exploring tables

 Creating tables

Working with reports

 Reports

 Modifying and printing reports

Reports and printing

 Customized headers and footers

 Adding calculated values

 Printing

 Labels

Fields and records

 Changing the design of a table

 Finding and editing records

 Organizing records

Relational databases

 Database normalization

 Relating tables

 Implementing referential integrity

Charts

 Charts in forms

 Charts in reports

 

Data entry rules

 Setting field properties

 Working with input masks

 Setting validation rules

Related tables

 Lookup fields

 Modifying lookup fields

 Subdatasheets

PivotTables and PivotCharts

 PivotTables

 Modifying PivotTables

 PivotCharts

 PivotTable forms

Basic queries

 Creating and using queries

 Modifying query results and queries

 Performing operations in queries

Complex queries

 Joining tables in queries

 Calculated fields

 Summarizing and grouping values