- Table View
- List View
You're beyond the basics, so dive right in and customize, automate, and extend Access--using Visual Basic® for Applications (VBA). This supremely organized reference is packed with hundreds of time-saving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Discover how the experts use VBA to exploit the power of Access--and challenge yourself to new levels of mastery! Enhance your application with VBA built-in functions and SQL code Use the Access Object Model to work with data in forms and reports Manipulate data using SQL, queries, and recordsets with Data Access Objects (DAO) Create classes for handling form and control events Connect your Access database to different sources of data Effectively plan how to upsize an existing Access database to Microsoft SQL Server® Dynamically update Microsoft Excel® spreadsheets from the database Migrate your Access database directly to the cloud using SQL AzureTM
Conquer Microsoft Access 2013--from the inside out! You're beyond the basics, so dive right into Access 2013--and use your skills to create sophisticated database apps! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Discover how the experts tackle Access 2013--and challenge yourself to new levels of mastery. Build an Access Services web app with Microsoft SharePoint Server Automate your Access web app with data macros Create tables in your Access web app using built-in templates Aggregate and display your web app data using totals queries Use the Autocomplete control to quickly search for related data Create a Summary view to consolidate and group information Display related data on your views with the Related Items control Package your web app for use by others in your organization Plus--download chapters on building desktop databases For Intermediate and Advanced Users and Database Designers
Teach yourself the fundamentals of ADO.NET 2.0--one step at a time. With this practical, learn-by-doing tutorial, you get the guidance you need to start creating data centric applications for Microsoft Windows and the Web. Discover how to: Work in the Microsoft Visual Studio 2005 development environment Use the ADO.NET 2.0 classes in either Visual Basic or Visual C# Connect to and manipulate different data sources: Microsoft SQL Server, XML, OLE DB Create ADO.NET objects at either design time or run time Use visual design tools Sort, filter, and manipulate data Build data-bound Windows Forms and Web Forms Work with validation controls Read and write XML data and schemas CD features: Code samples Sample databases A Note Regarding the CD or DVD The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to firstname.lastname@example.org.
Teach yourself the fundamentals of Web development with ASP.NET 4-one step at a time. With STEP BY STEP, you get the guidance and learn-by-doing examples you need to start building Web applications and Web services in the Microsoft Visual Studio® 2010 environment. The author-a highly regarded programming expert, writer, and instructor-illuminates ASP.NET features through practical examples that help developers quickly grasp concepts and apply techniques to the real world. The book also includes a companion CD with code samples, data sets, and a fully searchable eBook. A Note Regarding the CD or DVD The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to email@example.com.
This fast-paced guide enables developers to design and build Enterprise applications for the cloud. You will find it easy to follow this book, as the authors use an actual online portal application for the case study. Throughout the development of the sample application there is discussion of important considerations for moving an application into the cloud. If you provide technological leadership to their enterprise--senior developers, architects, CIO/CTO and you want or need to guide your enterprise's application design to Azure, this is the perfect book for you! Since the examples are in .NET, the book will skew to MS-oriented developers. But a lot of what is discussed will be applicable to anyone wanting to work with Azure. No matter what language you use, you provision the application fabric the same way, and all the underlying concepts will be the same. You will need experience with Visual Studio, and some basic SQL Server knowledge.
A practical guide into the architecture and features that make up the services and components of the ESB Toolkit.This book is for experienced BizTalk developers, administrators, and architects, as well as IT managers and BizTalk business analysts. Knowledge and experience with the Toolkit is not a requirement.
Bridge the big data gap with Microsoft Business Intelligence Tools for Excel AnalystsThe distinction between departmental reporting done by business analysts with Excel and the enterprise reporting done by IT departments with SQL Server and SharePoint tools is more blurry now than ever before. With the introduction of robust new features like PowerPivot and Power View, it is essential for business analysts to get up to speed with big data tools that in the past have been reserved for IT professionals. Written by a team of Business Intelligence experts, Microsoft Business Intelligence Tools for Excel Analysts introduces business analysts to the rich toolset and reporting capabilities that can be leveraged to more effectively source and incorporate large datasets in their analytics while saving them time and simplifying the reporting process.Walks you step-by-step through important BI tools like PowerPivot, SQL Server, and SharePoint and shows you how to move data back and forth between these tools and ExcelShows you how to leverage relational databases, slice data into various views to gain different visibility perspectives, create eye-catching visualizations and dashboards, automate SQL Server data retrieval and integration, and publish dashboards and reports to the webDetails how you can use SQL Server's built-in functions to analyze large amounts of data, Excel pivot tables to access and report OLAP data, and PowerPivot to create powerful reporting mechanismsYou'll get on top of the Microsoft BI stack and all it can do to enhance Excel data analysis with this one-of-a-kind guide written for Excel analysts just like you.
This book introduces C# programming through simple game creation and presents real-world scenarios to illustrate how these skills can be used in more practical C# programming applications. Tricks, traps, and boxes on real-world situations are included.
We all have to work for a living--so why not make that time work for you? Whether you're in a cubicle or corner office, the Crabby Office Lady shows you how to be more productive on the job so that you can really enjoy your time off the job. Humorous but practical, the lovable know-it-all reveals her secrets in this easy-to-read survival guide based on her popular column. You'll get her no-nonsense lessons to succeeding at work, as well as tips and tricks for working with Microsoft Office programs to help simplify your life. She'll give you the straight scoop--so pay attention! Crabby says, "Listen up!"--and discover how to: Manage your daily barrage of email, run effective meetings, and delegate (you might actually get some work done) Mind your workplace manners (and learn to deal with those who don't) Use Crabby's secrets for preparing for performance reviews and building your case for raises Customize Office program settings, use accessibility features, and practice healthy ergonomics to make your office your own Decode convoluted computer terms Take the stress out of fleeing--and enjoy your time off--with Crabby's get-away-from-it-all checklist
This book is intended for application consultants, controllers, CFOs, and other professionals who are engaged in a Microsoft Dynamics AX implementation project. Basic knowledge of financial terms, concepts, and Microsoft Dynamics AX terminologies is required.
If you are new to Dynamics CRM or a seasoned user looking to enhance your knowledge of the platform, then this book is for you. It is also for skilled developers who are looking to move to the Microsoft stack to build business solution software.
As a cookbook, this book enables you to solve real-world Dynamics GP problems with immediately useable recipes that unleash the powerful functionality of Dynamics GP. The book provides tips, techniques, and solutions designed to show users how to improve their use of Dynamics GP, not simply perform basic tasks. If you are a Dynamics GP user or Dynamics GP partner primarily focused on delivering time-proven application optimizations, then this book is for you. This book assumes that you have a basic understanding of business management systems, with basic knowledge of Microsoft Dynamics GP. All the recipes are real-world tested and designed to be used immediately.
Part tutorial, part reference guide, this book will show you how to create and manage reports as well as identify the most appropriate reporting tool for any reporting challenge. In addition, you will learn universal topics such as how to locate data for any given report. Although some of the reporting tools addressed in this book are exclusive to Dynamics GP 2010, many of the topics discussed also apply to older versions of GP. If you are a Microsoft Dynamics GP developer, consultant, or power user who wants to create and manage reports, then this book is for you. A working knowledge of Microsoft Dynamics GP is required. A basic understanding of business management systems and reporting applications such as Microsoft Excel and SQL Reporting Services is highly recommended.
Microsoft Dynamics GP 2013 Cookbook is a highly practical beginner to intermediate Cookbook to improve your efficiency and master your use of Microsoft Dynamics GP 2013. All the recipes are time-proven; real-world tested, and designed to be used immediately.If you're a Dynamics GP partner or Dynamics GP user, primarily focused on delivering application optimizations, then "Microsoft Dynamics GP 2013 Cookbook" is for you.This book assumes that you have a basic knowledge of Microsoft Dynamics GP, a basic understanding of business management systems, and some exposure to Microsoft SQL Server.
A standard tutorial-based approach covering Microsoft Dynamics GP 2013 and its six financial modules. The book is intended to allow users to improve their system use and workflow by introducing new modules to assist in financial management.This book is for you if you're a Dynamics GP partner, or Dynamics GP user, primarily focused on delivering application optimizations. This book assumes that you have a working knowledge of Microsoft Dynamics GP and have an understanding of the requirements of financial management.
A practical guide to creating and managing reports as well as identifying the most appropriate reporting tool for any reporting challenge, this book employs real-life, step-by-step examples in a part tutorial, part reference manner.If you are a Microsoft Dynamics GP developer, consultant or power user who wants to create and manage reports, then "Microsoft Dynamics GP 2013 Reporting, Second Edition" is for you. A working knowledge of Microsoft Dynamics GP is required. A basic understanding of business management systems and reporting applications such as Microsoft Excel and SQL Reporting Services is highly recommended.
If you're accountable for accounting in a mid-level business, Microsoft Dynamics GP accounting software can be your friend. Microsoft Dynamics GP For Dummies improves the friendship by highlighting the most useful and practical features, dispelling the most common misconceptions, and letting you in on the best tips and tricks -- all in plain English!Microsoft Dynamics GP For Dummies shows you how to set up and use this modular accounting program. You'll learn to customize Dynamics Great Plains, get around the program, create a company, build an effective chart of accounts, and maintain a general ledger. You'll find out how to:Create invoices and bill your customers, manage receipts, and easily match payments to invoicesSet up vendors quickly and easilyCustomize GP fit your business perfectly and make the home page more efficientWork with the modules you'll use most often in the Purchasing, Sales, Inventory, and Financial seriesSafeguard your database and set up a disaster recovery plan containing all the right stepsUse Professional Services Tools and utilities to find and fix data discrepanciesGet inventory under controlClose your books at year end and use shortcuts to easily print reports from all the data you've collectedSave keystrokes with Quick Journal and batch frequencyLeverage the interoperability between Dynamics GP and Microsoft Office applicationsMake upgrading hassle-freeMicrosoft Dynamics GP For Dummies helps you make this sometimes-complex program do your bidding, which might account for your rising popularity in the office!Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
Microsoft Excel 2010 Complete is designed for beginning users. It demonstrates the tools and features for this program in an easy-to-follow, hands-on approach. Students will learn to use the application through a variety of activities, simulations, and case projects. This self-paced, step-by-step book makes learning easy and enjoyable. End-of-lesson exercises reinforce the content covered in each lesson and provide students with the opportunity to apply the skills that they have learned.
Microsoft Office Excel 2010, Comprehensive provides a project-based, step-by-step approach to teach students Microsoft Excel 2010 skills.
Conquer Microsoft® Excel® formulas and functions--from the inside out! You're beyond the basics, so dive right in and really put Excel formulas and functions to work! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Discover how the experts increase their data analysis capabilities using Excel 2003, 2007, or 2010--and challenge yourself to new levels of mastery. Customize Excel formulas using 350+ built-in functions Create reusable formulas for common calculations Learn smarter ways to calculate date and time values Systematically search worksheets with lookup and reference functions Perform advanced calculations using mathematical, statistical, and financial functions Build complex formulas by nesting one function inside of another Analyze profit margins and more with new functions in Excel 2010 Develop your own functions with Visual Basic® for Applications (VBA)
You're beyond the basics, so dive in and really put your spreadsheet skills to work! This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Discover how the experts tackle Excel 2010-and challenge yourself to new levels of mastery!Learn expert techniques for designing powerful spreadsheets Apply built-in functions-or write your own-and carry out complex calculations Use rich charting and graphic capabilities to visualize data Perform sophisticated data analysis: financial, statistical, and "what-if" Design PivotTable reports to dynamically analyze data Share and collaborate with others-while managing sensitive data Link and embed Excel data into other documents Create macros with Microsoft Visual Basic® for Applications Sample spreadsheets from inside the book Add-ins and other resources to help you extend Microsoft Office programs Links to demos, user communities, and product support
This book outlines how to organize, analyze, and present data in Microsoft Excel 2010.
Experience learning made easy-and quickly teach yourself how to organize, analyze, and present data with Excel 2010. With STEP BY STEP, you set the pace-building and practicing the skills you need, just when you need them! Topics include creating formulas, calculating values, and analyzing data; presenting information visually with graphics, charts, and diagrams; building PivotTable dynamic views; using the new Excel Web App; reusing information from databases and other documents; creating macros to automate repetitive tasks and simplify your work; and other core topics.
Master business modeling and analysis techniques with Microsoft Excel 2013, and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables--and how to effectively build a relational data source inside an Excel workbook. Solve real business problems with Excel--and sharpen your edge Summarize data with PivotTables and Descriptive Statistics Explore new trends in predictive and prescriptive analytics Use Excel Trend Curves, multiple regression, and exponential smoothing Master advanced Excel functions such as OFFSET and INDIRECT Delve into key financial, statistical, and time functions Make your charts more effective with the Power View tool Tame complex optimization problems with Excel Solver Run Monte Carlo simulations on stock prices and bidding models Apply important modeling tools such as the Inquire add-in
Get the guide that makes learning Microsoft Excel plain and simple! This full color, no-nonsense book shows you the quickest ways to solve a problem or learn a skill, using easy-to-follow steps and concise, straightforward language. You'll analyze, manage, and share information in more ways than ever before. Here's WHAT you'll learn: Manage your financial data and personal expenses Get started quickly with prebuilt templates Create formulas and functions to do the hard work Sort, filter, update, and copy your data Use charts and graphics to bring data to life Collaborate with colleagues by sharing spreadsheets online Here's HOW you'll learn it: Jump in whenever you need answers Easy-to-follow STEPS and SCREENSHOTS show exactly what to do Handy TIPS teach new techniques and shortcuts Quick TRY THIS! exercises help apply what you learn right away