Jajoo-AMA Centre for
Entrepreneurship in IT

 

Basic Course in
Database Management System
(DBMS)

Saturday & Sunday, July 24 & 25, 2010
10.00 a.m. to 5.00 p.m.

 

Venue :
Torrent-AMA Management Centre,
Core-AMA Management House, AMA Complex,
Dr. Vikram Sarabhai Marg, Vastrapur, Ahmedabad 380 015

 

 

Data is a vital wealth for a corporate sector. More important factors with data are properly arranged and secured storage of data, timely retrieval of data, and availability of data in the required format. For these, Data Base Management Systems (DBMS) are used.

 

The present course is aimed to give a basic idea about DBMS and hands-on-experiments using one of the widely used DBMS MS-ACCESS.

 

After finishing the course, participants will be able to know: -

 

• What is database and basic components of database?
• How DBMS is used?
• How DBMS works as Back-End in an automated environment?
• What are the various DBMS packages?
• How MS-ACCESS is used as DBMS?
• What are basic operations in MS-ACCESS?
• How to design Tables in MS-ACCESS?
• How to create and run SQL queries in MS-ACCESS?
• How to prepare Data Entry form?
• How to generate Reports?

Topics Covered:
• Getting started
• Database concepts
• Exploring the Access environment

• Getting help
• Databases and tables
• Planning and designing databases
• Exploring tables
• Creating tables
• Fields and records
• Changing the design of a table
• Finding and editing records
• Organizing records
• Data entry rules
• Setting field properties
• Working with input masks
• Setting validation rules
• Basic queries with SQL queries
• Creating and using queries
• Modifying query results and queries
• Performing operations in queries
• Using forms
• Creating forms
• Using Design view
• Sorting and filtering records
• Working with reports
• Reports
• Modifying and printing reports

 

 

Fee:

 

Rs.1500/- per participant. Batch size - limited to 20. (Concession for members 10%, Patron 20%). The cheque may please be drawn in the name of ‘Ahmedabad Management Association’.

Registration :
Please send your registration along with participation fee to:

Executive Director,
Ahmedabad Management Association,
ATIRA Campus,
Ahmedabad 380 015.
Ph: 26308601-6 Fax: 26305692
E-mail: amaahd@gmail.com

 

For Registration Forms Click Here (Email it or Fax it with Your Information)