Computing & Internet Databases Books

Visual Basic 6.0 Programming By Examples

Visual Basic is one of the easiest to learn computer programming language and yet it is very powerful.

In my tutorial I used VB 6 to explain step by step how to create a simple Visual Basic Application and relatively complex one (a Patient Management system) that is using database. Patient Management application source code is explained in details.

You will learn how to design and create a database in MS Access and how to create tables and queries.

The book includes a sample application that shows how to use Windows API function.

You will learn how to convert VB program that can be run only in Visual Basic development environment to a distributable application that can be installed on any client computer.

For illustration, I included 128 screen shot images and links to video.

You will be able to download from my website complete source code for 7 Visual Basic projects including a Password Keeper, a Patient Management and a Billing Management applications.

Version-Independent Programming: Code Development Guidelines for the Windows® Operating System

This book presents a set of guidelines by which to develop applications that will run on any version of the Windows(R) operating system. This is not a manual on computer programming, but it does address the subject where necessary. The reader is presumed to be proficient in the C programming language, as this is the clear choice for such development. Simply put, this is a manual on what to do and what to avoid, in order to achieve version-independence. As more versions are released and the time between new releases is shortened, compatibility becomes increasingly important. By following these guidelines, the resulting applications will not only be compatible, they will also be more efficient. Version-independence is a specific type of performance. Achieving performance always requires attention to detail. If you are not willing to pay attention to detail, you will never achieve performance.

Dissect and Learn Excel® VBA in 24 Hours: Working with ranges

No matter how complicated a program is, it is made of many smaller and tiny fundamental working parts of programming code. Each of them accomplishes a specific task. Some may just consist of only one or a few lines of code. Knowing the functions of these fundamental working parts, you can then easily write an unlimited number of working programs. And knowing them, you can easily understand the programs written by others and adopt into your programs the ideas and the efficient code that are presented in those programs.

Dissect and Learn Excel VBA in 24 Hours is a series of quick references for intermediate users who are looking for ideas and samples of VBA code to accomplish certain tasks when they are in the process of writing a program.

In this series, you will see thousands of tiny working parts of VBA code that are used to accomplish many simple and yet meaningful tasks. To add a new workbook, to auto-fill a range, to sort a table of data, to generate a table of contents for all chart sheets and worksheets in a workbook, to loop through and manipulate a folder of Excel files, to place a control on the Ribbon, to send an email, and to login to an account in the Internet are some examples of these tiny working parts.

This series is for readers, who have at least a basic understanding of Excel VBA programming. In order to follow the discussions in the series, a reader must know what Sub procedures and Sub functions are, what Visual Basic Editor (VBE) is, how to add a VBA module to a workbook, how to set a reference to an application's type library, how to enable the Auto List Members feature in VBE, how to use the Macro Recorder in Excel in order to find out the methods and properties of objects that you are not familiar with, how to use the Object Browser to check the complete list of members for a particular object, how to write some simple Sub procedures, in which VBA modules you should store your VBA code, and how to use the debugging tools in VBE.

If you are new to Excel VBA, please teach yourself Excel VBA before exploring the contents in the series. You may refer to my earlier book entitled Learn Excel(R) VBA in 24 Hours - A quick reference for beginners, which was written for those who are new to Excel VBA.

I hope this series of books will serve as quick references in facilitating you to write an unlimited number of working VBA programs. Let Excel VBA work for you.

Book 2: Working with ranges focuses on commonly used operations related to worksheet ranges. Selecting a range, finding the last nonempty cell in a range, retrieving the properties of a range (such as address and font), changing the format of a range, converting formulas in a range to values, conditionally formatting a range, sorting a range, filtering a range, copying a range, and exporting a range out of Excel are some of the operations.

Before you can perform any operations on a range with VBA, the first important step is to get a reference to a Range object that represents the range. The first topic in this book discusses numerous ways to refer to a range. Knowing how to refer to a range builds you a solid foundation to write sensible code and to understand the VBA code written by others on working with ranges.

To understand better a particular concept discussed in the book, simply copy and paste the sample VBA code stated in the book into the Immediate window or into a VBA module, and run or step through the code by using the debugger in VBE.

This book focuses on worksheet ranges in Excel 2007-2016 for Windows. The next book focuses on worksheets, workbooks, and files. It discusses adding and deleting worksheets and workbooks, creating a table of contents with hyperlinks for worksheets and chart sheets in a workbook, synchronizing sheet names and code names, prompting a user to select a file in a folder, writing to a text file, and looping through all Excel files in a folder in order to work on the files - among others.

Mastering Excel: Excel Apps

This lesson only applies to Excel 2013 or Office 365!

This short lesson covers Excel applications (apps). Apps are almost like the apps you find on your smartphone. In the Excel world, an app is a small, programmed interface that interacts with Excel data to extend your spreadsheet's functionality.

