Access 2010 24-Hour Trainer
Access 2010 24-Hour Trainer

Author: Geoffrey L. Griffith

Publisher: John Wiley & Sons

Published: 2011-05-10

Total Pages: 554

ISBN-13: 1118088468

DOWNLOAD EBOOK

This book-and-video package is the perfect introduction to Access 2010 Microsoft Access is the most popular database system in the world and this practical guide will soon have you building Access applications using the Access 2010. This book is designed for beginner-to intermediate-level Access users and covers the basics of building and working with the major features of the program. Over 60 lessons are included to discuss these features and provide step-by-step examples showing you exactly how each feature can be implemented in a real world Access database application. The accompanying DVD provides clear, easy-to-follow videos of the authors demonstrating each of the examples discussed in the book, as well as extra commentary, so that no reader is left behind! Provides examples of building Access database applications from scratch or from existing database templates. Discusses how to use Access 2010 and the major components it provides, such as the Navigation Pane, Ribbon, and the many database object designers. Teaches the basics of building and working with each of the major Access database object types: tables, queries, forms, reports, macros, and VBA code modules. Introduces exciting new Access 2010 features, such as the new macro designer, the new Ribbon designer, and even how to customize the Access Backstage. Teaches the basics of writing VBA code and provides specific examples about how and when to use it. Each lesson includes a step-by-step written example and DVD video showing exactly how to accomplish the tasks discussed in the lesson. Even if you have no experience with Access 2010, this guide will have you building robust Access applications with the best of them! If you want to get quickly up to speed on Access 2010, Access 2010 24-Hour Trainer is the perfect place to start. Note: As part of the print version of this title, video lessons are included on DVD. For e-book versions, video lessons can be accessed at wrox.com using a link provided in the interior of the e-book.

Knight's Microsoft Business Intelligence 24-Hour Trainer
Knight's Microsoft Business Intelligence 24-Hour Trainer

Author: Brian Knight

Publisher: John Wiley & Sons

Published: 2011-11-30

Total Pages: 434

ISBN-13: 1118287479

DOWNLOAD EBOOK

A book-and-video introduction to Microsoft's Business Intelligence tools If you are just starting to get a handle on Microsoft Business Intelligence (BI) tools, this book and accompanying video provides you with the just the right amount of information to perform basic business analysis and reporting. You'll explore the components and related tools that comprise the Microsoft BI toolset as well as the new BI features of Office 2010. After a basic primer on BI and data modeling, the expert team of authors provides you with step-by-step lessons in the book and videos on the accompanying DVD on how to use SQL Server Integration Services, SQL Server Analysis Services, SQL Server Reporting Services, Excel BI (including PowerPivot), and SharePoint. Integrates instructional videos with each of the lessons found in the book to enhance your learning experience Explores the Microsoft Business Intelligence (BI) toolset as well as the new BI features of Office 2010 Encourages you to practice what you've learned in "Try It Out" sections Contains video demonstrations that walk you through how to tackle each lesson featured in the book With Knight's Microsoft Business Intelligence 24-Hour Trainer, veteran authors present you with an ideal introductory book-and-video package so that you can get started working with the BI toolset immediately! Note: As part of the print version of this title, video lessons are included on DVD. For e-book versions, video lessons can be accessed at wrox.com using a link provided in the interior of the e-book.

Access 2010 Programmer's Reference
Access 2010 Programmer's Reference

Author: Teresa Hennig

Publisher: John Wiley & Sons

Published: 2010-10-28

Total Pages: 132

ISBN-13: 047093896X

DOWNLOAD EBOOK

