book

Access 2019 For Dummies

by Laurie A. Ulrich, Ken Cook

October 2018

Beginner

432 pages

9h 48m

English

For Dummies

Read now

Unlock full access

About This BookFoolish AssumptionsIcons Used in This BookWhere to Go from Here
What Is Access Good For, Anyway?What’s New in Access 2019?Reach Out with SharePointHow Access Works and How You Work with ItNow What?
Diving Right InWorking with Onscreen Tools in AccessCustomizing the Access WorkspaceMousing AroundNavigating Access with the Alt Key
Database LingoField Types and UsesChoosing Between Flat and Relational DatabasesBuilding a DatabaseAdding and Removing Tables
Planning Your Database TablesBuilding Tables in Design View
The Primary Key to SuccessMaking Tables Get AlongBuilding Table RelationshipsIndexing for Faster Queries
Opening a Table for EditingInserting Records and FieldsModifying Field ContentName-CallingTurn Uh-Oh! into Yee-Hah!

Access Table SettingsField Data FormatsGaining Control of Data EntryGive Your Fingers a Mini Vacation by Default
Generating FormsCustomizing Form PartsManaging Data in Form View
Retrieving Data from Other SourcesHit the Road, Data
Please Read This First!Creating Consistent CorrectionsUsing Queries to Automate the Editing Process
How Access Works with the WebUnderstanding Office 365Connect Office 365 to Access 2019
Using the Find CommandSorting Alphabetically and NumericallyFast and Furious Filtering
Simple (Yet Potent) Filter and Sort ToolsSelect QueriesGetting Your Feet Wet with Ad Hoc Queries
Working with AND and/or ORCombining AND with OR and OR with AND
Say Hello to the Total RowAdding the Total Row to Your QueriesWorking Out the Total RowCreating Your Own Top-Ten ListChoosing the Right Field for the Summary Instruction
A Simple CalculationComplex CalculationsHooray for Expression Builder
Easy UpdateAdd Records in a FlashQuick Cleanup
Quick and Not-S0-Dirty Automatic ReportingPreviewing Your ReportBeauty Is Only Skin (Report) Deep
Report RepairsReport OrganizationFormatting StuffSneaking a PeekGetting a Themes MakeoverAdding More Design Elements
A Place for Everything and Everything in Its PlaceCustomizing Properties
Massive Mailings with the Label Wizard
That’s Just Not NormalYou Type 73.725, but It Changes to 74The Words They Are A-ChangingWas There and Now It’s GoneYou Run a Query, but the Results Aren’t What You ExpectThe Dreaded Parameter Dialog BoxThe Slowest Database in TownYour Database File Is as Big as a HouseYou Get a Mess When Importing Your SpreadsheetWe’re Sorry; Your Database File Is Corrupt
Document Everything as Though One Day You’ll Be Questioned by the FBIKeep Your Fields as Small as PossibleUse Number Fields for Real NumbersValidate Your DataUse Understandable Names to Keep Things SimpleDelete with Great CautionBackup, Backup, BackupThink, Think, and Think AgainGet Organized and Stay OrganizedThere’s No Shame in Asking for Help

Content preview from Access 2019 For Dummies

Chapter 1

Access 2019 Basic Training

IN THIS CHAPTER

Deciding when to use Access

Discovering what’s new in Access 2019

Unlocking the basics of working with Access

Figuring out how to get started

Access 2019, the latest version of the Microsoft Office database application, has always been a powerful program, and this version is no different. Chances are, you’re reading this book because all that power makes Access an application that’s not so easy to learn on your own. If you’re hoping to unleash that power for your data, you’ll need us. So, good decision to buy this book!

Now, all that power and the need for our book aside, with the very basic parts of Access, the basic functionality that you’ll discover in this book, you’ll be able to put Access through many of its most important paces, yet you’ll be working with wizards and other onscreen tools that keep you at a comfortable arm’s distance from the software’s inner workings, the things that programmers and serious developers play with. There. Don’t you feel better now?

You don’t have to use every feature and tool and push the ...