Online And Sort Data eLearning

Word XP Proficient Expert Word XP Proficient & Expert Microsoft DiscoverWare's Discover Word XP is an interactive productivity tool for users of Microsoft Word XP. Word XP builds on the word processing features of previous versions of the program to provide powerful tools for creating and sharing professional documents online and on the Web. Topics cover word processing concepts, document and file management, editing and  more...

Access 2002 Advanced Access 2002: Advanced Microsoft Lesson 1: Sharing Data Introduction Lesson Objectives Opening Access Opening The Northwind Sample Database Exporting Data Viewing Exported Data Exporting Data In HTML Format Opening An HTML File Sharing Reports Emailing A Report The Snapshot Viewer Viewing An Attachment Printing A Report Creating Backward Compatible Databases Renaming A Database  more...

Access 2002 Intermediate Access 2002: Intermediate Microsoft Lesson 1: The Access Interface Introduction Lesson Objectives Opening Access Opening The Northwind Database Customizing The Interface Creating A New Folder Other Options Changing The Default Database Folder Specifying Keyboard Behavior Setting Default Field Types & Sizes Creating A New Database Opening A Table Using Find Search Options Using  more...

Access 2002 Basic Access 2002: Basic Microsoft Lesson 1: The Access Interface & Database Objects Introduction Lesson Objectives About Databases Access Database Files Opening Access The Title Bar The Menu Bar The Ask A Question List Box The Database Toolbar The Task Pane Navigating Between Task Panes The Clipboard Task Pane The Basic & Advanced Search Task Panes Closing The Task Pane The Status  more...

Excel 2002 Basic Excel 2002: Basic Microsoft Lesson 1: The Excel 2002 Interface Introduction Lesson Objectives Opening Excel About Workbooks The Title Bar Menu Bar Overview Standard Toolbar Overview Formatting Toolbar Overview Displaying Other Toolbars Repositioning A Toolbar Docking A Toolbar Hiding A Toolbar Overview Of Task Panes Switching Between Task Panes Hiding The Task Pane Showing The  more...

Word 2002 Advanced Word 2002: Advanced Microsoft Lesson 1: Building Tables & Charts Introduction Lesson Objectives Opening Word The Task Pane Inserting Headers & Footers Inserting A Picture In A Header Formatting Text In A Header Defining A Style The Style & Formatting Task Pane Switching Between Headers & Footers Inserting Text In A Footer Inserting Page Numbers Inserting A Section Break Creating  more...

Discover Access 2007 Level 2 ... 2. SORT, RETRIEVE, AND ANALYZE DATA Find And Sort Data Find A Record Sorting Records Perform An Advanced Sort Work With Filters What Is A Filter? Apply & Remove Filters Use Queries To Retrieve Data Creating & Saving Queries Multi-Table Queries Create A Select Query Add A Calculated Field To A Query  more...

Discover Excel 2007 Level 4 Discover Excel 2007: Level 4 Microsoft Discover Excel 2007 from Technology Skills is a rich, multimedia learning tool for users of Microsoft Excel 2007. Excel 2007 builds on the spreadsheet capabilities of previous versions of the software program to provide powerful tools for creating and sharing professional worksheets through a fresh and efficient new look. Topics cover basic spreadsheet  more...

Outlook XP Proficient Expert Outlook XP Proficient & Expert Microsoft DiscoverWare's Discover Outlook XP is an interactive productivity tool for users of Microsoft Outlook XP. Outlook XP is a desktop information management program that combines e-mail, scheduling features, task management, and contact management. Outlook XP also contains collaboration tools, so information can be shared more effectively. Outlook XP /  more...

Access XP Proficient Expert Access XP Proficient & Expert Microsoft DiscoverWare's Discover Access XP is an interactive productivity tool for users of Microsoft Access XP. Access XP builds on the database capabilities of previous versions of the program to provide powerful tools that enable you to organize and manage database information as well as create your own custom applications. Topics cover basic database concepts  more...

