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