Microsoft 365 Access For Dummies

Höfundar: Laurie A. Ulrich; Ken Cook (Útgáfa: 2)
Microsoft 365 Access For Dummies

Kaup valmöguleikar

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.

Nánar um bókina

Útgefandi
Wiley Professional Development (P&T)
ISBN
9781394295661
Print ISBN
9781394295654
Format
ePub
Útgáfa
2
Höfundar
Laurie A. Ulrich; Ken Cook
Tungumál
English
Útgefið
2025-01-03
Prent takmörkun á líftíma
100
Prent takmörkun
10
Afritunar takmörkun
2

Kaflar

  • Cover
  • Title Page
  • Copyright
  • Introduction
  • About This Book
  • Foolish Assumptions
  • Icons Used in This Book
  • Where to Go from Here
  • Part 1: Basic Training
  • Chapter 1: Access Basics
  • What Is Access Good For, Anyway?
  • Reach Out with SharePoint
  • How Access Works and How You Work with It
  • OK, Now What?
  • Chapter 2: Finding Your Way in 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 Play Nice
  • 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 Microsoft 365
  • Using the Access Web Browser Control
  • 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
  • Giving the Total Row a Workout
  • 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
  • And Now … the 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-So-Dirty Automatic Reporting
  • Previewing Your Report
  • Beauty Is Only Skin (Report) Deep
  • Chapter 19: Professionally Designed Reports Made Easy
  • Reports Reimagined
  • Report Organization
  • Formatting Stuff
  • Adding More Design Elements
  • Chapter 20: Groups and Page Breaks, Headers and Footers
  • A Place for Everything and Everything in Its Place
  • Customizing Properties
  • Part 6: The Part of Tens
  • Chapter 21: Ten Common Problems
  • That’s Just Not Normal
  • You Type 73.725, but It Changes to 74
  • Where’s That Word I Just Typed?
  • I Swear It Was There — But Now It’s Gone
  • You Run a Query, but the Results Aren’t What You Expect
  • What the Heck Is This Parameter Dialog Box?
  • Your Database Is Painfully Slow
  • Your Database File Is Humongous!
  • Chaos Ensues after Importing Your Spreadsheet
  • We’re Sorry; Your Database File Is Corrupt
  • Chapter 22: Ten Uncommon Tips
  • Document Everything as if Your Life Depended on It
  • 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
  • Go Ahead and Overthink
  • Get Organized and Keep It Simple
  • 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