Cisco CVOICE 8 0 Congestion Rate Limiting AutoQos Cisco CVOICE 8.0: Congestion, Rate Limiting & AutoQos Cisco CCNP Voice (formerly known as CCVP) 642-437 Implementing Ciso Voice Communications and QoS v8.0 (CVOICE v8.0) Queuing algorithms are one of the primary ways to manage congestion in a network. Network devices manage an overflow of arriving traffic by using a queuing algorithm to sort traffic and determine a method of prioritizing the  more...

Using Tables Charts and Graphics in Word 2007 Using Tables, Charts, and Graphics in Word 2007 Microsoft By using the tabular and charting utilities of Microsoft Office Word 2007, you can format, sort, and analyze your data with ease. In Word 2007, you can insert a table by selecting its layout from a list of preformatted tables, or by selecting the number of columns and rows that you require. You can insert a table into your regular  more...

Advanced Data Management in Excel 2007 Advanced Data Management in Excel 2007 Microsoft Excel 2007 provides multiple features for organizing and managing data, so you can ensure data is entered correctly and that calculations and formulas are valid. Data organization features enable you to sort, filter, and group and outline data so that you can focus on the key parts of your data. Validation features ensure that data is correct,  more...

Queries and Reports in Access 2007 Queries and Reports in Access 2007 Microsoft Queries and reports are used in Access 2007 to convert data into useful information and are an essential part of any database application. Access 2007 has a Query Wizard which simplifies the process of formulating a query and provides various methods of creating reports to present summarized information easily and effectively. This course explores  more...

Performing Advanced Query Techniques in SQL Server 2008 Performing Advanced Query Techniques in SQL Server 2008 Microsoft Microsoft Certified Technology Specialist SQL Server 2008, Database Development (Exam 70-433) Transact-SQL offers advanced query techniques, such as built-in aggregate, scalar, and ranking functions, and common table expressions to manipulate the result set for a query. To manipulate the result sets and generate rollup  more...

Excel 2000 This course begins by introducing students to the basic features of Microsoft Excel 2000, including entering text and formulas, moving data, formatting worksheet appearance, and manipulating charts. As students become more advanced, they will be able to work with records and ranges, sort records, outline and filter lists, and import and export data. This course familiarizes students with the  more...

Excel 2000 Expert Students will learn how to apply the advanced features of Microsoft Excel 2000 to work with records and ranges; sort, outline, and filter lists; import and export data; use PivotTables, PivotCharts, and data analysis tools; as well as how to merge and link workbooks. Students will learn how to apply the advanced features of Microsoft Excel 2000 to work with records and ranges; sort, outline, and  more...

Excel 2000 Level 3 Students will learn how to apply the advanced features of Microsoft Excel 2000 to work with records and ranges, sort records, outline and filter lists, and import and export data. The importance of proper management and password protection is also stressed. Students will learn how to apply the advanced features of Microsoft Excel 2000 to work with records and ranges, sort records, outline and  more...

Excel 2000 MOUS This course familiarizes students with many features of Microsoft Excel 2000, including entering text and formulas, moving data, formatting worksheet appearance, and manipulating charts. Students will also be able to apply the advanced features of Excel 2000 to work with records and ranges; sort, outline, and filter lists; and import and export data. This course familiarizes students with many  more...

Office 2000 Advanced In this course, students will learn how to use the advanced features of Microsoft Word, Excel, Access, and PowerPoint 2000, as well as a section on business writing. This advanced level course introduces the accomplished user to the most powerful aspects of these applications. It also strives to help the professional become a more effective writer. In this course, students will learn how to use  more...

Lean Manufacturing Personal Training Library The Lean Manufacturing Library gives one learner access to four core Lean Manufacturing courses: Lean Manufacturing, 5S ™s: Workplace Organization, 8D Problem-Solving, and Mistake-Proof It!. For a comprehensive understanding of the role statistics play in Lean Manufacturing, consider the Manufacturing Statistics Library as well. The Lean Manufacturing course provides a comprehensive  more...

