MS Access (MO-500) Training Course and Workshop in Bangalore, Mysore, Chennai, Hyderabad, Pune, Mumbai, Delhi, Noida, Gurgaon, Kolkata

In MS Access - Essentials training course, you will examine the basic database concepts, and create and modify databases and your various objects using the MS Office Access relational database application.

In MS Access - Advanced (MO-500) training course, you will consider how to maintain data consistency, how to customize database components, and how to share Access data with other applications and extend your knowledge into some of the more specialized and advanced capabilities of Access by structuring existing data, writing advanced queries, working with macros, enhancing forms and reports, and maintaining a database.

By attending MS Access - Essentials workshop, delegates will:

Gain an understanding of database concepts and terminology
Learn about the Access interface
Learn to work with table views, queries, forms, reports, and macros and modules
Learn to plan a database
Learn database design fundamentals
Learn to work with forms and the Form Wizard
Learn to work with reports and the Report Wizard

By attending MS Access - Advanced (MO-500) workshop, delegates will learn to:

Modify the design and field properties of a table to streamline data entry and maintain data integrity
Retrieve data from tables using joins
Create flexible queries to display specified records, allow for user - determined query criteria,& modify data using queries
Enhance the capabilities of a form
Customize reports to organize the displayed information and produce specific print layouts.
Share data across different applications
Restructure data into appropriate tables to ensure data dependency and minimize redundancy
Write advanced queries to analyze and summarize data
Create and revise Access macros
Display data more effectively in a form
Customize reports by using various Access features, thus making them more effective
Maintain database using tools provided by Access
Study about access printing issues

MS Access - Essentials class is designed for those who wish to learn the basic operations of the MS 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. This fundamentals course is for the individuals 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.

MS Access - Advanced (MO-500) class is designed for those individuals whose job responsibilities include working with related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance. It is also designed as one in a series of courses for those pursuing the MS Office Specialist Certification for MS Office Access.

Exploring The Ms Office Access Environment

Examine Database Concepts
Exploring the User Interface
Use an Existing Access Database
Customize the Access Environment
Obtain Help

Designing A Database

Describe the Relational Database Design Process
Define Database Purpose
Review Existing Data
Determine fields
Group Fields into Tables
Normalize Data
Designate Primary and Foreign Keys
Determine Table Relationships
Setting rules to ensure valid relationship

Building A Database

Create a Database
Create a Table
Manage Tables
Create a Table Relationship, Delete and Apply rules
Save a Database as a Previous Version

Managing Data In A Table

Modify Table Data
Sort Records, Add, Delete Records
Navigate within table
Define key, primary key , Indexing
Creating one to one to many relations
Work with Subdatasheets

Querying A Database

Filter Records, Navigate Records
Form headers footers
Create a Query
Add Criteria to a Query
Add a Calculated Field to a Query
Perform Calculations on a Record Grouping
Use two table queries
Using operators within queries
Editing, running and deleting a query
Saving and closing a query

Designing Forms

View Data Using an Access Form
Create a Form
Modify the design of a Form

Generating Reports

View an Access Report
Create a Report
Add a Custom Calculated Field to a Report
Format the Controls in a Report
Apply an AutoFormat Style to a Report
Prepare a Report for Print

Controlling Data Entry

Restrict Data Entry Using Field Properties
Establish a Pattern for Entering Field Values
Create a List of Values for a Field

Joining Tables

Create Query Joins
Join Unrelated Tables
Relate Data Within a Table

Creating Flexible Queries

Set Select Query Properties
Create Parameter Queries
Create Action Queries

Improving Forms

Design a Form Layout
Enhance the Appearance of a Form
Restrict Data Entry in Forms
Add a Command Button to a Form
Create A Sub form

Customizing Reports

Organize Report Information
Format the Report
Set Report Control Properties
Control Report Pagination
Summarize Report Information
Add a Sub report to an Existing Report
Create a Mailing Label Report

Sharing Data Across Applications

Import Data into Access
Export Data
Analyze Access Data in Excel
Export Data to a Text File
Merge Access Data with a Word Document

Structuring Existing Data

Analyze Tables
Create a Junction Table
Improve the Table Structure

Writing Advanced Queries

Create Subqueries, edit run and delete query
Create Unmatched and Duplicate Queries
Group and Summarize Records Using Criteria
Summarize Data Using a Crosstab Query
Create a PivotTable and a PivotChart

Simplifying Tasks With Macros

Create a Macro
Attach a Macro
Restrict Records Using a Condition
Validate Data Using a Macro
Automate Data Entry Using a Macro

Making Effective Use Of Forms

Display a Calendar on a Form
Organize Information with Tab Pages
Display a Summary of Data in a Form

Making Reports More Effective

Include a Chart in a Report
Print Data in Columns
Cancel Printing of a Blank Report
Create a Report Snapshot

Maintaining An Access Database

Link Tables to External Data Sources
Manage a Database
Determine Object Dependency
Document a Database
Analyze the Performance of a Database

Access Printing Issues

Previewing a table, form or report
Changing orientation and paper size
Printing options within Access

Encarta Labs Advantage

One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
All courses are delivered by Industry Veterans
Get jumpstarted from newbie to production ready in a matter of few days

Trained more than 50,000 Corporate executives across the Globe
All our trainings are conducted in workshop mode with more focus on hands-on sessions

MS Access

COURSE AGENDA