MS Access 2007 - Training Programme
Database Terms : Understand database terms like Table, Query, Record set, Report.
Creating Databases : Learn to create New database, database templates, working on existing databases.
Creating tables : Table views, Design view, Datasheet view, Adding new fields, Data types.
Managing tables : Tables are building blocks of databases. Learn to Delete a table, Rename a table, Add a description to a table.
Understanding Keys : Keys are important aspects of a Database. Understand what is Primary Key, Composite Key & Foreign Key.
Table Relationship : One to one, One to many, Creating table relationships, Print a table relationship.
Managing data : Data management requires lot of understanding of database concepts. We will teach you combination of theoretical and practical aspects to manage your data and databases. Add records to a table, Find & replace, Totals, Sort records, Filter.
Querying a database : Learn Structured Query Language part of MS Access. Queries are important to fetch data from large databases, from pools of data to meet reporting requirements. Query wizard, query design feature, Query criteria.
Calculated fields : Expressions, Zoom.
Designing forms : Form views, Create a form, Form wizard.
Generating reports : Report views, Create a report, Report wizard, Custom calculated fields.
Printing reports : Understand what are default and customized reports available in Access. You can Print those report, can view of your screen, customize the standard reports etc.
Pricing Details: Rs. 6,000/- Per Person.