A comprehensive guide to programming for Access 2010 and 2007 Millions of people use the Access database applications, and hundreds of thousands of developers work with Access daily. Access 2010 brings better integration with SQL Server and enhanced XML support; this Wrox guide shows developers how to take advantage of these and other improvements. With in-depth coverage of VBA, macros, and other programming methods for building Access applications, this book also provides real-world code examples to demonstrate each topic. Access 2010 Programmer's Referenceis a comprehensive guide to the best-of-breed techniques for programming Access applications. Coverage Includes: Introduction to Microsoft Access 2010 New Features Upgrading and Converting to Access 2010 Macros in Access 2010 Using the VBA Editor VBA Basics Using VBA in Access Creating Classes in VBA Extending VBA with APIs Working with the Windows Registry Using DAO to Access Data Using ADO to Access Data Using SQL with VBA Using VBA to Enhance Forms Enhancing Reports with VBA Customizing the Ribbon Customizing the Office Backstage Working with Office 2010 Working with SharePoint Working with .NET Building Client-Server Applications with Access The Access 2010 Templates Access Runtime Deployment Database Security Access 2010 Security Features

SharePoint 2010 Business Intelligence 24-Hour Trainer
SharePoint 2010 Business Intelligence 24-Hour Trainer

Author: Adam Jorgensen

Publisher: John Wiley & Sons

Published: 2011-12-05

Total Pages: 395

ISBN-13: 1118102010

DOWNLOAD EBOOK

Learn to build and deliver SharePoint BI applications Written by a team of leading SharePoint and Business Intelligence (BI) experts, this unique book-and-DVD package shows you how to successfully build and deliver BI applications using SharePoint 2010. Assuming no previous SharePoint experience, the authors deliver a clear explanation of what SharePoint will do for your BI and information management capabilities. Each lesson in the book is reinforced with a helpful tutorial on the DVD and cover topics such as interactive reporting with Excel, document sharing for collaborative reporting, and controlling data sources. As you learn best practices for configuring and securing SharePoint 2010 BI applications and planning and implementing your SharePoint BI project plan, you'll be well on your way to gaining a solid foundation of understanding and working with SharePoint 2010 and BI. Provides an invaluable training book-and-DVD package that takes you through building and delivering BI applications using SharePoint 2010 Features an accompanying video tutorial for each lesson covered in the book, along with a "Try It" section at the end of each lesson Covers interactive reporting with excel Covers Power Pivot advanced analytics Details report and document sharing for collaborative reporting Shows how to use SharePoint lists and libraries for data sources repositories in your BI projects Explains how to control data sources, reports and business intelligence content with permissions and workflow approvals. With this unique book-and-DVD combo, you'll be well on your way to successfully building and delivering BI applications using SharePoint 2010. Note: As part of the print version of this title, video lessons are included on DVD. For e-book versions, video lessons can be accessed at wrox.com using a link provided in the interior of the e-book.

T-SQL in One Hour a Day, Sams Teach Yourself
T-SQL in One Hour a Day, Sams Teach Yourself

Author: Alison Balter

Publisher: Sams Publishing

Published: 2015-10-16

Total Pages: 596

ISBN-13: 0134176006

DOWNLOAD EBOOK

Master T-SQL database design, development, and administration the easy way–hands-on! In just one hour a day, you’ll build all the skills you need to create effective database applications with T-SQL and SQL Server. With this complete tutorial, you’ll quickly master the basics and then move on to more advanced features and concepts: Learn the fundamentals of T-SQL from the ground up, one step at a time Succeed with the newest versions of T-SQL, SQL Server, and SQL Server Management Studio Use T-SQL effectively as both an application developer and DBA Master powerful stored procedures, triggers, transactions, and user-defined functions (UDFs) Systematically optimize and secure your SQL Server databases Learn on your own time, at your own pace No previous T-SQL or database programming experience required Learn how to design efficient, reliable SQL Server databases Define efficient tables, table relationships, fields, and constraints Make the most of T-SQL’s SELECT and UPDATE statements Work effectively with simple and complex views and joins Master stored procedure techniques every developer should know Build and use powerful User-Defined Functions (UDFs) Secure databases with authentication, roles, permissions, and principals Configure, maintain, and tune SQL Server for maximum reliability, performance, and value Back up, restore, and audit databases Optimize databases with the SQL Server Profiler, System Monitor, and Index Tuning Wizard Leverage valuable insight and time saving techniques from a world renowned database expert Register your book at informit.com/register for access to source code, example files, updates, and corrections as they become available.

