Search for Training

MicroSoft Access Expert

Course Overview


You have worked with Microsoft Office PowerPoint 2003 (or earlier) to create presentations. PowerPoint or later versions, with its redesigned interface, enhanced features, and results-oriented authoring tools, improves the process of creating dynamic presentations. In MS PowerPoint Expert course, you will work with the new and enhanced features available in Microsoft Office PowerPoint . Students enrolling in MS PowerPoint Expert course should understand how to use a version of PowerPoint, preferably 2003 or XP, and have some familiarity with the Internet. MS PowerPoint Expert course covers the commonly used new features for a typical user.

Course Content


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 2007 PRINTING ISSUES

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

Customer Reviews


Thanks to Xpertised and the tutor who walked me through all the topics with Practical exposure which is helping me in my current project.
-Waseem

Course was quite helpful in terms of understanding of concepts and practicality. Its really a very friendly environment to learn. The timing were mutually chosen, as we both are working professional. I am quite satisfied with the course.
-Tanmoy

...more
Share:

For Batch Details
Call us at: +91 7259222234

Not sure? Consult Our Experts

What is the sum of 5 + 4? (security question)

Looking for a Training for

Myself

My Team/Organization

I agree to be contacted over mail or phone

or
Call us at: +91 7259222234

Subscribe to our weekly newsletter