Microsoft Office Series:
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 AudienceThis 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. |
PrerequisitesAccess 2007: Basic or equivalent experience
Students
should have completed the following courses or possess equivalent
knowledge before starting this course: |
|
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 |