Excel 2007 Level 2 This course familiarizes students with intermediate-level spreadsheet features. Students will learn how to convert older workbooks to the new default XML-based file format; customize the Quick Access toolbar; use logical and financial functions; format worksheets using themes, styles, and page breaks; use 3-D references; ready workbooks for the Web; use templates to create workbooks; and insert  more...

Access 2000 Expert 1. Access 2000 (Expert) Basics Work With Toolbars The Menu Bar & Other Toolbars Install Add-In Programs What Is An Add-In? Install & Load Add-Ins Unload Add-Ins Work With Previous Versions Of Access Access 2000 & Previous Versions Of Access Access 2000 & Access 97 Access 2000 & Access 95 Convert A Database Set Startup Options Set Startup Options Help In Access 2000 The Office Assistant Microsoft  more...

Microsoft Project 2003 Fundamentals This, the first of a two-part curriculum, covers fundamental Project 2003 skills used in the areas of Task, Calendar, and Outlining management, manipulation of data, views and reports, and project updating, tracking, and conflict resolution. Learn To: Match Microsoft Project 2003 products with their features. Identify component parts of the Microsoft Project 2003 interface.  more...

Crystal Reports v10 Introduction to Report Design Part 2 This course is the second in a three-part series that focuses on organizing and customizing your reports. This course covers the key concepts associated with grouping, selecting, and summarizing fields and data in Crystal Reports v10. In this course, you will also learn to modify settings and format reports. Learn To: Identify the options for creating and modifying a group in a  more...

SAP R 3 FI AR AP Account Document Posting and Periodic Processing Course Overview SAP's FI module is a powerful, integrated environment, dynamically interfacing Accounts Receivable/Payable functions with General Ledger and Assets Accounting. You will usually encounter both FI and CO (Cost Center Controlling) in a business environment. The procedures for Accounts Receivable and Accounts Payable are very similar in R/3. In this course you will learn to process  more...

Oracle SQL Specifics Retrieving and Formatting Data Course Overview This course is the first in a two-part series on Oracle SQL Specifics that will teach participants how to use commands, functions, and operators supported by Oracle as extensions to standard SQL. Students will be introduced to the Oracle implementation of the relational database management system (RDBMS) and the object-relational database management system (ORDBMS). Users will  more...

Oracle8 Performance Tuning Optimizing Sorts and Minimizing Contention Course Overview This course is the third in a three-part Oracle8 Performance Tuning series. This course introduces the participants improving performance for sort operations. The student will be able to identify the SQL operations that require sorts, ensure that sorting is done in memory where possible, use direct writes for large sorts and allocate temporary space appropriately. The student  more...

Word 2000 Proficient User Course Overview This course provides participants with the intermediate skills to use Microsoft Word 2000 on a daily basis in their workplace. At the completion of this course, students will learn to format and proof a document; enhance a document with drawing objects, charts, Clip Art, graphics and presentation enhancements; create a mail merge; and create envelopes and labels by merging an  more...

Word 2000 Expert User Course Overview This course provides participants the knowledge to use the advanced features of Microsoft Word 2000. At the completion of this course, students will learn to perform advanced text editing and handling operations; manage documents within a workgroup environment; and insert table of contents, cross-references and bookmarks in a document. L earn To: Perform advanced text  more...

Excel 2000 Expert User Course Overview This course provides participants the knowledge to use the advanced features of Microsoft Excel 2000. At the completion of this course, students will learn how to create and use templates; retrieve, sort and manipulate data from a list; create and modify shared workbooks; and analyze data by using Data Map, Pivot Table, Data Table Scenario and Data Analysis tools. L earn To:  more...

SQL Server 7 0 System Administration - Part 1 Course Overview This is the first course in a five part series that will provide students with the knowledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0. L earn To: Identify the main components of the SQL Server. Understand the properties of SQL Server Architecture, including the underlying technical details. Understand the components of  more...

Microsoft Works Suite 2005 Creating Databases This course helps the learner create databases by covering Works Database essentials such as working with databases, fields, records, forms, and reports. It also covers database fundamentals such as the Works Database interface and database views. Learn To: Identify components of the Works Database interface. Create a database from an existing template. Identify the steps to  more...

