Access 2016 For Dummies
von: Laurie A. Ulrich, Ken Cook
For Dummies, 2015
ISBN: 9781119083276
Sprache: Englisch
459 Seiten, Download: 14788 KB
Format: PDF, auch als Online-Lesen
geeignet für:
| Title Page | 3 | ||
| Copyright Page | 4 | ||
| Table of Contents | 7 | ||
| Introduction | 15 | ||
| About This Book | 15 | ||
| Foolish Assumptions | 16 | ||
| Icons Used in This Book | 16 | ||
| Beyond the Book | 17 | ||
| Where to Go from Here | 17 | ||
| Part I Getting Started with Access 2016 | 19 | ||
| Chapter 1 Access 2016 Basic Training | 21 | ||
| What Is Access Good For, Anyway? | 22 | ||
| Building big databases | 22 | ||
| Building apps | 23 | ||
| Creating databases with multiple tables | 23 | ||
| Databases with user forms | 26 | ||
| Databases that require special reporting | 28 | ||
| What’s New in Access 2016? | 31 | ||
| Reach out with SharePoint | 32 | ||
| How Access Works and How You Work with It | 33 | ||
| Opening Access | 33 | ||
| Selecting a starting point | 35 | ||
| Now What? | 39 | ||
| Chapter 2 Navigating the Access Workspace | 41 | ||
| Diving Right In | 43 | ||
| Working with Onscreen Tools in Access | 45 | ||
| Clicking tabs | 46 | ||
| Using buttons | 48 | ||
| The File tab and Quick Access tools | 49 | ||
| Accessing panes, panels, and context-sensitive tools | 50 | ||
| Customizing the Access Workspace | 51 | ||
| Repositioning the Quick Access Toolbar | 51 | ||
| Adding buttons to the Quick Access Toolbar | 52 | ||
| Removing buttons from the Quick Access Toolbar | 55 | ||
| Minimizing the Ribbon | 56 | ||
| Working with ScreenTips | 57 | ||
| Mousing Around | 59 | ||
| Navigating Access with the Alt Key | 60 | ||
| Chapter 3 Database Basics | 63 | ||
| Database Lingo | 63 | ||
| Data, no matter how you pronounce it | 64 | ||
| Fields of dreams (or data) | 64 | ||
| Records | 65 | ||
| Tables | 65 | ||
| The database | 66 | ||
| Field Types and Uses | 66 | ||
| Choosing Between Flat and Relational Databases | 71 | ||
| Isolationist tables | 71 | ||
| Tables that mix and mingle | 71 | ||
| Building a Database | 73 | ||
| Adding and Removing Tables | 77 | ||
| One more, please | 77 | ||
| Oops, I didn’t mean to do that | 79 | ||
| Chapter 4 Sounds Like a Plan | 81 | ||
| Planning Your Database Tables | 81 | ||
| Reviewing fields | 81 | ||
| Determining data types | 82 | ||
| Grouping fields into tables | 84 | ||
| What is normal? | 85 | ||
| Building Tables in Design View | 87 | ||
| Creating fields | 87 | ||
| Setting data types | 89 | ||
| Part II Getting It All on the Table | 91 | ||
| Chapter 5 Table Tune Ups | 93 | ||
| The Primary Key to Success | 93 | ||
| The lowdown on primary keys | 94 | ||
| Creating a primary key | 95 | ||
| Making Tables Get Along | 97 | ||
| Rules of relationships | 97 | ||
| Relationship types | 97 | ||
| Building Table Relationships | 99 | ||
| The Relationships window | 100 | ||
| Table relationships | 100 | ||
| Indexing for Faster Queries | 105 | ||
| Creating your own index | 106 | ||
| Adding and removing indexes | 108 | ||
| Chapter 6 Remodeling Your Data | 111 | ||
| Opening a Table for Editing | 112 | ||
| Inserting Records and Fields | 115 | ||
| Adding a record | 115 | ||
| Inserting a field | 116 | ||
| Deleting a field | 120 | ||
| Modifying Field Content | 121 | ||
| Name-Calling | 122 | ||
| Renaming fields | 122 | ||
| Renaming a table | 124 | ||
| Turn Uh-Oh! into Yee-Hah! | 126 | ||
| Chapter 7 Types, Masks, and Triggers | 127 | ||
| Access Table Settings | 127 | ||
| Field Data Formats | 130 | ||
| Text fields | 131 | ||
| Number and currency fields | 133 | ||
| Date/time fields | 136 | ||
| Yes/No fields | 137 | ||
| Gaining Control of Data Entry | 138 | ||
| You really need to put a mask on those fields | 138 | ||
| To require or not to require | 145 | ||
| Making your data toe the line with validation | 146 | ||
| Give Your Fingers a Mini Vacation by Default | 148 | ||
| Part III Data Management Mania | 151 | ||
| Chapter 8 A Form for All Reasons | 153 | ||
| Generating Forms | 153 | ||
| Keeping it simple: Form tools | 155 | ||
| Granting most wishes: The Form Wizard | 157 | ||
| Customizing Form Parts | 161 | ||
| Taking the Layout view | 161 | ||
| The theme’s the thing | 161 | ||
| Managing form controls | 163 | ||
| Managing Data in Form View | 168 | ||
| Navigating and finding records | 168 | ||
| Saving, clearing, and deleting | 169 | ||
| Chapter 9 Importing and Exporting Data | 171 | ||
| Retrieving Data from Other Sources | 172 | ||
| Translating file formats | 172 | ||
| Importing and linking | 175 | ||
| Hit the Road, Data | 180 | ||
| Export formats | 180 | ||
| Exporting table or query data | 180 | ||
| Exporting a Report to PDF | 183 | ||
| Chapter 10 Automatic Data Editing | 185 | ||
| Please Read This First! | 185 | ||
| Creating Consistent Corrections | 188 | ||
| Using Queries to Automate the Editing Process | 190 | ||
| Looking for duplicate records | 191 | ||
| Running the Find Duplicates Query Wizard | 192 | ||
| Chapter 11 Access and the Web | 197 | ||
| How Access Works with the Web | 197 | ||
| Understanding Office 365 | 198 | ||
| Connect Office 365 to Access 2016 | 199 | ||
| Meet the Custom Web App | 200 | ||
| Adding new tables to your web app | 203 | ||
| Uploading an existing table to your web app | 204 | ||
| Web app forms | 205 | ||
| Launching your web app | 206 | ||
| Adding a record | 208 | ||
| Editing a record | 209 | ||
| Deleting a record | 210 | ||
| Linking to a web app from an Access desktop database | 210 | ||
| Click! Using Hyperlinks in Your Desktop Access Database | 211 | ||
| Adding a Hyperlink field to your desktop database table | 212 | ||
| Fine-tuning your hyperlinks | 213 | ||
| Testing links | 215 | ||
| Part IV The Power of Questions | 217 | ||
| Chapter 12 Finding, Filtering, and Sorting Your Data — Fast | 219 | ||
| Using the Find Command | 220 | ||
| Finding anything fast | 220 | ||
| Shifting Find into high gear | 222 | ||
| Sorting from A to Z or Z to A | 225 | ||
| Sorting by a single field | 225 | ||
| Sorting on more than one field | 225 | ||
| Fast and Furious Filtering | 226 | ||
| Filtering by a field’s content | 227 | ||
| Filter by selection | 228 | ||
| Filter by Form | 230 | ||
| Unfiltering in a form | 233 | ||
| Filter by excluding selection | 233 | ||
| Chapter 13 I Was Just Asking . . . for Answers | 235 | ||
| Simple (Yet Potent) Filter and Sort Tools | 236 | ||
| Filter things first | 237 | ||
| Fact?finding with fun, fast filtering | 239 | ||
| Here’s the “advanced” part | 239 | ||
| Select Queries | 245 | ||
| Solid relationships are the key to getting it all (from your tables) | 246 | ||
| Running the Query Wizard | 247 | ||
| Getting Your Feet Wet with Ad Hoc Queries | 253 | ||
| Adding the finishing touches | 256 | ||
| Saving the query | 259 | ||
| Running your query | 259 | ||
| Chapter 14 I Want These AND Those OR Them | 261 | ||
| Working with AND and/or OR | 262 | ||
| Data from here to there | 263 | ||
| Using multiple levels of AND | 264 | ||
| Establishing criteria with OR | 266 | ||
| Combining AND with OR and OR with AND | 267 | ||
| Chapter 15 Number Crunching with the Total Row | 269 | ||
| Say Hello to the Total Row | 269 | ||
| Adding the Total Row to Your Queries | 271 | ||
| Working Out the Total Row | 272 | ||
| Putting it together with Group By | 272 | ||
| Well, that certainly sums it up | 274 | ||
| Counting, the easy way | 275 | ||
| Narrowing the results with Where | 277 | ||
| Creating Your Own Top?Ten List | 278 | ||
| Choosing the Right Field for the Summary Instruction | 279 | ||
| Chapter 16 Express Yourself with Formulas | 281 | ||
| A Simple Calculation | 282 | ||
| Complex Calculations | 284 | ||
| Calculate ’til you drop! | 284 | ||
| Using one calculation in another | 285 | ||
| Using parameter queries to ask for help | 286 | ||
| “Adding” words with text formulas | 288 | ||
| Hooray for Expression Builder | 290 | ||
| Chapter 17 Take Charge with Action Queries | 295 | ||
| Easy Update | 296 | ||
| Add Records in a Flash | 300 | ||
| Quick Cleanup | 303 | ||
| Part V Simple and Snazzy Reporting | 305 | ||
| Chapter 18 Fast and Furious Automatic Reporting | 307 | ||
| Quick and Not-S0-Dirty Automatic Reporting | 308 | ||
| Creating a quick, one-table report | 308 | ||
| Starting the Report Wizard | 312 | ||
| Previewing Your Report | 319 | ||
| Zooming in and out and all around | 320 | ||
| Pop goes the menu | 321 | ||
| Beauty Is Only Skin (Report) Deep | 323 | ||
| The Print Options tab | 323 | ||
| The Page tab | 324 | ||
| The Columns tab | 326 | ||
| Chapter 19 Professionally Designed Reports Made Easy | 329 | ||
| Report Repairs | 330 | ||
| Report Organization | 332 | ||
| Structural devices | 332 | ||
| Page breaks | 334 | ||
| Formatting Stuff | 336 | ||
| Adding color | 337 | ||
| Relocation, relocation, relocation | 339 | ||
| One size does not fit all | 341 | ||
| Spaced-out controls | 343 | ||
| Borderline beauty | 344 | ||
| Tweaking your text | 347 | ||
| Sneaking a Peek | 349 | ||
| Getting a Themes Makeover | 350 | ||
| Adding More Design Elements | 351 | ||
| Drawing lines | 352 | ||
| Pretty as a picture | 353 | ||
| Adding a logo | 353 | ||
| Chapter 20 Headers and Footers and Groups, Oh My! | 355 | ||
| A Place for Everything and Everything in Its Place | 356 | ||
| Layout basics | 356 | ||
| Sections | 358 | ||
| Grouping your records | 361 | ||
| So you want more? | 364 | ||
| Customizing Properties | 364 | ||
| Controlling report and page headings | 367 | ||
| Adjusting individual sections | 369 | ||
| Itemized adjustments | 370 | ||
| Chapter 21 Magical Mass Mailings | 375 | ||
| Massive Mailings with the Label Wizard | 375 | ||
| Part VI More Power to You | 383 | ||
| Chapter 22 Analyze This! | 385 | ||
| From Flat File to Relational Tables with Table Analyzer | 385 | ||
| Record Database Object Information with the Database Documenter | 390 | ||
| Improve Database Performance without Steroids | 393 | ||
| Chapter 23 Steer Users in the Right Direction with Navigation Forms | 395 | ||
| The Comings and Goings of a Navigation Form | 395 | ||
| Am I in the Right Place? Testing Navigation Forms | 398 | ||
| Maintaining the Navigation Form | 400 | ||
| Edit a Navigation form item | 400 | ||
| Delete a Navigation Form tab item | 400 | ||
| Move a Navigation form item | 401 | ||
| Displaying the Navigation Form at Startup | 401 | ||
| Part VII The Part of Tens | 405 | ||
| Chapter 24 Ten Common Problems | 407 | ||
| That’s Just Not Normal | 407 | ||
| You Type 73.725, but It Changes to 74 | 408 | ||
| The Words They Are A-Changing | 409 | ||
| Was There and Now It’s Gone | 410 | ||
| Undo | 410 | ||
| Search for the missing record | 410 | ||
| Backup recovery | 411 | ||
| You Run a Query, but the Results Aren’t What You Expect | 411 | ||
| The Dreaded Parameter Dialog Box | 412 | ||
| The Slowest Database in Town | 413 | ||
| Your Database File Is as Big as a Whale | 414 | ||
| You Get a Mess When Importing Your Spreadsheet | 415 | ||
| We’re Sorry | 416 | ||
| Chapter 25 Ten Uncommon Tips | 417 | ||
| Document Everything as Though One Day You’ll be Questioned by the FBI | 418 | ||
| Keep Your Fields as Small as Possible | 419 | ||
| Use Number Fields for Real Numbers | 420 | ||
| Validate Your Data | 420 | ||
| Use Understandable Names to Keep Things Simple | 420 | ||
| Delete with Great Caution | 421 | ||
| Backup, Backup, Backup | 421 | ||
| Think, Think, and Think Again | 421 | ||
| Get Organized and Stay Organized | 422 | ||
| There’s No Shame in Asking for Help | 422 | ||
| Appendix A: Getting Help | 423 | ||
| Asking Access for Help | 424 | ||
| Installed Help files | 424 | ||
| Asking the right questions | 424 | ||
| Online Help | 426 | ||
| Office.com | 427 | ||
| Search engines and other sites | 427 | ||
| Who’s Our Next Caller? | 428 | ||
| Voice calls | 428 | ||
| TDD/TT calls | 429 | ||
| Index | 431 | ||
| EULA | 459 |