Efnisyfirlit

• Cover
• Introduction
• About This Book
• Foolish Assumptions
• Icons Used in This Book
• Where to Go from Here
• Part 1: Basic Training
• Chapter 1: Access 2019 Basic Training
• What Is Access Good For, Anyway?
• What’s New in Access 2019?
• Reach Out with SharePoint
• How Access Works and How You Work with It
• Now What?
• Chapter 2: Navigating the Access Workspace
• Diving Right In
• Working with Onscreen Tools in Access
• Customizing the Access Workspace
• Mousing Around
• Navigating Access with the Alt Key
• Chapter 3: Database Basics
• Database Lingo
• Field Types and Uses
• Choosing Between Flat and Relational Databases
• Building a Database
• Adding and Removing Tables
• Part 2: Getting It All on the Table
• Chapter 4: Sounds Like a Plan
• Planning Your Database Tables
• Building Tables in Design View
• Chapter 5: Table Tune Ups
• The Primary Key to Success
• Making Tables Get Along
• Building Table Relationships
• Indexing for Faster Queries
• Chapter 6: Remodeling Your Data
• Opening a Table for Editing
• Inserting Records and Fields
• Modifying Field Content
• Name-Calling
• Turn Uh-Oh! into Yee-Hah!
• Chapter 7: Types, Masks, and Triggers
• Access Table Settings
• Field Data Formats
• Gaining Control of Data Entry
• Give Your Fingers a Mini Vacation by Default
• Part 3: Data Management Mania
• Chapter 8: A Form for All Reasons
• Generating Forms
• Customizing Form Parts
• Managing Data in Form View
• Chapter 9: Importing and Exporting Data
• Retrieving Data from Other Sources
• Hit the Road, Data
• Chapter 10: Automatically Editing Data
• Please Read This First!
• Creating Consistent Corrections
• Using Queries to Automate the Editing Process
• Chapter 11: Access and the Web
• How Access Works with the Web
• Understanding Office 365
• Connect Office 365 to Access 2019
• Part 4: The Power of Questions
• Chapter 12: Finding, Filtering, and Sorting Your Data — Fast
• Using the Find Command
• Sorting Alphabetically and Numerically
• Fast and Furious Filtering
• Chapter 13: I Was Just Asking … for Answers
• Simple (Yet Potent) Filter and Sort Tools
• Select Queries
• Getting Your Feet Wet with Ad Hoc Queries
• Chapter 14: I Want These AND Those OR Them
• Working with AND and/or OR
• Combining AND with OR and OR with AND
• Chapter 15: Number Crunching with the Total Row
• Say Hello to the Total Row
• Adding the Total Row to Your Queries
• Working Out the Total Row
• Creating Your Own Top-Ten List
• Choosing the Right Field for the Summary Instruction
• Chapter 16: Express Yourself with Formulas
• A Simple Calculation
• Complex Calculations
• Hooray for Expression Builder
• Chapter 17: Take Charge with Action Queries
• Easy Update
• Add Records in a Flash
• Quick Cleanup
• Part 5: Simple and Snazzy Reporting
• Chapter 18: Fast and Furious Automatic Reporting
• Quick and Not-S0-Dirty Automatic Reporting
• Previewing Your Report
• Beauty Is Only Skin (Report) Deep
• Chapter 19: Professionally Designed Reports Made Easy
• Report Repairs
• Report Organization
• Formatting Stuff
• Sneaking a Peek
• Getting a Themes Makeover
• Adding More Design Elements
• Chapter 20: Groups and Page Breaks, Headers and Footers
• A Place for Everything and Everything in Its Place
• Customizing Properties
• Chapter 21: Mailings to the Masses
• Massive Mailings with the Label Wizard
• Part 6: The Parts of Tens
• Chapter 22: Ten Common Problems
• That’s Just Not Normal
• You Type 73.725, but It Changes to 74
• The Words They Are A-Changing
• Was There and Now It’s Gone
• You Run a Query, but the Results Aren’t What You Expect
• The Dreaded Parameter Dialog Box
• The Slowest Database in Town
• Your Database File Is as Big as a House
• You Get a Mess When Importing Your Spreadsheet
• We’re Sorry; Your Database File Is Corrupt
• Chapter 23: Ten Uncommon Tips
• Document Everything as Though One Day You’ll Be Questioned by the FBI
• Keep Your Fields as Small as Possible
• Use Number Fields for Real Numbers
• Validate Your Data
• Use Understandable Names to Keep Things Simple
• Delete with Great Caution
• Backup, Backup, Backup
• Think, Think, and Think Again
• Get Organized and Stay Organized
• There’s No Shame in Asking for Help
• Appendix A: Getting Help
• Index
• About the Author
• Advertisement Page
• Connect with Dummies
• End User License Agreement