Access 2000 Fundamentals Course Overview This course is intended for end users who are looking to use the fundamental capabilities of Microsoft Access 2000. Participants will learn to identify the basic features of Access 2000; create and maintain tables; and work with Access 2000 data. L earn To: Identify the concepts related to databases and the features of Access 2000. Create and maintain tables and  more...

Access 2000 Expert User Course Overview This course provides participants the knowledge to use the advanced features of Microsoft Access 2000. At the completion of this course, students will learn how to create and refine queries; create, modify and enhance the forms in the Design view; create, modify and enhance reports; and secure and enhance the performance of an Access 2000 database. L earn To: Create  more...

SQL and PL SQL Basic SELECT Course Overview This course is the first in a three-part Oracle SQL series that is based on the ILT course Introduction to Oracle: SQL and PL/SQL. This course introduces the learner to Oracle relational database concepts and the use of SQL for storing, retrieving, and manipulating data in a relational database. This course covers relational database principles and Oracle concepts; writing basic  more...

Oracle8i Performance Tuning Optimizing Sorts Minimizing Contention Course Overview This course is the third in a three-part Oracle8i Performance Tuning series. This interactive course introduces the participants improving performance for sort operations. The student will be able to identify the SQL operations that require sorts, ensure that sorting is done in memory where possible, use direct writes for large sorts and allocate temporary space appropriately.  more...

Project 2000 Proficient User Course Overview This second course in the two-part series will add to the skills and knowledge gained in the first course. In this course, students will gain proficiency with Project Central, be able to customize a Project plan and use advanced functions. L earn To: Perform advanced functions to manage a project. Manage multiple projects, tasks, and resources. Create and applying a  more...

Oracle Database 10g New Features for Administrators Part 5 Oracle Database 10g is designed for enterprise grid computing. It is the most flexible and cost-effective way to manage enterprise information. Oracle Database 10g supports the Oracle vision of creating a self-aware, self-learning, and completely self-managing database. This course covers new features of Oracle Database 10g such as automatic storage management, upgrade methods, RMAN backup, flash  more...

Oracle SQL for End Users--Part 1 ... Add clauses to basic SQL SELECT statements to restrict and sort data retrieved by a query. Write SQL statements that contain a variety of single-row functions. C ontent Emphasis Skills-Based A udience End users are the targeted audience for this course. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Database Principles and Oracle Concepts  more...

Access XP Proficient User Course Overview This courses covers more advanced features of Access 2002. Individuals will learn how to make different types of data queries, work with forms and link data to other databases. Learn To • Create a single-table query in Design view. • Create a multiple-table query in Design view. • Create a simple query by using the Simple Query Wizard. • Identify  more...

Excel XP Expert User Course Overview This course covers skills particular to the expert user of Excel 2002. The course teaches template and database integration, shared workbooks, and consolidating data across workbooks. This course also teaches, Data Analysis and Automation, data importing and querying, pivot tables, macros, and data analysis tools. Learn To • Create a new template file. • Modify  more...

Word XP Proficient User Course Overview This course covers more advanced skills of working with documents in Word 2002. Learners will deal with document enhancement, table management, and column management. This course also covers visual enhancements including WordArt, graphics, and diagrams. Lastly, learners will cover mail merge and workgroup collaboration. Learn To • Insert page numbers into a document.  more...

Oracle9i Database Admin Manage an Instance Course Overview The Oracle9i Database Administration: Manage An Instance course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle9i. This course introduces the participants to the concepts and procedures associated with Oracle architectural components. The participants learn the various tasks of a database administrator that are  more...

Oracle9i Performance Tuning Optimizing Sorts Minimizing Contention The content of this course includes details about each component of an Oracle database instance, such as data blocks, disks, memory, CPU, and dynamic views. Students learn about migration and chaining, reorganizing indexes, optimizing sort operations, tuning rollback segments, managing automatic undo, monitoring activities, implementing the Oracle shared server, and troubleshooting. Learn To:  more...

