Access 2007: The Missing Manual
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...
Search in google:
Written from the ground up for this redesigned application, this guide will help readers design and maintain complete databases, search for valuable nuggets of information, and build attractive forms for quick-and-easy data entry.
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 ToolbarColophonMatthew MacDonald is an author, educator, and programmer extraordinaire. He's the author of over a dozen books about .NET programming, and the author of Excel: The Missing Manual. In a dimly remembered past life, he studied English literature and theoretical physics.