Stephens' C# Programming with Visual Studio 2010 24-Hour Trainer
Stephens' C# Programming with Visual Studio 2010 24-Hour Trainer

Author: Rod Stephens

Publisher: John Wiley & Sons

Published: 2010-05-17

Total Pages: 554

ISBN-13: 0470596902

DOWNLOAD EBOOK

A unique book-and-DVD package from preeminent programminginstructor Rod Stephens Visual C# has become a leading programming language, resultingin greater career opportunities for Visual C# programmers. ThisWrox guide literally shows novice programmers how to program in C#with Microsoft Visual Studio, using both written and visualinstruction. Easy-to-follow lessons reinforced with step-by-stepinstructions, screencasts, and supplemental exercises make it easyto master Visual C# programming regardless of your learning style.Each lesson begins with a discussion of a concept or technique andproceeds through step-by-step directions for using the techniqueVisual C# has surpassed Visual Basic as the most popularprogramming language Coverage Includes: Getting Started with the Visual Studio IDE Creating Controls Making Controls Arrange Themselves Handling Events Making Menus Making Tool Strips and Status Strips Using RichTextBoxes Using Standard Dialogs Creating and Displaying New Forms Building Custom Dialogs Using Variables and Performing Calculations Debugging Code Understanding Scope Working with Strings Working with Dates and Times Using Arrays and Collections Using Enumerations and Structures Making Choices Repeating Program Steps Handling Errors Preventing Bugs Defining Classes Initializing Objects Fine-Tuning Classes Overloading Operators Using Interfaces Making Generic Classes Reading and Writing Files Using File System Classes Printing Using the Clipboard Providing Drag and Drop Localizing Programs Programming Databases LINQ to Objects LINQ to SQL Drawing with GDI+ Making WPF Applications Printing with WPF Note: As part of the print version of this title, videolessons are included on DVD. For e-book versions, video lessons canbe accessed at wrox.com using a link provided in the interior ofthe e-book.

Access 2013 Absolute Beginner's Guide
Access 2013 Absolute Beginner's Guide

Author: Alison Balter

Publisher: Que Publishing

Published: 2013-04-18

Total Pages: 456

ISBN-13: 0133260895

DOWNLOAD EBOOK

Make the most of Access 2013—without becoming a technical expert! This book is the fastest way to master Access and use it to build powerful, useful databases of all kinds—even web application databases! Even if you’ve never used Access before, you’ll learn how to do what you want, one incredibly clear and easy step at a time. Access has never, ever been this simple! Who knew how simple Access® 2013 could be? This is the easiest, most practical beginner’s guide to using Microsoft’s incredibly powerful new Access 2013 database program... simple, reliable instructions for doing everything you really want to do! Here’s a small sample of what you’ll learn: • Create tables to efficiently store and navigate your data • Build queries that retrieve exactly the information you want • Design intuitive forms that help your users work more efficiently • Build reports that answer key questions intuitively and visually • Learn easy techniques for designing more reliable databases • Work faster with AutoForms, AutoReports, and other shortcuts • Automate repetitive tasks and build more polished databases with macros • Share Access data with Excel, SQL Server, and other applications • Solve complex problems with advanced query, form, and reporting techniques • Build modern web databases that serve users through browsers • Run your database on the cloud through Microsoft Office 365 • Construct a complete database application from start to finish • And much more... Alison Balter, President of InfoTech Services Group, Inc., has spent 25 years training and consulting on Microsoft Access and related applications with top organizations such as Cisco, Shell, Accenture, Northrop, the U.S. Drug Enforcement Administration, Prudential, Transamerica, Fox Broadcasting, and the U.S. Navy. She travels throughout North America delivering seminars on Access and has authored 14 books and videos for Pearson, including Microsoft Access 2010 LiveLessons and Alison Balter’s Mastering Access 2007 Development. She is past president of the Independent Computer Consultants Association of Los Angeles. Category: Databases Covers: Microsoft® Access® 2013 User Level: Beginning

JavaScript 24-Hour Trainer
JavaScript 24-Hour Trainer