Excel come with two apps built by Microsoft. You will learn how to use these apps to add dynamic charts to your worksheets. There is no programming involved with these apps. They do all the work for you.

As with all my other lessons, this one comes with two follow along workbooks. One you can use to work through the exercises and the other one has the completed exercises.

Once again, if you do not have Excel 2013 or Office 365 for Windows, you will not be able to use this lesson!

Amazon Redshift Database Developer Guide

NOTE - A new version of the Amazon Redshift Database Developer Guide is available at https://www.amazon.com/dp/B07647QQXY

This is official Amazon Web Services (AWS) documentation for Amazon Redshift. Amazon Redshift is an enterprise-level, petabyte scale, fully managed data warehousing service. This guide focuses specifically on using Amazon Redshift to create and manage a data warehouse. If you work with databases as a designer, software developer, or administrator, it gives you the information you need to design, build, query, and maintain the relational databases that make up your data warehouse. This documentation is offered for free here as a Kindle book, or you can read it online or in PDF format at http://aws.amazon.com/documentation/redshift/.

Storing and processing information

This 3-hour free course discussed the main ways in which organisational data is managed, prior to decision-making activity.

The Evolution of Data Products

This report examines the important shifts in data products. Drawing from diverse examples, including iTunes, Google's self-driving car, and patient monitoring, author Mike Loukides explores the "disappearance" of data, the power of combining data, and the difference between discovery and recommendation. Looking ahead, the analysis finds the real changes in our lives will come from products and companies that reveal data results, not the data itself.

Take Control of PDFpen 8

Juggle your PDFs easily with PDFpen 8!

These days, an ever-increasing amount of "paper" -- contracts, tax forms, bills, reports, and more -- comes into our lives as PDF files. We generate this virtual paper too, since it's so much easier to save a document as a PDF and send it to a colleague via email than it is to print and send via fax or mail. To read, edit, and manipulate all these PDFs, you need appropriate tools and skills.

Given the high price of Adobe Acrobat DC Pro, many Mac users have turned to Smile's affordable PDFpen apps to help them sign PDF forms, handle scanned documents, make changes in existing PDFs, create new PDFs from a variety of sources, and even export PDFs to other file formats. With Take Control of PDFpen 8, you'll learn how to do all these tasks and more on your Mac with PDFpen or PDFpenPro or on the go with PDFpen for iPad & iPhone.

Members of Take Control's sister publication, TidBITS, can save 20% on all Smile products purchased through the Smile cart, including PDFpen 8 and PDFpenPro 8. To learn more, visit the Membership Benefits page. To access the coupon code, make sure you've logged in and click through from the Your Member Benefits page.

Take Control of PDFpen 8 begins with a guide to purchasing options: PDFpen versus PDFpenPro, from Smile versus the Mac App Store, and the advantages of the iOS version. Next, you'll meet PDFpen with an overview of the PDF format and a tour of the interface.

With the basics out of the way, highlights of what you'll learn to do include:

Add and remove pages, and combine pages from multiple files into one PDF.Mark up a PDF with highlights, comments, editing marks, and more.Edit a PDF by fixing typos, adding text, formatting text, and redacting confidential text. Scan a document into a PDF, and make the text editable with OCR.View and work with OCRed text in the OCR layer (PDFpenPro only)Add clickable links, page numbers, and images.Make a clickable table of contents (PDFpenPro only).Password-protect a PDF. And (PDFpenPro only), prevent others from printing or editing a PDF. Turn a PDF into a formatted Microsoft Word document, or (PDFpenPro only) export it in Excel or PowerPoint format. And, you'll find directions for working with PDF forms:

Fill out forms with ease.Add a handwritten signature.Apply a digital signing certificate.Print just form entries on a pre-printed form.Create an interactive PDF form (PDFpenPro only) that can collect data and send it to you via email or the Web. You can add an interactive signature field, which makes it easy for the form to be signed online.An appendix describes the useful AppleScripts that ship with PDFpen.

This ebook was created in collaboration with Smile, with PDFpen's developers tech editing the book.

Take Control of PDFpen 10

Edit and enhance your PDFs easily with PDFpen 10!

These days, an ever-increasing amount of "paper"--contracts, tax forms, bills, reports, and more--comes into our lives as PDF files. We generate this virtual paper too, since it's so much easier to save a document as a PDF and send it to a colleague via email than it is to print and send via fax or email. To read, edit, and manipulate all these PDFs, you need the appropriate tools and skills.

Given the high price of Adobe Acrobat DC Pro, many Mac users have turned to Smile's affordable PDFpen apps to help them sign PDF forms, handle scanned documents, make changes in existing PDFs, create new PDFs from a variety of sources, and to export PDFs to other file formats (including Word and Excel). With Take Control of PDFpen 10, you'll learn how to do all these tasks and more on your Mac with PDFpen or PDFpenPro or on the go with PDFpen for iPad & iPhone.

