Online An Existing Database eLearning

Access 2002 Basic ...orting Objects Introduction Lesson Objectives Opening An Existing Database Open Options Customizing The Interface Customizing The Interface Displaying Shortcut Keys The Options Dialog Box The Recently Used File List Removing Personal Information Setting Click Options The AutoForm Feature Naming A Form The Form Wizard Form Layouts Form Styles Entering A Form Title Deleting A  more...

Discover Access 2007 Level 1 ...hat Is A Database? Creating A New Database Open An Existing Database Customize Access Access Options Customizing The Quick Access Toolbar Help In Access 2007 Microsoft Office Access Help Working In The Access Help Window Context Specific Help Office Diagnostics QUIZ 2. DESIGN A DATABASE  more...

Access 2000 User Series ...Introduction (26 Minutes) 1.1 Starting Access 1.2 Opening an Existing Database 1.3 The Access Desktop 1.4 The Database Window 1.5 A Preview of the Database Components 2.0 Working with an Existing Database (33 Minutes) 2.1 Viewing and Navigating Table Data 2.2 Editing Table Data 2.3 Adding Records to a Table 2.4 Selecting and Deleting Records 2.5 Find and Replace 2.6 Modifying the Appearance of  more...

Access 2000 Beginning ...Introduction (26 Minutes) 1.1 Starting Access 1.2 Opening an Existing Database 1.3 The Access Desktop 1.4 The Database Window 1.5 A Preview of the Database Components 2.0 Working with an Existing Database (33 Minutes) 2.1 Viewing and Navigating Table Data 2.2 Editing Table Data 2.3 Adding Records to a Table 2.4 Selecting and Deleting Records 2.5 Find and Replace 2.6 Modifying the Appearance of  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 Visio 2003 Expert User .... Link a shape in Microsoft Visio 2003 to a record in an existing database table. Create new master shapes from each record in a database table using the Database Wizard. Audience: This course is intended for personnel with significant prior experience; end users wishing to extend their skills in the areas of advanced diagram development and technical aspects of Microsoft Visio  more...

Visual InterDev 6 0 Planning a Web Application C ourse Overview This is the first course in a five part series that will help students prepare for the Microsoft Certified Professional exam 70-152, Designing and Implementing Web Solutions with Microsoft Visual InterDev 6.0. At the completion of this course, students will learn to plan a Web site; analyze the planning guidelines and the performance and maintenance factors that need to be  more...

Frontpage 2000 Expert User C ourse Overview This course prepares IT Professionals to create, organize and manage a Web using FrontPage 2000. L earn To: Import and modify an existing Web. Customize a FrontPage Web. Client-server interaction. C ontent Emphasis Skills-Based A udience This course is intended for end users using Microsoft FrontPage 2000. Participants should have a basic  more...

Oracle Database 10g Administration Workshop I Part 4 Learners will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Learners will also be taught about undo management, lock management, and backup and recovery techniques. Learn To: Identify benefits of undo data. Identify features of undo segments. Identify undo management tasks that a DBA should perform  more...

Oracle SQL and SQL Plus Advanced SELECT Statements Course Overview This course is the first course in a two-part series which covers advanced SQL and SQL*Plus. This course introduces the learner to the advanced SELECT statements and the use of subqueries in Oracle Statements. In addition, this course explores the functions used in Oracle and covers the use of set operators to combine two or more queries. L earn To: Write  more...

Oracle SQL and SQL Plus SQL Plus and Reporting Course Overview This is the second course in a two-part series which covers advanced SQL and SQL*Plus. This course introduces the learner to the fundamental concepts of SQL*Plus and queries using SQL*Plus runtime variables. In addition, this course explores saving customizations and enhancing query output. L earn To: Identify the fundamental concepts of SQL*Plus and write queries  more...

Oracle Form Builder Enhancing the User Interface Course Overview This course is the second in a six-part Oracle Form Builder series based on Oracle Developer/2000 Release 2. This course helps participants learn how to create input and non-input items, and support text items with Lists of Values (LOVs) and editors. Additionally, users will learn to create triggers and add functionality to them. L earn To: Create input and  more...