Author: Jeremy McPeak

Publisher: John Wiley & Sons

Published: 2010-12-01

Total Pages: 458

ISBN-13: 0470647833

DOWNLOAD EBOOK

A unique book-and-DVD package offers a new level of learning JavaScript JavaScript has matured from making Web pages dynamic to making them interactive, providing users with a rich and memorable Web experience. This unique book-and-DVD package prepares you for the new generation of Web browser changes that are occurring on the ever-evolving Web and shows you how JavaScript is an essential component of those changes. Veteran author Jeremy McPeak provides you with helpful lessons in the text, and the DVD offers instructional demonstrations so you can see how JavaScript works in the real world. Begins with the fundamentals of programming with the JavaScript language Builds on basic concepts and applies them to creating Web applications and programming the browser with JavaScript Offers invaluable advice for avoiding common mistakes, debugging code, and handling errors Includes enhanced coverage of each lesson on the DVD, which also offers detailed examples Explores JavaScript best practices With the book-and-DVD package of JavaScript 24-Hour Trainer, you'll benefit from a total learning experience!

ASP.NET 4 24-Hour Trainer
ASP.NET 4 24-Hour Trainer

Author: Toi B. Wright

Publisher: John Wiley & Sons

Published: 2010-07-06

Total Pages: 554

ISBN-13: 0470596910

DOWNLOAD EBOOK

This unique book-and-video package introduces ASP.NET 4 to programmers Microsoft ASP.NET allows you to build dynamically generated Web pages from database content. Written by a well-known authority on ASP.NET, this book-and-DVD package is an ideal place to start learning about the capabilities of ASP.NET 4. Each lesson covers both the ASP.NET Web Forms Framework and the ASP.NET MVC 2 Framework and is designed to teach you the fundamentals of the topic before progressing to a step-by-step tutorial. An instructional video for each of the 48 tutorials is provided on the DVD that accompanies the book. Lessons include: Anatomy of an HTML Page Using Common HTML Tags Adding Style to an HTML Page State Management in ASP .NET 4 Configuring Your Web Application Web Site Projects vs. Web Application Projects ASP.NET Web Forms Web Application ASP.NET MVC Web Application The Page Life Cycle in Web Forms The Request Life Cycle in MVC Server Controls in Web Forms HTML Helpers in MVC Master Pages Skins and Themes in Web Forms Partial Views in MVC Validation Controls in Web Forms Validation Helpers in MVC Dynamic Data in Web Forms Display Templates in MVC Dynamic Data Templates in Web Forms Using the AJAX Extensions in Web Forms Using jQuery for Ajax in Web Forms Authentication ASP.NET 4 24-Hour Trainer is an exceptional book-and-video package ideal for everyone from beginners to more advanced developers.

Knight's 24-Hour Trainer
Knight's 24-Hour Trainer

Author: Brian Knight

Publisher: John Wiley & Sons

Published: 2011-11-30

Total Pages: 355

ISBN-13: 1118287444

DOWNLOAD EBOOK

A unique book-and-video package for learning Microsoft SQL Server Integration Services If you need a practical, hands-on introduction to Microsoft SQL Server 2008 Integration Services (SSIS), this book and video package from foremost SSIS authority Brian Knight gets you thoroughly up to speed. Each lesson in the book includes three major components: a thorough description of how each SSIS feature or process works; a tutorial that walks you through the process or technique; and a video lesson that demonstrates it. If you take full advantage of this comprehensive package, you will gain enough experience to tackle your first SSIS project with confidence. SQL Server Integration Services 2008 (SSIS) builds on the revolutionary database product suite first introduced by Microsoft in 2005 and is a powerful tool for performing extraction, transformation, and load (ETL) operations essential to data warehousing If you're just learning SSIS, the step-by-step tutorials in this book and DVD training package will ready you to tackle your own first project Every lesson in the book is supplemented by instructional video on the DVD Note:As a part of this title, video lessons are included on DVD. For the e-book versions, video lessons can be accessed at wrox.com using a link provided in the interior of the e-book.