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
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 |