Books by Julitta Korol

Guides you through the process of building a traditional Access desktop database that uses one Access database as the front-end (queries, reports, and forms) and another to contain the tables and data. By separating the data from the rest of the database, the Access database can be easily shared by multiple users over a network.

A practical how-to book on Excel programming, suitable for readers already familiar with the Excel user interface. The book introduces programming concepts via numerous multi-step, illustrated, hands-on exercises. More advanced topics are introduced via custom projects.

As part of the Pocket Primer series, this book provides an overview of the major concepts to program Microsoft Access/VBA. The focus of this book is on basic programming instructions for both Access 2013 and previous versions.

Suitable for readers already familiar with the Excel user interface and introduces programming concepts via numerous multi-step, practical exercises. More advanced topics are introduced via custom projects. Covers recording and editing a macro and writing VBA code through working with XML documents and using ASP to display data on the Web.

With more than 275 applied examples and 10 projects, Access users can quickly build database solutions with ActiveX Data Objects, perform database tasks with Jet/Access Structured Query Language and export/import Access data to and from XML both manually and programmatically.

Updated for Excel 2016 and based on the bestselling editions from previous versions, this book is a practical, how-to book on Excel programming. If you are looking to automate Excel routine tasks, this book will progressively introduce you to programming concepts via numerous, illustrated, hands-on exercises.