Description
Join the millions of people already using Microsoft Access and become a database power-user in no time!
In the newly revised edition of Microsoft Access For Dummies, professional database developer and Access extraordinaire Laurie Ulrich-Fuller walks you through the ins-and-outs of one of the world's most popular database platforms. This is the perfect beginner's guide to Microsoft Access, showing you how to create databases, extract data, create reports, and more. The author demonstrates a ton of tips, tricks, and best practices you can use immediately to create, maintain, and improve your databases. You'll also find:
- Updates outlining edge browser controls in forms
- Step-by-step guides explaining how to import, export, and edit data
- Easy-to-follow query-writing tutorials to help you find the exact data you're looking for when you need it
Whether you're a database novice or a data science whiz, Microsoft Access For Dummies has the info you need to supercharge your database skills. It's the perfect, how-to guide to get you up-to-speed on everything you need to know to get started with Microsoft's world-famous database app.
Table of Contents
Introduction 1
Part 1: Basic Training 5
Chapter 1: Access Basics 7
Chapter 2: Finding Your Way in the Access Workspace 25
Chapter 3: Database Basics 43
Part 2: Getting It All on the Table 63
Chapter 4: Sounds Like a Plan 65
Chapter 5: Table Tune-Ups 77
Chapter 6: Remodeling Your Data 95
Chapter 7: Types, Masks, and Triggers 111
Part 3: Data Management Mania 137
Chapter 8: A Form for All Reasons 139
Chapter 9: Importing and Exporting Data 159
Chapter 10: Automatically Editing Data 173
Chapter 11: Access and the Web 185
Part 4: The Power of Questions 199
Chapter 12: Finding, Filtering, and Sorting Your Data — Fast 201
Chapter 13: I Was Just Asking for Answers 219
Chapter 14: I Want These AND Those OR Them 245
Chapter 15: Number Crunching with the Total Row 255
Chapter 16: Express Yourself with Formulas 267
Chapter 17: Take Charge with Action Queries 281
Part 5: Simple and Snazzy Reporting 293
Chapter 18: Fast and Furious Automatic Reporting 295
Chapter 19: Professionally Designed Reports Made Easy 313
Chapter 20: Groups and Page Breaks, Headers and Footers 333
Part 6: The Part of Tens 351
Chapter 21: Ten Common Problems 353
Chapter 22: Ten Uncommon Tips 365
Appendix A: Getting Help 373
Index 375