Oracle Report Builder Report Fundamentals Course Overview This course is the first in a three-part Oracle Report Builder series that is based on Oracle Developer/2000 Release 2. This course introduces the learner to the key features of Report Builder, building a standard tabular report, and report layout styles. In addition, this course will help participants learn how to use the Live Previewer, store reports, and migrate report  more...

Oracle8 Database Administration - Manage an Instance Course Overview This course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle8. In this course, participants will learn about the concepts and procedures associated with Oracle architectural components, using the database administration tools, managing an Oracle instance, and using National Language Support. L earn To:  more...

Oracle Form Builder R6 Enhancing the User Interface Course Overview This course is the second in a six-part Oracle Developer series based on Oracle Developer Release 6. This course describes how to create input and non-input items, how to create lists of values (LOVs) and editors to support text items, and how to create forms using multiple windows and a variety of canvas styles. Additionally, this course covers ways to add functionality to  more...

Oracle Reports R6 Report Fundamentals Course Overview This course is the first in a three-part Oracle Report Builder series that is based on Oracle Reports Release 6. This course introduces the learner to, the key features of Report Builder, steps involved in building a standard tabular report and report layout styles. In addition, this course will help participants learn how to use the Live Previewer, store reports, and migrate  more...

Oracle Reports R6 Enhance Reports Course Overview This course is the second in a three-part Oracle Reports series that is based on Oracle Reports Release 6. The goal of this course is to enable developers to construct complex reports and charts using Oracle Reports. This course introduces the learner to the key features of the Data Model editor, Layout Model objects and their properties. The course also enables the learner to  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 - Implementing a Database - Part 2 Course Overview This is the second course in a five part series that will provide students with the knowledge to to implement a database solution with Microsoft SQL Server 7.0. L earn To: Implement data integrity. Create and maintain indexes. C ontent Emphasis Skills-Based A udience This course is designed for IT professionals responsible for implementing a database  more...

Visual C 6 0 Designing Implementing Desktop Applications - Part 5 Course Overview This is the fifth course in an eight part series for programmers. This series provides the C++ programmers the necessary skills to develop applications using the MFC library and the Microsoft Visual C++ 6 development environment. L earn To: Store and retrieve data from a file and registry by using MFC. Implement remote communication by using the Socket and Serial  more...

IIS 4 0 Creating Configuring a Web Server - Part 3 Course Overview This is the third course in a four part series that will provide students with the knowledge to support the various features of Microsoft Internet Information Server 4.0. Participants will gain an understanding of the product's architecture and perform the procedures to install, configure, and implement Internet Information Server. L earn To: Create and interpret  more...

Frontpage 2000 Expert User Course Overview This course prepares IT Professionals to create, organize and manage a Web using FrontPage 2000. L earn To: Import and modify an existing Web. Customize a FrontPage Web. Client-server interaction. C ontent Emphasis Skills-Based A udience This course is intended for end users using Microsoft FrontPage 2000. Participants should have a basic  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 ...ess 2000 interface components with their functions. Open an existing database in Access 2000. Identify the functions of each Access 2000 database object. Identify the object views available in Access 2000. Print database objects. Create a new database in Access 2000. Access help on a specified subject by using the office Assistant. Unit 2: Access 2000 Tables Duration: 2 - 3 Hour(s)  more...

Windows 2000 Planning Implementing Active Directories - Part 1 Course Overview This is the first course in a four part series that will provide IT professionals with the knowledge and skills necessary to plan and implement Microsoft Windows 2000 Active Directory in an enterprise environment. At the completion of this course, students will learn to identify the key features and components of Active Directory; identify the physical structure and security  more...

Crystal Reports v10 Introduction to Report Design Part 1 This course is the first in a three-part series that focuses on the basics of reporting using Crystal Reports v10. This course introduces the user to Crystal Reports and its environment. It also covers the fundamentals of databases and the key concepts associated with relational databases. In this course, you will learn to plan, create, preview, save, and distribute reports. Learn To:  more...