If you haven't used PDFpen before, this free book is an excellent way to find out what it has to offer.

Take Control of PDFpen 10 begins with a guide to purchasing options: PDFpen versus PDFpenPro, from Smile versus the Mac App Store, and the advantages of the iOS version. Next, you'll meet PDFpen with an overview of the PDF format and a tour of the interface.

With the basics out of the way, highlights of what you'll learn to do include:

Add and remove pages, and combine pages from multiple files into one PDF.Mark up a PDF with highlights, comments, editing marks, and more.Edit a PDF by fixing typos, adding text, formatting text, and redacting confidential text. Scan a document into a PDF, and make the text editable with OCR--with single or multiple documents.View and work with OCRed text in the OCR layer (PDFpenPro only)Add clickable links, headers, footers, page numbers, and images.Make a clickable table of contents (PDFpenPro only).Add a watermark to each page of a PDF.Password-protect a PDF. And (PDFpenPro only), prevent others from printing or editing a PDF. Turn a PDF into a formatted Microsoft Word document, or (PDFpenPro only) export it in Excel or PowerPoint format. And, you'll find directions for working with PDF forms:

Fill out forms with ease.Add a handwritten signature.Apply a digital signing certificate.Print just form entries on a pre-printed form.Create an interactive PDF form (PDFpenPro only) that can collect data and send it to you via email or the web. You can add an interactive signature field, which makes it easy for the form to be signed online.An appendix describes the useful AppleScripts that ship with PDFpen.

This ebook was created in collaboration with Smile, with PDFpen's developers tech editing the book.

Take Control of PDFpen 7

Learn how to create and manipulate PDFs with PDFpen 7 and PDFpen for iPad & iPhone

PDF serves as a universal document format for all manner of forms, statements, and receipts. And, whether you've moved a lot of your documents into the cloud or not, you've probably noticed that more and more "paper" is coming your way as PDF files.

But, even as PDFs unstuff our filing cabinets and shrink the piles in our physical inboxes, we need to learn new skills to edit and manage PDFs effectively. Many Mac users have turned to Smile's affordable PDFpen app to help them sign PDF forms, handle scanned documents, edit PDFs, create PDFs, and even export PDFs to other file formats. With Take Control of PDFpen 7, you'll learn how to do all these tasks and more on a Mac with PDFpen or PDFpenPro, or on the go with PDFpen for iPad & iPhone.

The book begins with a guide to purchasing options: PDFpen versus PDFpenPro, from Smile versus the Mac App Store, and the advantages of the iOS version. Next, you'll meet PDFpen with an overview of the PDF format and a tour of the interface.

Compatibility? PDFpen 7 works with OS X 10.10 Yosemite; we also have Take Control of PDFpen 6 for users of older versions of OS X.

With those preliminaries out of the way, you'll learn how to:

Add and remove pages, and combine pages from multiple files into one PDF.Mark up a PDF with highlights, comments, professional editing marks, and more.Edit a PDF by fixing typos, adding text, formatting text, and redacting confidential text. Scan a document into a PDF, and make the text editable with OCR.View and work directly with OCRed text in the OCR layer (PDFpenPro only)Add clickable links, page numbers, and images.Make a clickable table of contents (PDFpenPro only).Reduce the file size with a Quartz filter.Password-protect a PDF. And (PDFpenPro only), prevent others from printing or editing a PDF. Turn a PDF into a formatted Microsoft Word document, or (PDFpenPro only) export it in Excel or PowerPoint format. And, you'll find directions for working with forms:

Fill out forms with ease.Add a handwritten signature -- in the iOS versions, you can write with a stylus!Print just form entries on a pre-printed form.Create an interactive PDF form for both Mac and Windows (PDFpenPro only) that can collect data and send it to you via email or the Web.That's not all! The book also covers how to:

Work with PDFs in PDFpen for iPad & iPhone.Get your PDFs into and out of PDFpen in iOS via iCloud Drive, iTunes, Dropbox, and Open In.Print a PDF with its annotations appearing at the end.Store frequently used items (like a logo or signature) in the PDFpen Library.Turn a Web site into a multi-page PDF (PDFpenPro only).An appendix describes the useful AppleScripts that ship with PDFpen.

This ebook was created in collaboration with Smile, with PDFpen's developers tech editing the book.

