eBooks from Steven Roman
All books and eBooks by Steven Roman:
Writing Excel Macros wit...
Writing Excel Macros with VBA, 2E PDF
by Steven Roman
Chapter 1 CHAPTER 1 Introduction Microsoft Excel is an application of enormous power and flexibility. But despite its powerful feature set, there is a great deal that Excel either does not allow you to do or does not allow you to do easily through its user interface. In these cases, we must turn to Excel programming. Let me give you two examples that have come up in my consulting practice. Selecting Special Cells The Excel user interface does not have a built-in method for selecting worksheet cells based on various criteria. For instance, there is no way to select all cells whose value is between 0 and 100 or all cells that contain a date later than January 1, 1998. There is also no way to select only those cells in a given column that are different from their immediate predecessors. This can be very useful when you have a
(2007)
VB.NET Language Pocket R...
by Steven Roman, Ron Petrusha, and Paul Lomax
Visual Basic .NET Language Pocket Reference Introduction Visual Basic .NET is a radically new version of Microsoft Visual Basic, the world’s most widely used rapid application development (RAD) package. Visual Basic .NET is designed to work directly with Microsoft’s .NET platform, which includes a Framework Class Library to facilitate application development, a Common Language Runtime to provide a managed execution environment, and a Common Type Sys- tem to insure interoperability among all languages that sup- port the .NET platform. The Visual Basic .NET Language Pocket Reference is a quick reference guide to Visual Basic 7.0, the first version of Visual Basic .NET. It contains a concise description of all language elements by category. These include language elements imple- mented by the Visual Basic compiler, as well as all procedures and functions implemented in the Microsoft.VisualBasic namespace. It does not attempt to document the core classes of the .NET Framework Class
(2002)
Access Database Design &...
by Steven Roman
Chapter 1 CHAPTER 1 Introduction Database Design As mentioned in the Preface, one purpose of this book is to explain the basic con- cepts of modern relational-database theory and show how these concepts are real- ized in Microsoft Access. Allow me to amplify on this rather lofty goal. To take a very simple view, which will do nicely for the purposes of this introduc- tory discussion, a database is just a collection of related data. A database manage- ment system, or DBMS, is a system that is designed for two main purposes: • To add, delete, and update the data in the database • To provide various ways to view (on screen or in print) the data in the database If the data is simple and there is not very much of it, then a database can consist of a single table. In fact, a simple database can easily be
(2007)

