Microsoft Access is the most popular database system in the world, and this guide shows you how to build Access database applications using Microsoft Access 2010. Beginners to intermediate-level readers are exposed to the basics of building and working with the major Access 2010 features. Over 60 lessons are included in this book-and-DVD combo, which provides step-by-step examples that show exactly how you can implement each feature in a real-world Access database application. The accompanying DVD provides clear, easy-to-follow videos of the authors demonstrating the examples in each lesson, as well as extra commentary, so that no reader is left behind!
Microsoft Access 2010 24-Hour Trainer:
Shows you how to build database applications from scratch and from existing database templates
Walks you through major components including the Navigation Pane, the 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 like the Access 2010 Macro Designer, Data Macros, and the Ribbon Options dialog
Explains how to customize the Access Backstage
Details basic VBA code writing and explains how and when to use it
Wrox guides are crafted to make learning programming languages and technologies easier than you think. Written by programmers for programmers, they provide a structured, tutorial format that will guide you through all the techniques involved.
On the DVD
Don't just learn—do!
The lessons within the book are each accompanied by an instructional demonstration on the DVD—nearly 5 hours of video tutorials!
You'll learn to:
Install Access 2010 and open a database file from Windows
Create a new database application
Handle database objects
Use the Access 2010 Ribbon
Create lists from tables, queries, or system objects
Modify tables and fields
Embed macros and code in reports
Form queries in the wizard
Customize the Navigation Pane and Ribbon
Work with Access security
Please see the DVD appendix for details and complete system requirements.
Truitt L. Bradly, a Microsoft Access MVP, is an accountant, analyst, and developer who has developed several database applications using Access and SQL Server. He is the coauthor of Microsoft Access Small Business Solutions.