Timothy Miles

INSTRUCTOR

0.0 (0 rating)

CREDENTIALS

courses with Timothy Miles

Beginner 03 Hrs 24 Min Timothy Miles

This course teaches the basic functions and features of Visio Professional 2010. The primary focus is to get acquainted with creating the different diagrams using the stencils and templates. You will learn how to draw basic shapes and compound lines and arrange objects. You will also learn how to create diagrams, work with text, and apply formatting. Finally, you will create organization charts and brainstorming diagrams, set shape properties, and work with pages.

Last Release: 05/01/18
Intermediate 05 Hrs 19 Min Timothy Miles

This course goes into more detail on how to make the database objects more interactive within Microsoft Access 2010. Starting with an explanation of the different table relationships and setting advanced properties within a table, this course shows you how to effectively use the tools within Microsoft Access to verify data as it gets entered into the database. Additionally, this course shows you how to import an Excel spreadsheet and use the different Action Queries to create a relational database. Finally, the course shows how to create interactive forms and reports by adding calculated controls.

Last Release: 05/01/18
Beginner 04 Hrs 30 Min Timothy Miles

This course covers the basics functions of Access 2010. After an introduction to database concepts and the Access environment and Help systems, you will learn how to open and use existing databases and design and create databases. Next, you will work with tables, fields, and records; sort, search and filter data; and set field properties and data entry rules. You also will learn to create queries, forms, and reports.

Last Release: 05/01/18
Advanced 03 Hrs 58 Min Timothy Miles

This course builds on the Introduction and Intermediate courses to show techniques to bring all of the different Access objects together to make a cohesive application. It does this by showing the viewer how and why Microsoft Access utilizes the Properties and Events of the different objects. Finally, the course shows the viewer how to create macros using the new Macro editor and how to select the proper Control and Event for the best possible outcome.

Last Release: 05/01/18
Intermediate 03 Hrs 26 Min Timothy Miles

This course builds on the skills and concepts taught in Access 2007: Introduction. Students will learn how to normalize data; work with Lookup fields and subdatasheets; create join queries; add objects to forms, print reports and labels; create charts; and use PivotTables and PivotCharts. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

Last Release: 05/01/18
Beginner 02 Hrs 40 Min Timothy Miles

This course covers the basic functions and features of Access 2007. Students will learn how to design and create databases; work with tables, fields, and records; sort and filter data; and create queries, forms, and reports. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

Last Release: 05/01/18
Advanced 02 Hrs Timothy Miles

This course builds on the Introduction and Intermediate courses to show you how to bring all of the different Access objects and development phases together to make a cohesive application. It also teaches you many different techniques to make Access even more interactive by using dialog boxes, subforms, and more controls. Finally, the course shows you how to create different types of macros and how to select the proper Control and Event for the best possible outcome. The course will cover programming tips as well.

Last Release: 05/01/18
Advanced 04 Hrs Timothy Miles

This course introduces the user to SQL Server 2008 and the SQL Server Management Studio. It covers the basics from creating databases and tables to learning how to query multiple tables. Once those basics are covered, the final exercise is understanding and creating Views and simple Stored Procedures. This course is designed to get the user up and running with SQL Server as quickly as possible.

Last Release: 05/01/18
Advanced 04 Hrs Timothy Miles

This course introduces you to Excel Macro programming using Microsoft's Visual Basic for Applications (VBA). The overall focus of this course is to teach you proper Visual Basic programming techniques along with an understanding of Excel's object structure. Other topics in this course include recording macros, programming basics, proper variable declaration, Visual Basic functions, control structure use, looping, and UserForm creation. The final section deals with the debugging tools included in the Microsoft VBA editor and methods on how to effectively use them.

Last Release: 05/01/18
Intermediate 10 Hrs Timothy Miles

In part 2, students will dive into topics such as understanding the basic form and structure of program units stored within the database, building and maintaining stored procedures, functions, packaged programs, and database triggers. Additional topics include taking advantage of advanced programming techniques such as cursor variables and cursor expressions. This Oracle 11g course will prepare students for the Oracle certification exams (OCP).

Last Release: 05/01/18
Beginner 10 Hrs Timothy Miles

The primary objective of this Oracle 11g training course is to provide an introduction to the PL/SQL database programming language covering syntax, structure, and features of the language within the context of database applications and programming. This Oracle 11g course will prepare students for the Oracle certification exams (OCP).

Last Release: 05/01/18
Advanced 05 Hrs Timothy Miles

The overall focus of this course is to teach the user proper Visual Basic programming techniques along with an understanding of Excel’s object structure. Other topics in this course include: proper variable declaration, control structure use, looping, and UserForm creation. The final section deals with the debugging tools included in the Microsoft VBA editor and methods on how to effectively use them.

Last Release: 05/01/18
Beginner 03 Hrs 41 Min Timothy Miles

This course introduces the user to Microsoft InfoPath 2007. In this course, you will learn how to create new Form Templates and properly utilize the different controls and their associated properties to assist users. With a strong emphasis on the underlying data structure created by InfoPath and the associated controls, this course gives you everything you need to create effective and useful Form Templates. You will also learn how to import, export, and merge data; protect and publish forms; and work with views.

Last Release: 05/01/18
Advanced 02 Hrs 30 Min Timothy Miles

This course covers the features within Microsoft Project 2007 that every project manager needs to know. This includes setting Advanced Task settings, entering Overtime work, and selecting the Cost Rate Table. After this course, you will know how to import a project from a different Microsoft Office application, create your own custom Tables and Views, and then create a custom report to answer questions for management.

Last Release: 05/01/18
Beginner 01 Hrs 39 Min Timothy Miles

This course familiarizes the student with techniques to properly create and normalize a relational database. This single course can help prevent the new database developer from creating mistakes that add hours and days to a development project.

Last Release: 05/01/18
Beginner 02 Hrs 08 Min Timothy Miles

This course gives the user a beginning orientation to Microsoft Project 2007. The primary focus of this course is to teach the user how to properly use Project 2007 by leveraging the different tools within the application. This includes creating new projects and calendars, entering tasks and relationships, managing resources, and learning how to use the variety of tools available to effectively implement a project plan.

Last Release: 05/01/18
Beginner 03 Hrs 26 Min Timothy Miles

This course teaches the beginning user how to create useful reports using Crystal Reports 2008. The primary focus is to give you a solid foundation on effectively using the Crystal Reports interface and its many features. When completed, the student will understand how reports are generated and how to customize the output for practical, impressive reports. You will learn how to create a simple report, use formulas in a report, use conditional formatting, add parameters to a report, distribute data, enhance a report, and much more.

Last Release: 05/01/18
Beginner 09 Hrs 25 Min Timothy Miles

This course is the beginning track for certification. It is designed for the beginning C# programmer, although there are topics of an advanced nature included as well. The topics discussed within this curriculum focus primarily on C# code and not interface design or true event-based programming.

Last Release: 05/01/18
Beginner 03 Hrs Timothy Miles

In this course, you'll discover how to bring together content from multiple sources that you can customize within Acrobat Pro 9. You'll learn how to modify text, add bookmarks, and add navigation to guide your users. Additional topics include adding security to your PDF files and creating user-interactive forms.

Last Release: 05/01/18
Beginner 09 Hrs 15 Min Timothy Miles

This course is the beginning track for certification. It's designed for the beginning VB.NET programmer, although there are topics of an advanced nature. The topics discussed within this curriculum focus primarily on VB.NET code and not interface design or true event-based programming.

Last Release: 05/01/18