SQL and PL SQL PL SQL Basics Course Overview This course introduces the learner to the basics of PL/SQL. The course builds the necessary skills for using Oracle PL/SQL. It will help the learner acquire the expertise to design, develop, and implement Oracle Server applications by using Oracle Structured Query Language (SQL) and PL/SQL. The learner is guided step-by-step through the various aspects of PL/SQL programming.  more...

SQL and PL SQL DML and DDL Course Overview This course is the third in a three-part Oracle SQL series that is based on the Oracle ILT course, Introduction to Oracle: SQL and PL/SQL. Using the Oracle SQL*Plus environment, this computer-based training course uses Structured Query Language (SQL) to create and populate Oracle database tables. Learners create tables and other database objects and learn to maintain and modify  more...

Oracle8i Database Admin Manage Data Storage Course Overview This course is the fourth in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course, participants will learn about the concepts associated with tables. In addition, this course will teach users about maintaining data integrity, clusters and index-organized tables, and methods for loading and reorganizing data. L  more...

Oracle8i Database Admin Manage Security Course Overview This course is the last in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course, participants will learn about the concepts and tasks associated with managing security. L earn To: Define and maintain the security domains for users in a given environment. Define and maintain a named set of resources and  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...

Access XP Expert User Course Overview This course covers the more complex aspects of working with data using Access 2002. Assuming the learner is already proficient in Access, the course covers advanced features of database queries, and enhancing forms and reports. Learn To • Create an update query. • Create a delete query. • Create an append query. • Create a form in Design view.  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...

Oracle9i SQL DML and DDL The Oracle SQL DML and DDL course is the third in a three-part series covering the Data Manipulation and Data Definition language statements supported by Oracle9i. This course introduces the participants to various objects in a database. The participants learn to create, update, and delete the database objects. The participants also learn to add rows, update, and delete existing rows from a table.  more...

Oracle9i Database Admin Manage Security Course Overview This course is the last in a five-part series covering the database administration strategies and procedures provided in Oracle9i. In this course you will learn the concepts and methods associated with implementing security and resource consumption in an Oracle9i database. Learn To • Define and maintain the five components of the security domain of a user in a given  more...

Moving from Technical Professional to Mgr Series Getting Started This course introduces the learner to some management fundamentals. Beginning with the requirements for IT success, the course outlines the roles of the IT manager as well as the skills required for effective management. It then teaches the principles of three types of management planning as well as the fundamentals of recruiting for new managers. Learn To: Identify key functional areas  more...

Visual Basic NET-Windows Development Curriculum The Microsoft Visual Basic .NET-Windows Development Curriculum introduces students to Microsoft.NET Framework Windows Forms and controls.It describes the various options for building your own controls and explains how to expand the functionality of existing controls. The student is taught how to use .NET and COM components of the Windows Forms application, and how to use the Reporting and Printing  more...

Visual Basic NET-Windows Development Part 2 This Course describes the various options for building your own controls. It explains how to extend the functionality of existing Windows Forms control, combine multiple existing controls into a composite control, and build a new custom control. It also covers how to add design-time attributes and licensing support to a control. Learn To: o To identify features of extended controls. o To  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 Server 2003 Managing Network Infrastructure Part 1 This is the first of a three-course curriculum that prepares the learner for Exam 70-291: Implementing, Managing, and Maintaining a Microsoft Windows Server 2003 Network Infrastructure. The learner is introduced to the course with a review of TCP/IP issues. The course then gives in-depth and exam-focused coverage to the areas of routing configuration, DHCP overview and configuration, and the  more...

Windows Server 2003 Managing Network Infrastructure Part 1 This is the first of a three-course curriculum that prepares the learner for Exam 70-291: Implementing, Managing, and Maintaining a Microsoft Windows Server 2003 Network Infrastructure. The learner is introduced to the course with a review of TCP/IP issues. The course then gives in-depth and exam-focused coverage to the areas of routing configuration, DHCP overview and configuration, and the  more...

