Author: Arvin Meyer
Publisher: John Wiley & Sons
Release Date: 2010-09-14
Two Microsoft Access MVPs show how you can become an Access power user Microsoft Access is the world’s leading database system, with millions of users and hundreds of thousands of developers. The best practices, tips, and techniques in this book can turn users into power users. Millions of eager users make Access the most popular database system in the world These Microsoft MVPs exploit key features in Access, providing advice on techniques for capturing, sharing and reporting Access data. Each tip provides detailed solutions with clear instructions for implementation, and samples of all can be found on the companion Web site Access 2010 Solutions offers professional advice that enables every Access user to get greater value from the Access database system.
Author: John L. Viescas
Publisher: Addison-Wesley Professional
Release Date: 2017-01-09
Effective SQL brings together the hands-on solutions and practical insights you need to solve a wide range of complex problems with SQL, and to design databases that make it far easier to manage data in the future. Leveraging the proven format of the best-selling Effective series, it focuses on providing clear, practical explanations, expert tips, and plenty of realistic examples -- all in full color. Drawing on their immense experience as consultants and instructors, three world-class database experts identify specific challenges, and distill each solution into five pages or less. Throughout, they provide well-annotated SQL code designed for all leading platforms, as well as code for specific implementations ranging from SQL Server to Oracle and MySQL, wherever these vary or permit you to achieve your goal more efficiently. Going beyond mere syntax, the authors also show how to avoid poor database design that makes it difficult to write effective SQL, how to improve suboptimal designs, and how to work around designs you can't change. You'll also find detailed sections on filtering and finding data, aggregation, subqueries, and metadata, as well as specific solutions for everything from listing products to scheduling events and defining data hierarchies. Simply put, if you already know the basics of SQL, Effective SQL will help you become a world-class SQL problem-solver.
Author: Teresa Hennig
Publisher: John Wiley & Sons
Release Date: 2010-10-28
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
SQL, 데이터베이스에 맞게 효율적으로 사용하라! SQL 제대로 알고 쓰자 SQL은 DBMS마다 조금씩 다른데, 약간의 차이만 알면 서로 다른 DBMS에서도 쉽게 변형해 사용할 수 있다. 대표적인 DBMS인 오라클, SQL Server, MySQL, PostgreSQL, 액세스에서 SQL을 사용하는 방법을 비교해 보여준다. 또한, 더 나은 데이터 모델을 설계하는 방법, 쿼리 성능을 향상시키는 인덱스 구현, 유연한 서브쿼리 작성법, 계층적 데이터 모델링처럼 SQL을 제대로 쓰는 방법도 알려준다. 더 나은 코딩 노하우를 배우자 다양한 팁과 기술을 현실성 있고 검증된 코드 예제와 함께 61가지 Better way에 수록했다. 해야 할 것과 피해야 할 것, 작업 효율을 높이는 법, 왜 이것이 최선의 선택인지 조언하며 SQL을 더 효과적으로 작성할 수 있게 해준다. 제공된 코드를 직접 실행하며 이해하자 데이터베이스 디자인 최적화에서부터 계층 및 메타데이터 관리에 이르기까지 다양한 문제를 보여주고 이를 해결한다. 문제를 해결하는 데 사용된 코드를 수록했고, 코드를 직접 실행해보고 수정하며 내용을 확실하게 이해할 수 있다.
Author: Teresa Hennig
Publisher: John Wiley & Sons
Release Date: 2011-06-01
Access 2007 VBA Programmer's Reference covers a wide spectrum of programming topics relevant to Access. Although it assumes the reader has some familiarity with VBA programming language, it begins with a brief introduction to VBA. And to help you leverage the tools that Access provides, a chapter highlights the new features in Microsoft Office Access 2007 — including new wizards and GUI (graphical user interface) elements that previously required VBA code, as well as new VBA features. The book also discusses how to create and name variables, how to use Data Access Object (DAO) and ActiveX Data Object (ADO) to manipulate data both within Access and within other applications, proper error handling techniques, and advanced functions such as creating classes and using APIs. Key new objects such as using Macros and the Ribbon are explored, too, as are forms and reports, the two most powerful tools for working with and displaying data. Working with other applications is covered extensively both in a general nature and for working specifically with Microsoft Office applications, Windows SharePoint Services, and SQL Server. Of course, this book wouldn’t be complete without discussing security issues and the Developer Extensions.
Author: Helen Bell Feddema
Release Date: 2002
Provides an overview of the features and functions of the program, discussing such topics as building queries, importing and exporting data, creating reports, securing a database, and distributing an Access application.
Author: Richard M. Hicks
Release Date: 2016-09-10
Learn how to design, plan, implement, and support a secure remote access solution using DirectAccess in Windows Server 2016. Remote Access has been included in the Windows operating system for many years. With each new operating system release, new features and capabilities have been included to allow network engineers and security administrators to provide remote access in a secure and cost-effective manner. DirectAccess in Windows Server 2016 provides seamless and transparent, always on remote network connectivity for managed Windows devices. DirectAccess is built on commonly deployed Windows platform technologies and is designed to streamline and simplify the remote access experience for end users. In addition, DirectAccess connectivity is bidirectional, allowing administrators to more effectively manage and secure their field-based assets. Implementing DirectAccess with Windows Server 2016 provides a high-level overview of how DirectAccess works. The vision and evolution of DirectAccess are outlined and business cases and market drivers are explained. DirectAccess is evaluated against traditional VPN and this book describes the Windows platform technologies that underpin this solution. In addition, this book: Explains how the technology works and the specific IT pain points that it addresses Includes detailed, prescriptive guidance for those tasked with implementing DirectAccess using Windows Server 2016 Addresses real-world deployment scenarios for small and large organizations Contains valuable tips, tricks, and implementation best practices for security and performance“/li> What you’ll learn A high-level understanding of the various remote access technologies included in Windows Server 2016. Common uses cases for remote access, and how best to deploy them in a secure, stable, reliable, and highly available manner. Valuable insight in to design best practices and learn how to implement DirectAccess and VPN with Windows Server 2016 according to deployment best practices. Who This Book Is For IT administrators, network, and security administrators and engineers, systems management professionals, compliance auditors, and IT executive management (CIO, CISO) are the target audience for this title.
Windows Small Business Server 2008 provides all the tools small companies need to improve collaboration, enhance productivity, and manage and secure all their information. In this book, a team of leading SBS experts brings together the in-depth knowledge and real-world insights you need to make the most of this state-of-the-art product. Microsoft Most Valuable Professionals Eriq Neale and his colleagues cover every facet of planning, deploying, and managing SBS 2008. The authors begin by showing how to install and configure SBS 2008 for maximum efficiency, performance, and ease of administration. You’ll learn how to securely utilize SBS 2008’s comprehensive Internet, file, and print services; simplify and automate both server and workstation management; and take full advantage of both SharePoint collaboration and Exchange communication tools. This book is packed with expert tips, tricks, and troubleshooting techniques drawn from the authors’ unsurpassed experience helping companies succeed with SBS. Whether you’re a full-time IT professional or a power user who’s managing SBS in your spare time, it will be your most valuable resource. Detailed information on how to... Plan, install, configure, and customize SBS 2008 in any environment Set up and manage SBS 2008-based networks, Web access, and collaboration—including SharePoint Services 3.0 Leverage Remote Web Workplace and other advanced remote access solutions Manage email and other communications with SBS 2008’s built-in Microsoft Exchange Server 2007 Centrally control Windows Vista, Windows XP, and other clients Seamlessly integrate Macintosh computers into your Windows network Protect your servers and workstations against both internal and external threats Prepare backups and disaster recovery plans you can actually use in an emergency Streamline and automate administration using Microsoft PowerShell
“VBA for the 2007 Microsoft Office System is jam-packed with code samples that you’ll be able to reuse right away in your VBA projects.” —Guy Barrette, Microsoft MVP & Regional Director, .NET Expertise Develop your VBA expertise instantly with proven techniques VBA for the 2007 Microsoft® Office System shows you how to take full advantage of the 2007 Microsoft Office suite by automating routine Office tasks. No matter which Office application you’re using, there are some tasks you perform dozens of times, such as typing a section of text, running a series of menu commands, or formatting a document in a particular way.This book shows you how to accomplish the same tasks by incorporating them into a macro that you can run with just a few mouse clicks or keystrokes. This book shows you the basics of VBA programming from the ground up. Even if you’ve never programmed before, VBA for the 2007 Microsoft® Office System will have you up to speed with VBA in no time.You’ll learn how to write programs that control Word, Excel, PowerPoint, Access databases, and even Outlook email.You get dozens of example macros that not only illustrate the concepts in the book but also provide you with practical, business-oriented tools that you can use right away to improve your productivity. Practical, real-world examples for anyone who uses Office applications—not just power users. Automate or streamline all your repetitive Word, Excel, and PowerPoint chores. Create custom dialog boxes and custom Ribbon tabs, groups, and buttons to make Office look and work the way you want it to—no program experience required! Easy-to-understand instructions that make learning VBA fast and fun. All code examples and documents are available online so you can get started with VBA with a minimum of fuss. Automate Routine Tasks Control Word, Excel, and PowerPoint Program Access Databases Automate Document Backups Create Advanced Email Rules Build Custom Dialog Boxes Customize the Office 2007 Ribbon Access the Registry Troubleshoot Macro Problems Control Macro Security Introduction I Getting Started with VBA 1 Creating and Running Recorded Macros 2 Writing Your Own Macros 3 Understanding Program Variables 4 Building VBA Expressions 5 Working with Objects 6 Controlling Your VBA Code II Putting VBA to Work 7 Programming Word 8 Programming Excel 9 Programming PowerPoint 10 Programming Access Databases 11 Programming Outlook Email III Getting the Most Out of VBA 12 Creating Custom VBA Dialog Boxes 13 Customizing the Office 2007 Ribbon 14 VBA Tips and Techniques 15 Trapping Program Errors 16 Debugging VBA Procedures IV Appendixes A VBA Statements B VBA Functions Index
SharePoint 2013 How-To Need fast, reliable, easy-to-implement solutions for SharePoint 2013? This book delivers exactly what you’re looking for: step-by-step help and guidance with the tasks that users, authors, content managers, and site managers perform most often. Fully updated to reflect SharePoint 2013’s latest improvements and fluid new design, it covers everything from lists and views to social networking, workflows, and security. The industry’s most focused SharePoint resource, SharePoint 2013 How-To provides all the answers you need—now! Ishai Sagi is a SharePoint developer and architect who provides solutions through his company, Extelligent Design, which is Canberra, Australia’s leading SharePoint consultancy. Sagi has worked with SharePoint since it was introduced in 2001. Honored four times by Microsoft as a Microsoft Office SharePoint Server MVP, he has trained many end users, administrators, and developers in using SharePoint or developing solutions for it. He leads Canberra’s SharePoint user group and has spoken at Microsoft conferences around the world. He hosts the popular blog Sharepoint Tips and Tricks (www.sharepoint-tips.com), and authored SharePoint 2010 How-To. Fast, Accurate, and Easy-to-Use! ¿ Quickly review essential SharePoint terminology and concepts ¿ Master SharePoint 2013’s revamped interface for Windows PCs, Surface, and smartphones ¿ Run SharePoint in the cloud with Microsoft Office 365 and SkyDrive ¿ Find, log on to, and navigate SharePoint sites ¿ Create, manage, and use list items, documents, and forms ¿ Alert yourself to new or changed content ¿ Use views to work with content more efficiently ¿ Leverage SharePoint 2013’s revamped search capabilities ¿ Organize content with lists, document libraries, and templates ¿ Use powerful social networking features, including tagging, NewsFeed updates, and microblogging ¿ Author and edit each type of SharePoint page ¿ Build flexible navigation hierarchies with Managed Metadata ¿ Systematically manage site security and content access ¿ Control permissions more effectively with the Permissions Page ¿ Create and track workflows, and integrate them with lists or libraries ¿ Customize a site’s appearance, settings, and behavior ¿ Create new Office 365 private and public site collections
Author: Bill Jelen
Publisher: Que Publishing
Release Date: 2015-11-05
Excel® 2016 PIVOT TABLE DATA CRUNCHING CRUNCH DATA FROM ANY SOURCE, QUICKLY AND EASILY, WITH EXCEL 2016 PIVOT TABLES! Use Excel 2016 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours… understand exactly what’s going on in your business… take control, and stay in control! Even if you’ve never created a pivot table before, this book will help you leverage all their amazing flexibility and analytical power. Drawing on more than 40 combined years of Excel experience, Bill Jelen and Michael Alexander offer practical “recipes” for solving real business problems, help you avoid common mistakes, and present tips and tricks you’ll find nowhere else! • Create, customize, and change pivot tables • Transform huge data sets into clear summary reports • Analyze data faster with Excel 2016’s new recommended pivot tables • Instantly highlight your most profitable customers, products, or regions • Quickly import, clean, and shape data with Power Query vBuild geographical pivot tables with Power Map • Use Power View dynamic dashboards to see where your business stands • Revamp analyses on the fly by dragging and dropping fields • Build dynamic self-service reporting systems • Combine multiple data sources into one pivot table • Use Auto grouping to build date/time-based pivot tables faster vCreate data mashups with Power Pivot • Automate pivot tables with macros and VBA About MrExcel Library Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will • Dramatically increase your productivity—saving you 50 hours a year or more • Present proven, creative strategies for solving real-world problems • Show you how to get great results, no matter how much data you have • Help you avoid critical mistakes that even experienced users make Bill Jelen is MrExcel, the world’s #1 spreadsheet wizard. Jelen hosts MrExcel.com, the premier Excel solutions site, with more than 20 million page views annually. A Microsoft MVP for Excel, his best-sellers include Excel 2016 In Depth. Michael Alexander, Microsoft Certified Application Developer (MCAD) and Microsoft MVP, is author of several books on advanced business analysis with Excel and Access. He has more than 15 years of experience developing Office solutions. CATEGORY: Spreadsheets COVERS: Microsoft Excel 2016
Author: Robert Bogue
Publisher: John Wiley & Sons
Release Date: 2007-08-20
Microsoft recognizes key individuals who contribute significantly to the community of technologists through the Microsoft Most Valuable Professional (MVP) award. These individuals are active authors, speakers, bloggers, and innovators. They are also skilled network engineers, developers, trainers, designers, and architects. In the SharePoint community, these MVPs are recognized for their expertise in either Windows SharePoint Services (WSS) or Microsoft Office SharePoint Server (MOSS). This book represents the efforts of 16 MVPs in the SharePoint community to present core areas of SharePoint 2007 products and technologies seasoned with significant field experience. The idea behind the book is to lower the learning curve for the reader, while providing the insight necessary to avoid common missteps. This book is an extension of the work the authors have done in their own blogs, books, and presentations. This book is for the community of SharePoint professionals. That means that architects, designers, developers, administrators, and engineers all will find something useful in its pages. As a reader, you will want to focus on chapters that appeal to your areas of expertise directly. Some of the chapters, for example, assume a strong programming background, whereas others are centered on administration or maintenance. All readers should have some prior experience with SharePoint 2007 products and technologies to get the most out of this book, although the book does include an introductory chapter for those who are just getting started. The authors generally assume a working knowledge of SharePoint in an effort to focus the discussion on implementation and best practices. This book covers SharePoint 2007 products and technologies. Specifically, you will find topics relating to both WSS and MOSS. The topics were selected by SharePoint MVP and Editor Scot Hiller based on the authors’ capabilities to represent a cross-section of the most important areas within SharePoint. Although the chapters have been arranged in a logical order, they are intended to stand alone as independent articles. Specifically, here's what the book covers: Introduction to SharePoint by Mike Walsh: an overview of SharePoint Configuring Forms Based Authentication by Stacy Draper: different approaches to FBA, along with their strengths and weaknesses including some custom solutions to problems such as user and role management. Understanding SharePoint Administration by Todd Klindt: the basics (such as backup and recovery), more advanced topics (such as command-line utilities and tips), and techniques for managing site templates. Developing Publishing Sites the Smart and Structured Way by Andrew Connell: an alternative technique for developing Publishing sites within MOSS discusses development with the SharePoint Designer (SPD), but then challenges the conventional thinking with a new structured approach. Readers will learn new ways to ease the management and maintenance of Publishing sites. Using SharePoint Designer 2007 by Dustin Miller: This often-maligned tool can be a powerful part of your SharePoint toolkit. Customizing and Branding the SharePoint 2007 Interface by Shane Perran and Heather Solomon: One of the first tasks in any SharePoint project is branding the use interface. The reader will learn all of the different ways to customize the look and feel of SharePoint using master pages, style sheets, and graphics. Understanding Web Parts by Jan Tielens: walks the reader through the creation and deployment of Web Parts. Readers should have a strong C# programming background. Creating Workflows in WSS by Robert Bogue: Readers will learn how to create custom workflows and forms for deployment in WSS including many tips and tricks from actual field experience. Readers should have a strong C# programming background. Creating Workflow in SharePoint Server 2007 by Joris Poelmans: The big difference between WSS and MOSS workflows is the ability to use InfoPath forms. This has extensive coverage of InfoPath forms and how to use them with MOSS workflows. Using the Business Data Catalog by Nick Swan: The Business Data Catalog (BDC) is used to allow MOSS to access line-of-business databases. Includes tips to make the development process easier. Readers should be familiar with XML. Using Excel Services by Luis Du Solier Grinda: Excel Services is used to allow MOSS to present spreadsheet data to end users through a browser. This technology is a foundational element in the development of dashboards in the SharePoint Report Center. Securing SharePoint Communication by Adam Buenz: Readers will learn to implement Secure Sockets Layer (SSL), Kerberos security, and how to use the Microsoft Internet Security and Acceleration (ISA) Server. Using Information Rights Management by Jason Medero: setting up IRM and using it with SharePoint libraries to restrict document functionality (such as printing and attaching) so sensitive information does not leave an organization. Upgrading from SPS 2003 to MOSS 2007 Using the Gradual Method by Shane Young: One of the biggest trends in the SharePoint community is upgrading from SharePoint Portal Server 2003 (SPS 2003) to MOSS. This examines all of the different upgrade approaches, and then walks the reader through the gradual method for upgrading. Contains a wealth of field experience learned from performing many upgrades. This book is also available as part of the 4-book SharePoint 2007 Wrox Box (ISBN: 0470431946) with these 4 books: Professional SharePoint 2007 Development (ISBN: 0470117567) Real World SharePoint 2007 (ISBN: 0470168358) Professional Microsoft SharePoint 2007 Design (ISBN: 047028580X) Professional SharePoint 2007 Web Content Management Development (ISBN: 0470224754)