CIS-019V Visual Studio Tools for Office (VSTO) C#
Course Summary:Visual Studio Tools for Office Using C# -- This course is suitable for you if you already have a basic familiarity with C# programming. If you do not have any experience with C#, consider taking CIS-019A (Introduction to C#). Even if you are an accomplished C++ or Java programmer, this couse may be too difficult to master in the compressed summer schedule.Most companies make extensive use of Microsoft Office applications such as Word, Excel and Outlook. In fact, for many business managers one or more of these applications is the primary software tool which they use on a daily basis. And since, particularly in the field of computing, people prefer to use tools with which they are comfortable, there is a considerable demand for customized applications built around Microsoft Office applications. Visual Studio Tools for Office (VSTO) is an add-in to Visual Studio 2005 which allows developers to build Microsoft Office related applications. VSTO applications can take three forms: (1) Office automation, (2) Office add-ins and (3) Code behind Office documents. Office automation refers to a C# or VB.NET application which uses some capability of one or more Office applications to perform a given task. For example, an application could use either Word or Excel to print a document pursuant to some pre-designed format. Office add-ins are applications which run at the same time as the Office application with which they are associated and which appear to be an integral part of the application's user interface. For example, an Outlook add-in could retrieve a list of names from a database and add them to an existing mailing list. While VSTO 2005 supports .NET type add-ins only for Outlook and COM type add-ins for Word and Excel, the next release of VSTO will provide add-in support for seven more Office applications including Access, Powerpoint and Visio. VSTO add-ins most commonly customize the application menus or tool bar to add some extra functionality. Code behind Office documents correspond to classic Visual Basic for Applications (VBA) projects which customize a particular Office document. For example, code behind could, in response to some event such as clicking on a button, connect to a Web Service to insert a stock price or an item of weather information into a spreadsheet or a Word document. There is a great deal of similarity between what can be accomplished as an add-in and in a code behind module for a given document. The principal difference is that code behind is associated with and applies only to a single document while an add-in remains loaded for the entire time that an Office application is running, no matter what documents are being worked with.
C# / .NET Market PenetrationCourse OutlineCourse SyllabusCourse Schedule:This class is entirely online and will run for twelve weeks from September 24 to December 14.Textbook:Eric Carter, Eric Lippert Visual Studio Tools for Office Using C#, First Edition 2005 ISBN: 0321334884Comments From Former Students in Other C# Classes (This is a first time class):"I really enjoyed taking your class and will be coming in for the ASP .NET class as well in Summer 2005""I think this class consolidated and extended what I learnt from DeAnza, plus ADO.net access to MS SQL... Thanks for being my teacher." "Thank you for offering such a wonderful course on the internet. It's always an enjoyable experience to have your course, both Perl and this one. Although I took the easy labs, yet they were challenging enough for me to learn a lot. Now I still keep reading other C# books, and try to get some background knowledge for other alternative labs. I think this course should run 2 quarters. I hope I have chance to take your C# web or other course online in the future. Thank you." "...it's really exciting to work on these labs. I'm almost done with lab3E -- It's so cool to practice the DataTable features !! I have learned a lot ..." PS -- Thank YOU for being a kind, competent and wonderfully attentive instructor. I like how you help out with questions (even as a student, like in COIN 92!) Course PreviewLogin Instructions: UserID: StudentPreview Password: guest (both are case sensitive)Proceed to Foothill RegistrationInstructions for Requesting Late Adds (Only Relevant Starting on the First Day of the Term)
|