Intel Trusted Execution Technology for Server Platforms: A Guide to More Secure Datacenters (Expert's Voice in Security)

Paperback. Pub Date :2013-07-09 Pages: 133 Language: English Publisher: Apress Intel Trusted Execution Technology for Server Platforms: A Guide to More Secure Datacenters is a must have resource guide for anyone who wants to ... implement TXT within their environments.I wish we had this guide when our engineering teams were implementing TXT on our solution platforms!

TouchDevelop: Programming on the Go, Third Edition (Expert's Voice in Web Development)

Paperback. Pub Date :2013-06-04 Pages: 250 Language: English Publisher: APRESS TouchDevelop: Programming on the Go. 3rd Edition (The Experts Voice) is written from theperspective of a person developing their code using a web browser. TheTouchDevelop Web App runs in many modern browsers on many different devicesincluding smartphones and tablets. Macs. PC.All screenshots and navigationinstructions refer to the TouchDevelop Web App running in a browser.ForWindows Phone. there is a dedicated TouchDevelop app in the Windows Phone Storewhich gives access to many more sensors and data sources.Starting with theTouchDevelop app v3.0 for Windows Phone 8. the phone app will share the samelook and navigation structure and all features of the Web App.

Linked Open Data -- Creating Knowledge Out of Interlinked Data: Results of the LOD2 Project (Lecture Notes in Computer Science)

Linked Open Data (LOD) is a pragmatic approach for realizing the Semantic Web vision of making the Web a global, distributed, semantics-based information system. This book presents an overview on the results of the research project "LOD2 -- Creating Knowledge out of Interlinked Data". LOD2 is a large-scale integrating project co-funded by the European Commission within the FP7 Information and Communication Technologies Work Program. Commencing in September 2010, this 4-year project comprised leading Linked Open Data research groups, companies, and service providers from across 11 European countries and South Korea. The aim of this project was to advance the state-of-the-art in research and development in four key areas relevant for Linked Data, namely 1. RDF data management; 2. the extraction, creation, and enrichment of structured RDF data; 3. the interlinking and fusion of Linked Data from different sources and 4. the authoring, exploration and visualization of Linked Data.

Dissect and Learn Excel® VBA in 24 Hours: Changing workbook appearance

No matter how complicated a program is, it is made of many smaller and tiny fundamental working parts of programming code. Each of them accomplishes a specific task. Some may just consist of only one or a few lines of code. Knowing the functions of these fundamental working parts, you can then easily write an unlimited number of working programs. And knowing them, you can easily understand the programs written by others and adopt into your programs the ideas and the efficient code that are presented in those programs.

Dissect and Learn Excel VBA in 24 Hours is a series of quick references for intermediate users who are looking for ideas and samples of VBA code to accomplish certain tasks when they are in the process of writing a program.

In this series, you will see thousands of tiny working parts of VBA code that are used to accomplish many simple and yet meaningful tasks. To add a new workbook, to auto-fill a range, to sort a table of data, to generate a table of contents for all chart sheets and worksheets in a workbook, to loop through and manipulate a folder of Excel files, to place a control on the Ribbon, to send an email, and to login to an account in the Internet are some examples of these tiny working parts.

This series is for readers, who have at least a basic understanding of Excel VBA programming. In order to follow the discussions in the series, a reader must know what Sub procedures and Sub functions are, what Visual Basic Editor (VBE) is, how to add a VBA module to a workbook, how to set a reference to an application's type library, how to enable the Auto List Members feature in VBE, how to use the Macro Recorder in Excel in order to find out the methods and properties of objects that you are not familiar with, how to use the Object Browser to check the complete list of members for a particular object, how to write some simple Sub procedures, in which VBA modules you should store your VBA code, and how to use the debugging tools in VBE.

If you are new to Excel VBA, please teach yourself Excel VBA before exploring the contents in the series. You may refer to my earlier book entitled Learn Excel(R) VBA in 24 Hours - A quick reference for beginners, which was written for those who are new to Excel VBA.

I hope this series of books will serve as quick references in facilitating you to write an unlimited number of working VBA programs. Let Excel VBA work for you.



Book 1: Changing workbook appearance focuses on changing the appearances of the worksheet cells, the worksheets of a workbook, the row and column headings, the sheet tabs, the layout view of a worksheet, the status bar, the formula bar, the Ribbon, and the Cell context menu. Figure 1 shows the components that will undergo certain changes in their appearances. In this book, almost half of it covers on how to customize the Ribbon.

The main purpose of changing the appearance is to let the users to have a better working experience when they are using your program. The changes may affect from just a worksheet cell, a range of cells, and a worksheet to the entire active workbook and every opened workbook. To see how the code affects the appearance, simply copy and paste the code into the Immediate window, a VBA module, or Custom UI Editor, and run the VBA code (or step through the VBA code by using the debugger in VBE) or reopen the workbook file (that stores the code) in Excel.

This book ends with a sample program that adopts most of the ideas that are discussed in the book. You may download the program (for Excel 2007 and 2010-2016) to see how it changes the appearance of a workbook.