Active Reports Beginning

This course is used to introduce students to the Active Reports environment, architecture and specifications.  This session will introduce the student to the database objects stored in the database and the SQL language that is used to access the data in the database.  The student will learn how to collect information that is needed for the report and then how to present it on the report to allow the users to understand the meaning behind the data information. Session(s): Session Title 1 Introduction 2 Report Types 3 Technical Architecture 4 Development Tools  5 Database Objects 6 Database Modeling 7 Database Query Fundamentals 8 Programming 9 Testing Methods 10 Documentation 11 Report Launcher Please look below at the "Sessions" area of the file attachments at the bottom of this page. Course Activitie(s): Activity Description 1 Configure Database on Workstation 2 SQL Query Fundamentals 3 Create Baseline Report 4 Create Database Objects and Stored Procedure 5 Client Listing Report 6 Enhance Client Listing Report 7 Client Family Report 8 Client Detail Report 9 Deploy Client Summary Listing Report 10 Deploy Client Family Report 11 Create Provider/Services Listing Report  12 Create Client/Services Listing Report 13 Deploy Provider/Services Listing Report Each participant should have the following items installed on the individual workstation. Active Reports Designer (Click Here) SQL Server 2008 Express (Click Here) Download the latest version of your ClientTrack database. Each participant should have experience in the following area(s): Basic relational database concepts Basic SQL experience

Selection	File type icon	File name	Description	Size	Revision	Time	User

	Activities

Selection	File type icon	File name	Description	Size	Revision	Time	User
	Ċ	Activity_01.pdf View Download	Configure Database on Workstation	699k	v. 2	May 28, 2010, 5:20 AM	Scott Heffron
	Ċ	Activity_02.pdf View Download	SQL Query Fundamentals	1564k	v. 2	May 28, 2010, 5:25 AM	Scott Heffron

	Sessions

Selection	File type icon	File name	Description	Size	Revision	Time	User
	Ċ	ARB01_Introduction.pdf View Download	This is the introduction overview for the beginning course.	352k	v. 2	Jun 1, 2010, 6:28 PM	Scott Heffron
	Ċ	ARB02_ReportTypes.pdf View Download	Explains the different types of reports that will be used during this course.	562k	v. 2	Jun 1, 2010, 6:29 PM	Scott Heffron
	Ċ	ARB03_TechnicalArchitecture.pdf View Download	This will describe the technical components for ClientTrack and how it relates to the Report Designer.	1439k	v. 2	Jun 1, 2010, 6:44 PM	Scott Heffron
	Ċ	ARB04_DevelopmentTools.pdf View Download	Explains the different development tools.	2868k	v. 2	Jun 1, 2010, 6:58 PM	Scott Heffron
	Ċ	ARB05_DatabaseObjects.pdf View Download	This session explains the different objects available in the database that are used for reporting.	769k	v. 2	Jun 1, 2010, 7:10 PM	Scott Heffron
	Ċ	ARB06_DBModeling.pdf View Download	Describes the different normalization levels of database modeling.	2416k	v. 2	Jun 1, 2010, 7:33 PM	Scott Heffron
	Ċ	ARB07_DatabaseQueryFundamentals.pdf View Download	Work through database query operations	8968k	v. 2	Jun 1, 2010, 8:38 PM	Scott Heffron