VBA Professional Projects 1st Edition by Rachna Chaudhary, Taruna Goel ISBN 1931841551 978-1931841559

VBA Professional Projects 1st Edition by Rachna Chaudhary, Taruna Goel – Ebook PDF Instant Download/Delivery: 1931841551, 978-1931841559
Full download VBA Professional Projects 1st Edition after payment

Product details: 

ISBN 10: 1931841551 

ISBN 13: 978-1931841559

Author:  Rachna Chaudhary, Taruna Goel

Use VBA to accomplish real-world, professional tasks. Incorporating four hands-on projects, Microsoft VBA Professional Projects is your key to unlocking the power of Visual Basic for Applications. Each project focuses on a specific concept and is based on a real-world situation. Enhance your VBA skills as you create a skill search application, a word checker tool, and a selling application. You will be able to use the skills that you develop throughout the book to modify the projects as needed to fit your professional needs.

Table of contents: 

Part I

Introducing VBA.

1 VBA Overview.

2 Variables, Constants, and Expressions

3 Procedures, Functions, and Modules

4 Arrays and Programming Constructs.

Part II

5 Debugging and Error-handling in VBA

6 Objects in VBA

7 Using Security Features in VBA

Part III

Professional Project – 1

8 Project Case Study: Global Systems, Inc…….

9 Creating the User Interface of the Application.

10 Working with User Forms.

11 Using Automation.

12 Adding Functionality to the Contacts Book Application

13 Using the Contacts Book Application

Part IV

Professional Project – 2

14 Project Case Study: Red Sky IT Systems.

15 Overview of the .NET Framework

16 Introduction to VB.NET.

17 The Integrated Development Environment.

18 Working With Databases by Using VB.NET and ADO.NET..

19 Coding the Skill Search Application

20 Working with ASP.NET…

21 Executing the Skill Search Application

Part V

Professional Project – 3

22 Project Case Study: Writers and Editors, Inc.

23 Working with Word Objects in VBA

24 Coding the Application.

25 Executing the Word Checker Tool.

Part VI

Professional Project – 4

26 Project Case Study: Perfect Stationery Inc.

27 Creating the Database.

28 Designing the Forms of the Application

29 Working with Excel Objects.

30 Working with PowerPoint Objects.

31 Coding the Main Screen of the Easy Selling Application

32 Coding the Customers Screen of the Easy Selling Application

33 Coding the Issues Screen of the Easy Selling Application

34 Coding the Solutions Screen of the Easy Selling Application

35 Coding the Outputs Screen of the Easy Selling Application

36 Executing the Easy Selling Application.

Part VII

Beyond The LAB.

37 XML and.NET

Part VIII

Appendices

A VBA Tips and Tricks

B Working with the Access Object Model

C Upgrading Applications to VB.NET.

D VBA Constants.

People also search for:

excel vba professional userform
    
vba professional engineer
    
vba professional indemnity insurance
    
vba professional userform
    
vba notes for professionals pdf

Tags: Rachna Chaudhary, Taruna Goel, VBA Professional Projects