Corporate Training in MS Access

COMPUFIELD® Computer Institute
In Mumbai

Price on request
You can also call the Study Centre
22236... More
Compare this course with other similar courses
See all

Important information

Description

Important information
Venues

Where and when

Starts Location
On request
Mumbai
OPriya Bldg.,1st Floor, Dr. Peter Dias Road, Near Mehboob Studio,, 400050, Maharashtra, India
See map
On request
Mumbai
Chinoy Mansion, First Floor, Block #2, Opp. St.Stephen's Church, Warden Road,, 400036, Maharashtra, India
See map

Course programme

Module 1: Introduction to MS-Access 2003

Getting Started
Creating a Database

Module 2: Creating tables

Data types and sizes
Field properties
Creating indexes
Entering data
Editing and deleting data
Datasheet view and from view

Module 3: Creating tables

Copying and moving data
Sorting data
Creating filters on data
Specifying relationships between tables

Module 4: Creating simple queries using QBE grid

Queries involving multiple tables
Creating lookup queries

Module 5: Prompting for selection Criteria

Using totals, averages, and other calculations
Creating crosstab queries
Action queries

Module 6: Creating simple forms using Form Wizards

Main/sub forms

Module 7: Introduction to macros

Creating and runing simple macros
Attaching macros to forms

Module 8: Creating reports

Single-column reports
Tabular reports
Mailing label reports
Creating summary reports
Creating groups / totals reports
Creating a Word Mail Merge report

Module 8: Creating graphs from your data

Importing data from Excel and other data sources
Exporting data to Excel and other formats

Compare this course with other similar courses
See all