Access For Dummies
- Length: 432 pages
- Edition: 1
- Language: English
- Publisher: For Dummies
- Publication Date: 2021-12-14
- ISBN-10: 1119829089
- ISBN-13: 9781119829089
- Sales Rank: #1807318 (See Top 100 Books)
Become a database boss ―and have fun doing it―with this accessible and easy-to-follow guide to Microsoft Access
Databases hold the key to organizing and accessing all your data in one convenient place. And you don’t have to be a data science wizard to build, populate, and organize your own. With Microsoft Access For Dummies, you’ll learn to use the latest version of Microsoft’s Access software to power your database needs.
Need to understand the essentials before diving in? Check out our Basic Training in Part 1 where we teach you how to navigate the Access workspace and explore the foundations of databases.
Ready for more advanced tutorials? Skip right to the sections on Data Management, Queries, or Reporting where we walk you through Access’s more sophisticated capabilities. Not sure if you have Access via Office 2021 or Office 365? No worries – this book covers Access now matter how you access it.
The book also shows you how to:
- Handle the most common problems that Access users encounter
- Import, export, and automatically edit data to populate your next database
- Write powerful and accurate queries to find exactly what you’re looking for, exactly when you need it
Microsoft Access For Dummies is the perfect resource for anyone expected to understand, use, or administer Access databases at the workplace, classroom, or any other data-driven destination.
Title Page Copyright Page Table of Contents Introduction About This Book Foolish Assumptions Icons Used in This Book Where to Go from Here Part 1 Basic Training Chapter 1 Access Basic Training What Is Access Good For, Anyway? Building big databases Creating databases with multiple tables Databases with user forms Databases that require special reporting Reach Out with SharePoint How Access Works and How You Work with It Opening Access Selecting a starting point Now What? Chapter 2 Navigating the Access Workspace Diving Right In Working with Onscreen Tools in Access Clicking tabs Using buttons The File tab and Quick Access tools Accessing panes, panels, and context-sensitive tools Customizing the Access Workspace Repositioning the Quick Access Toolbar Adding buttons to the Quick Access Toolbar Removing buttons from the Quick Access Toolbar Minimizing the Ribbon Working with ScreenTips Mousing Around Navigating Access with the Alt Key Chapter 3 Database Basics Database Lingo Data, no matter how you pronounce it Fields of dreams (or data) Records Tables The database Field Types and Uses Choosing Between Flat and Relational Databases Isolationist tables Tables that mix and mingle Building a Database Adding and Removing Tables One more, please Oops, I didn’t mean to do that Part 2 Getting It All on the Table Chapter 4 Sounds Like a Plan Planning Your Database Tables Reviewing fields Determining data types The new normal Understanding normal forms Normalizing your tables Building Tables in Design View Creating fields Setting data types Chapter 5 Table Tune-Ups The Primary Key to Success The lowdown on primary keys Creating a primary key Making Tables Get Along Rules of relationships Relationship types Building Table Relationships The Relationships window Table relationships Indexing for Faster Queries Creating your own index Adding and removing indexes Chapter 6 Remodeling Your Data Opening a Table for Editing Inserting Records and Fields Adding a record Inserting a field Deleting a field Modifying Field Content Name-Calling Renaming fields Renaming a table Turn Uh-Oh! into Yee-Hah! Chapter 7 Types, Masks, and Triggers Access Table Settings Field Data Formats Text fields Number and currency fields Date/time fields Yes/No fields Gaining Control of Data Entry You really need to put a mask on those fields To require or not to require Making your data toe the line with validation Give Your Fingers a Mini Vacation by Default Part 3 Data Management Mania Chapter 8 A Form for All Reasons Generating Forms Keeping it simple: Form tools Granting most wishes: The Form Wizard Customizing Form Parts Taking the Layout view The theme’s the thing Managing form controls Managing Data in Form View Navigating and finding records Saving, clearing, and deleting Chapter 9 Importing and Exporting Data Retrieving Data from Other Sources Translating data formats Importing and linking Hit the Road, Data Export formats Exporting table or query data Exporting a report to PDF Chapter 10 Automatically Editing Data Please Read This First! Creating Consistent Corrections Using Queries to Automate the Editing Process Looking for duplicate records Running the Find Duplicates Query Wizard Chapter 11 Access and the Web How Access Works with the Web Understanding Microsoft Using the Access Web Browser Control Click! Using hyperlinks in your desktop Access database Adding a Hyperlink field to your desktop database table Fine-tuning your hyperlinks Testing links Publishing Access objects to the web Part 4 The Power of Questions Chapter 12 Finding, Filtering, and Sorting Your Data — Fast Using the Find Command Finding anything fast Shifting Find into high gear Sorting Alphabetically and Numerically Sorting by a single field Sorting on more than one field Fast and Furious Filtering Filtering by a field’s content Filter by selection Filter by Form Unfiltering Filter by Form Filter by excluding selection Chapter 13 I Was Just Asking . . . for Answers Simple (Yet Potent) Filter and Sort Tools Filter things first Fact-finding with fun, fast filtering Here’s the “advanced” part Select Queries Solid relationships are the key to getting it all (from your tables) Running the Query Wizard Getting Your Feet Wet with Ad Hoc Queries Adding the finishing touches Saving the query Running your query Chapter 14 I Want These AND Those OR Them Working with AND and/or OR Data from here to there Using multiple levels of AND Establishing criteria with 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 Putting it together with Group By Well, that certainly sums it up Counting, the easy way Narrowing the results with Where 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 Calculate ‘til you drop! Using one calculation in another Using parameter queries to ask for help “Adding” words with text formulas 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 Creating a quick, one-table report Starting the Report Wizard Previewing Your Report Zooming in and out and all around Pop goes the menu Beauty Is Only Skin (Report) Deep The Print Options tab The Page tab The Columns tab Chapter 19 Professionally Designed Reports Made Easy Report Repairs Report Organization Structural devices Page breaks Formatting Stuff Adding color Relocation, relocation, relocation One size does not fit all Spaced-out controls Borderline beauty Tweaking your text Sneaking a Peek Getting a Themes Makeover Adding More Design Elements Drawing lines Pretty as a picture Adding a logo Chapter 20 Groups and Page Breaks, Headers and Footers A Place for Everything and Everything in Its Place Layout basics Sections Grouping your records So you want more? Customizing Properties Controlling report and page headings Adjusting individual sections Itemized adjustments Chapter 21 Mailings to the Masses Massive Mailings with the Label Wizard Part 6 The Part of Tens Chapter 22 Ten Common Problems That’s Just Not Normal You Type 73.725, but It Changes to Where’s That Word I Just Typed? Was There and Now It’s Gone Undo Search for the missing record Backup recovery 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 Ginormous You Get a Mess When Importing Your Spreadsheet We’re Sorry; Your Database File Is Corrupt Chapter 23 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 Think, Think, and Think Again Get Organized and Stay Organized There’s No Shame in Asking for Help Appendix A Getting Help Index EULA
Donate to keep this site alive
1. Disable the AdBlock plugin. Otherwise, you may not get any links.
2. Solve the CAPTCHA.
3. Click download link.
4. Lead to download server to download.