MS Win XP Install Admin Part 3 TCP IP NOS Environments This is the third course in a five part series on the Microsoft Windows XP Installation and Administration curriculum. It introduces the concepts behind TCP/IP, and teaches how to support TCP/IP on computers running Microsoft Windows XP Professional. The course also covers the TCP/IP name resolution process, and provides an introduction to installing and configuring Internet Information Server,  more...

Oracle 9i New Features Database Administration This course introduces learners to the Oracle9i enhancements in server-side manageability, Oracle Enterprise Manager, and globalization. Learn To Identify memory and space management improvements. Describe segment and index management improvements. Identify improvements in database operations and performance.  more...

Works 2003 Creating Databases The Works 2003: Creating Databases course explores the database interface, and the student then learns about entering data, and database tables, and forms. Learn To Identify components of the Works Database interface. Create a database from a template. Identify options for creating a blank database.  more...

Windows 2000 Implementing Security Part 1 In this course, you are introduced to the basics of Windows 2000 security. The concepts of encryption and Public Key Infrastructure (PKI) are introduced. You are taught how to plan administrative access including remote administrative access. User account policies, software updates, and Remote Installation Services (RIS) are also covered. Learn To: • To  more...

Windows 2000 Implementing Security Part 1 In this course, you are introduced to the basics of Windows 2000 security. The concepts of encryption and Public Key Infrastructure (PKI) are introduced. You are taught how to plan administrative access including remote administrative access. User account policies, software updates, and Remote Installation Services (RIS) are also covered. Learn To: • To  more...

Windows 2000 Implementing Security Part 5 In this course, participants learn about policies and protocols used for remote access and Virtual Private Networks (VPN). How to secure communication channels including wireless networks is covered. Participants also learn about troubleshooting and responding to security incidents. Learn To: • To identify advantages of computer certificate  more...

Windows 2000 Implementing Security Part 5 In this course, participants learn about policies and protocols used for remote access and Virtual Private Networks (VPN). How to secure communication channels including wireless networks is covered. Participants also learn about troubleshooting and responding to security incidents. Learn To: • To identify advantages of computer certificate  more...

Access 2003 Fundamentals This course, along with the Proficient User course, maps to the Microsoft Office Specialist certification objectives for the Access 2003 Specialist exam. It presents the learner with the fundamentals of Microsoft Access 2003. The student learns how to create tables and relationships, how to manipulate tables, and how to create simple and advanced queries. Learn To  more...

Access 2003 Proficient User This course, along with the Fundamentals course, maps to the Microsoft Office Specialist certification objectives for the Access 2003 Specialist exam. Assuming knowledge of the fundamentals, it teaches how to create forms and reports and how to format controls on both forms and reports. The student is also introduced to importing and exporting data to and from Access. Finally, this course teaches  more...

Visual Basic 6 0 Designing Implementing Desktop Applications - Part 3 Course Overview This is the third course in a five part series that will provide students with the knowledge to write a Microsoft Visual Basic-based application that accesses data from a database. In this course, students will learn to use ActiveX Data Objects to access and manipulate data sources. This course also addresses advanced database issues, such as data integrity and referential  more...

CCNT Computer-Telephony Integration Essentials v6 0 This course introduces CTI and covers CTI architecture and CTI hardware. It also teaches CTI markets and CTI system development. Learn To: Identify features of the standard configuration of a Computer-Telephony Integration (CTI) system. Identify characteristics of call routing. Identify features of interactive voice processing. Identify uses of Computer-Telephony Integration  more...

Excel 2003 Fundamentals This course, along with the Excel 2003 Proficient User course, maps to the Microsoft Office Specialist certification objectives for the Excel 2003 Expert exams. Learners completing these courses should be well prepared for the certification exams, and have a solid foundation in basic Excel skills. Learn To To open a template-based workbook.  more...

Oracle Database 10g PL SQL Fundamentals Part 3 In this course, the learner will get familiar with the procedural language to access Oracle database. Students will learn to manage PL/SQL program units manage dependencies, manipulate large objects, and use some of the Oracle-supplied packages. The student will also learn about the compilation tools and their options. Learn To: Match the stages in the execution of SQL statements  more...