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 is the leading database that is used worldwide
While VBA remains the favored method for Access programming, more options are available for Access 2010, and this book covers them all
Covers the Access Object model, using VBA with ADO, VBA execution and error handling, creating database objects, creating and enhancing forms and reports, using the Windows Registry, and much more
Explains how to use VBA with SQL, APIs, and other Office applications, and how to create secure VBA code
Companion Web site provides updates and links to useful resources
Access 2010 Programmer’s Referenceis a comprehensive guide to the best-of-breed techniques for programming Access applications.

Практически любой пользователь компьютера, да и в принципе любой человек, сталкивался с необходимостью систематизировать и упорядочить различные данные, будь то список фильмов в домашней видеотеке, результаты игры любимой футбольной команды или же финансовая отчетность крупной компании. Безусловно, с появлением и широким распространением персональных компьютеров делать это стало гораздо проще.
Данная книга посвящена самой популярной и востребованной на сегодня системе управления базами данных - Microsoft Access. Несмотря на кажущуюся сложность, овладеть этой программой совсем просто. Если вы держите в руках эту книгу, то первый шаг уже сделан.

В книге дается описание среды Access 2003, ее объектов и способов работы с данными, как своими, так и импортированными из других источников. Приводится краткое введение в теорию реляционных баз данных и систем управления базами данных (СУБД). Подробно описаны процедуры создания довольно сложных объектов баз данных. Приведены примеры типичных задач, которые постоянно приходится решать разработчикам приложений. Описаны основные средства программирования приложений Access: язык программирования VBA, объектные модели, разработка Web-приложений и способы интеграции приложений Access с другими приложениями Microsoft Office. Рассмотрены вопросы создания профессиональных многопользовательских сетевых баз данных и проектов, а также администрирования баз данных и проектов Access.
Для широкого круга пользователей.

Get the guide that makes learning Microsoft Access 2010 plain and simple! This full color, no-nonsense book shows you the quickest ways to build a database and sort information, using easy-to-follow steps and concise, straightforward language. You'll learn how out-of-the-box templates and reusable components make Access 2010 a fast and simple database solution.
Here's WHAT you'll learn:
Design and build your own database quickly
Use Access forms to collect information with ease
Create and modify tables to organize your data
Store files such as documents and images
Exchange data with other databases and documents
Bring your data alive with colorful reports
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

Produced by the award-winning maranGraphics Group, "Maran Illustrated™ Microsoft® Access 2003" is a valuable resource for all readers, regardless of experience. Clear, step-by-step instructions walk the reader through each operation from beginning to end. Helpful topic introductions and useful tips provide additional information and advice to enhance the readers’ Access 2003 experience and help meet their individual needs. "Maran IllustratedTM Microsoft® Access 2003" is packed with information useful to readers who have purchased their first computer and are learning Access 2003 for the first time. Readers who have experience with older versions of Access will find this book an excellent guide to help them take command of their computing experience, by way of the easy-to-use maranGraphics format. Readers have the option of reading the book from cover to cover, or simply reading the individual topics they are interested in.

Go from Access novice to true master with the professional database design tips and crystal-clear explanations in this book. You’ll learn all the secrets of this powerful database program so you can use your data in creative ways — from creating product catalogs and publishing information online to producing invoices and reports.

* Build a database with ease. Store information to track numbers, products, documents, and more
* Customize the interface. Build your own forms to make data entry a snap
* Find what you need fast. Search, sort, and summarize huge amounts of information
* Put your data to use. Turn raw info into printed reports with attractive formatting
* Share your data. Collaborate online with SharePoint and the brand-new Access web database
* Dive into Access programming. Get tricks and techniques to automate common tasks
* Create rich data connections. Build dynamic links with SQL Server, SharePoint, and other systems

A friendly, step-by-step guide to the Microsoft Office database application
Access may be the least understood and most challenging application in the Microsoft Office suite. This guide is designed to help anyone who lacks experience in creating and managing a database learn to use Access 2010 quickly and easily.
In the classic For Dummies tradition, the book provides an education in Access, the interface, and the architecture of a database. It explains the process of building a database, linking information, sharing data, generating reports, and much more.

Access is the most widely used database software in the world, with 50 million regular users and an installed base of 80 million desktops. This title shows everyday Access users how to extract database data more efficiently and create reportsat better organize and display the information they need for planning, decision-making, and presentations. The topics covered include fine-tuning queries with simple tricks, harnessing SQL to expand queries, adding controls to build better forms, using multiple tables in a form, creating data summary reports, souping up reports with lookup lists and macro buttons, sharing data with Excel, exporting reports to Word, and troubleshooting queries, forms, and reports. Techniques in the book are applicable to all versions of Access, and are illustrated with lots of detailed examples.

Database models developed by a team of leading Microsoft Access MVPs that provide ready-to-use solutions for sales, marketing, customer management and other key business activities for most small businesses.


As the most popular relational database in the world, Microsoft Access is widely used by small business owners. This book responds to the growing need for resources that help business managers and end users design and build effective Access database solutions for specific business functions.

На этом компакт-диске находится мультимедийный видеокурс по работе с На этом компакт-диске находится мультимедийный видеокурс по работе с Microsoft Access 2007 по материалам книги Бекаревич Ю.Б., Пушкина Н.В: "Самоучитель Microsoft Access 2007"