Providing complete and authoritative coverage of all aspects of VBA programming for Access applications, this book uses real-world code examples to demonstrate each programming topic
Introductory chapters provide a brief overview of VBA and highlight what’s new in Access 2007, the most popular database system in the world
Shows experienced VBA developers and programmers how to create secure VBA code and examines how to use VBA with ADO, SQL, APIs, or other Office applications
Demonstrates how to use the Access object model, the Windows registry, and ADE tools, and explains how to use VBA to create and enhance forms and reports
The companion Web site includes updates to the book and links to useful resources
TABLE OF CONTENT:
Chapter 01 - Introduction to Microsoft Access
Chapter 02 - Access, VBA, and Macros
Chapter 03 - New Features in Access 2007
Chapter 04 - Using the VBA Editor
Chapter 05 - VBA Basics
Chapter 06 - Using DAO to Access Data
Chapter 07 - Using ADO to Access Data
Chapter 08 - Executing VBA
Chapter 09 - VBA Error Handling
Chapter 10 - Using VBA to Enhance Forms
Chapter 11 - Enhancing Reports with VBA
Chapter 12 - Customizing the Ribbon
Chapter 13 - Creating Classes in VBA
Chapter 14 - Extending VBA with APIs
Chapter 15 - SQL and VBA
Chapter 16 - Working with Office Applications
Chapter 17 - Working with SharePoint
Chapter 18 - Database Security
Chapter 19 - Understanding Client/Server Development with VBA
Chapter 20 - Working with the Win32 Registry
Chapter 21 - Using the ADE Tools
Chapter 22 - Protecting Yourself with Access 2007 Security
Download from RAPIDSHARE
or
Download from IFILE
password:knowfree.net
We know from the success of titles such as Web Standards Solutions , Cascading Style Sheets: Separating Content from Presentation, and the Web Designer’s Reference that web designers are increasingly concerned with making sites that don’t just look pretty, but are also built using current best practices. There are three main technologies married together to create usable, standards-compliant web designs: XHTML for data structure, Cascading Style Sheets for styling your data, and JavaScript for adding dynamic effects and manipulating structure on the fly using the Document Object Model. This book is about the latter of the three. DOM Scripting: Web Design with JavaScript and the Document Object Model gives you everything you need to start using JavaScript and the Document Object Model to enhance your web pages with client-side dynamic effects. Jermey starts off by giving you a basic crash course in JavaScript and the DOM, then move on to provide you with several real world examples built up from scratch including dynamic image galleries and dynamic menus, and show you how to manipulate web page style using the CSS DOM, and create markup on the fly.
* Cascading Style Sheets (CSS) is a Web markup standard that allows Web designers to define the appearance and position of a Web page using special dynamic effects
The Essential Guide to CSS and HTML Web Design is a special book—it will tell you all you need to know to design great web sites that are standards compliant, usable, and look great, but not overwhelm you with waffle, theory, and obscure details. It is designed to be invaluable to you, whatever stage you are at in your career, with a mixture of practical tutorials and reference material—beginners will quickly pick up the basics, while more experienced web designers and developers will keep returning to the book again and again to recap on techniques they maybe haven’t used for a while, or look up properties, attributes and other details. It is destined to become a close friend, adopting a permanent place on your desk. It starts off by giving a brief introduction to the internet, and the broad area of web design, before diving straight in to HTML and CSS basics, reusing code, other best practices. It then focuses on all the most important areas of a successful web site—typography, images, navigation, tables, layouts, forms and feedback (including ready made PHP scripts for you to use,) and browser quirks, hacks and bugs. The book is completely up-to-date, covering support of the newest standards in all the latest browsers, including IE 7 and Firefox 2. The last chapter of the book provides several case studies for you to dissect and learn from, including all the most popular web site archetypes—a blog, a store front, a corporate home page, and an online gallery. Then the book is rounded off with several detailed reference appendices covering CSS, HTML, Color references, entities, and more, meaning that any details you need to look up are close at hand.