Uh-oh, it looks like your Internet Explorer is out of date.
For a better shopping experience, please upgrade now.
Compared to industrial-strength database products such as Microsoft's SQL Server, Access is a breeze to use. It runs on PCs rather than servers and is ideal for small- to mid-sized businesses and households. But Access is still intimidating to learn. It doesn't help that each new version crammed in yet another set of features; so many, in fact, that even the pros don't know where to find them all. Access 2007 breaks this pattern with some of the most dramatic changes users have seen since Office 95. Most obvious is the thoroughly redesigned user interface, with its tabbed toolbar (or "Ribbon") that makes features easy to locate and use. The features list also includes several long-awaited changes. One thing that hasn't improved is Microsoft's documentation. To learn the ins and outs of all the features in Access 2007, Microsoft merely offers online help.
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.
About the Author
Matthew MacDonald is a science and technology writer with well over a dozen books to his name. Web novices can tiptoe out onto the Internet with him in Creating a Website: The Missing Manual. HTML fans can learn about the cutting edge of web design in HTML5: The Missing Manual. And human beings of all description can discover just how strange they really are in the quirky handbooks Your Brain: The Missing Manual and Your Body: The Missing Manual.
Table of Contents
The Missing CreditsIntroductionPart I: Storing Information in TablesChapter 1: Creating Your First DatabaseChapter 2: Building Smarter TablesChapter 3: Mastering the Datasheet: Sorting, Searching, Filtering, and MoreChapter 4: Blocking Bad DataChapter 5: Linking Tables with RelationshipsPart II: Manipulating Data with QueriesChapter 6: Queries That Select RecordsChapter 7: Essential Query TricksChapter 8: Queries That Update RecordsChapter 9: Analyzing Data with Crosstab Queries and Pivot TablesPart III: Printing ReportsChapter 10: Creating ReportsChapter 11: Designing Advanced ReportsPart IV: Building a User Interface with FormsChapter 12: Creating Simple FormsChapter 13: Designing Advanced FormsChapter 14: Building a Navigation SystemPart V: Programming AccessChapter 15: Automating Tasks with MacrosChapter 16: Automating Tasks with Visual BasicChapter 17: Writing Smarter CodePart VI: Sharing Access with the Rest of the WorldChapter 18: Sharing a Database with Multiple UsersChapter 19: Importing and Exporting DataChapter 20: Connecting Access to SQL ServerChapter 21: Connecting Access to SharePointPart VII: AppendixAppendix A: Customizing the Quick Access ToolbarColophon