MicroSoft Access Expert

Have Queries? Ask us +91 72592 22234

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

Looking for a Training for

Myself

My Team/Organization

I agree to be contacted over mail or phone

or
Call us at: +91 7259222234