Build Access tables using good relational database techniques
Construct efficient databases using a five-step design method
Design efficient data-entry and data display forms
Utilize the improved Access report designer
Use Visual Basic(r) for Applications and the VBA Editor to automate applications
Build and customize Access 2007 ribbons
Seamlessly exchange Access data with SharePoint(r)
Employ advanced techniques such as the Windows(r) API and object-oriented programming
Add security and use data replication in your Access applications
Access 2007 For Dummies
By Laurie Ulrich Fuller, Ken Cook, John Kaufeld
Publisher Wiley
Available Now
Reduce stress with timesaving database shortcuts
Explore database basics and build tables and reports that corral your data
Access has undergone an extreme makeover! Whether you've used one of the older versions or this is your first exposure to Access, here's where you'll find the essentials you need to make this database system work for you. Cruise around the new interface, team up Access with other office applications, use wizards to automate your work, and much more.
Discover how to
* Create a new Access database
* Import and export data
* Build forms for efficient data entry
* Search tables for specific data
* Construct custom reports
* Customize your database navigation
Access 2007 For Starters: The Missing Manual
By Matthew MacDonald
Publisher O’Reilly
Available Now
This fast-paced book teaches you the basics of Access 2007 so you can start using the program right away. You'll learn how to design databases, maintain them, search for valuable nuggets of information, and build attractive forms for quick-and-easy data entry. The new Access is radically different from previous versions, but with this book, you'll breeze through the new interface and its timesaving features in no time.
Access 2007: The Missing Manual
By Matthew MacDonald
Publisher O’Reilly
Available Now
Access 2007: The Missing Manual was written from the ground up for this redesigned application. You will learn how to design complete databases, maintain them, search for valuable nuggets of information, and build attractive forms for quick-and-easy data entry. You'll even delve into the black art of Access programming (including macros and Visual Basic), and pick up valuable tricks and techniques to automate common tasks -- even if you've never touched a line of code before. You will also learn all about the new prebuilt databases you can customize to fit your needs, and how the new complex data feature will simplify your life. With plenty of downloadable examples, this objective and witty book will turn an Access neophyte into a true master.
Access 2007 VBA Programmer 's Reference
By Teresa Hennig, Robert G. Cooper, Geoffrey L. Griffith, Armen Stein
Publisher Wrox
Pub Date 4/30/07
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
How to Do Everything with Microsoft Office Access 2007
By Virginia Andersen
Publisher McGraw-Hill/Osborne
Available Now
Maximize the powerful features of the latest release of today's most popular desktop database program. How to Do Everything with Microsoft Office Access 2007 shows you how to create and customize an efficient, multi-user database, retrieve, interpret, and share your data, secure your information, and much more. Designed to help you get things done quickly and easily, this user-friendly guide is your all-access pass to Access 2007.
Navigate the new user interface with ease
Design a well-organized database using pre-designed templates
Enter and edit data and ensure data validity
Sort, filter, and print records
Extract specific information using queries
Master form and report design basics
Add charts and graphs to forms and reports easily
Optimize database performance and speed
Exchange database objects and text files between Access databases
Microsoft Office Access 2007 Data Analysis
By Michael Alexander
Publisher Wiley
Available Now
Go beyond Excel(r) with Access's more powerful analysis capabilities
Get better visibility into your data with custom views
Scale up your data pool without limitation
Master the four fundamentals of data analysis
Discover shortcuts with the helpful Input Mask Wizard
Integrate your data with the web and enterprise data sources
Avoid the common pitfalls of data crunching
Harness VBA to improve data analysis
Leverage information from the field with real-world scenarios
Microsoft® Office Access 2007 Inside Out
By John Viescas and Jeff Conrad
Publisher Microsoft Press
Pub Date 5/09/07