Visual Basic 6 0 Designing Implementing Desktop Applications - Part 5 Course Overview This is the final 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...

Oracle8 Database Administration - Manage Data Course Overview This course is the fourth in a five-part series covering the database administration strategies and procedures provided in Oracle8. In this course, participants will learn about the concepts associated with tables. In addition, this course will teach users about maintaining data integrity, clusters and index-organized tables, and methods for loading and reorganizing data. L  more...

Lotus Domino R5 Development Part 2 Application Devel Fundamentals ...rm a specific task. Create a database. Create a form in an existing database by using the Design pane. Set the properties of a form in an existing database by using the context menu of the form. Match the types of fields in a form with their purposes. Add a field to a form. Set the properties of a field in a form by using the context menu of the field. Create a table in a form. Create a  more...

Lotus Domino R5 Development Part 6 Developing Applications for Web Clients Course Overview This is the sixth course in a nine part series for webmasters, application developers, and graphic designers that will introduce Notes/Domino features, web-specific tasks, and basic system administration tasks to be up on the web quickly and to use Domino to create Web sites and Web applications. At the completion of this course, students will learn how to identify the features  more...

Lotus Domino R5 Development Part 8 Application Architecture Course Overview This is the eighth course in a nine part series for webmasters, application developers, and graphic designers that will introduce Notes/Domino features, web-specific tasks, and basic system administration tasks to be up on the web quickly and to use Domino to create Web sites and Web applications. At the completion of this course, students will learn how to identify the  more...

Oracle8i Database Admin Manage an Instance Course Overview This course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle8i. In this course, participants will learn about the concepts and procedures associated with Oracle architectural components, using the database administration tools, managing an Oracle instance, and using National Language Support. L earn To:  more...

IBM DB2 Universal Database V6 1 Admin Curriculum Course Overview The Complete IBM DB2 Universal Database V6.1 Administration Curriculum includes the courses needed to prepare for IBM Certified Solutions Expert certification exams 509 and 510. Students will learn fundamental DB2 v6.1 skills and knowledge, such as creating and modifying database objects, creating indexes and views, managing basic database operations, and the basics of SQL.  more...

IBM DB2 Universal Database V6 1 Admin Curriculum Course Overview The Complete IBM DB2 Universal Database V6.1 Administration Curriculum includes the courses needed to prepare for IBM Certified Solutions Expert certification exams 509 and 510. Students will learn fundamental DB2 v6.1 skills and knowledge, such as creating and modifying database objects, creating indexes and views, managing basic database operations, and the basics of SQL.  more...

IBM DB2 Universal Database V6 1--Administration ...ed for designing a new DB2 implementation and maintaining an existing database. L earn To: Implement a new DB2 database or application. Maintain an existing DB2 database. C ontent Emphasis Skills-Based A udience This course is intended for database administrators. Students should have a fundamental understanding of relational database technology, including concepts of  more...

IBM DB2 Universal Database V6 1--Administration ...ed for designing a new DB2 implementation and maintaining an existing database. L earn To: Implement a new DB2 database or application. Maintain an existing DB2 database. C ontent Emphasis Skills-Based A udience This course is intended for database administrators. Students should have a fundamental understanding of relational database technology, including concepts of  more...

Dreamweaver UltraDev 4 Course Overview This is the final course in a three part curriculum about Macromedia products that can be used for Web design. This course teaches students how to use Dreamweaver UltraDev 4. Additionally, this course covers the basic skills needed to create database-driven Web sites using Dreamweaver UltraDev and ASP, ColdFusion, or JSP. Learn To • Identify the features of UltraDev,  more...

Oracle Application Server 10g Administration II Part 1 This course describes the advanced administration concepts. In addition, you are introduced to common deployment topologies of Oracle Application Server 10g to enable choosing the appropriate topology according to your business needs. To provide a stable and highly available environment that performs well, you learn the concepts for high availability (HA) and scalability. You also learn to  more...