Access 2019 for dummies

Access 2019 for dummies

Laurie Ulrich-Fuller, 1961-

Book - 2019

This book offers clear and simple advice on how to build and operate databases as well as create simple forms, import data from outside sources, query databases for information, and share knowledge in reports. In short, it's the book that holds all the secrets behind the mysteries of Access!--

Saved in:
Place a Hold Save to List Email this

2nd Floor Show me where

005.7565/ACCESS/Ulrich-Fuller
1 / 1 copies available
Location Call Number   Status
2nd Floor 005.7565/ACCESS/Ulrich-Fuller Checked In
Subjects
Microsoft Access.
Database management.
Published
Hoboken, NJ : John Wiley & Sons [2019]
Language
English
Main Author
Laurie Ulrich-Fuller, 1961- (author)
Other Authors
Ken Cook, 1959- (author)
Physical Description
xiii, 407 pages : illustrations ; 24 cm
Bibliography
Includes index.
ISBN
9781119513261
  • Introduction
  • About This Book
  • Foolish Assumptions
  • Icons Used in This Book
  • Where to Go from Here
  • Part 1. Basic Training
  • Chapter 1. Access 2019 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
  • What's New in Access 2019?
  • 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 Office 365
  • Connect Office 365 to Access 2019
  • Your data and the cloud
  • Upload your Access desktop data to the cloud
  • Click! Using Hyperlinks in your desktop Access database
  • Adding a Hyperlink field to your desktop database table
  • Fine-tuning your hyperlinks
  • Testing links
  • 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
  • Working Out the Total Row
  • 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-SO-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 Iogo
  • 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 Parts of Tens
  • Chapter 22. Ten Common Problems
  • That's Just Not Normal
  • You Type 73.725, but it Changes to 74
  • The Words They Are A-Changing
  • 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 as Big as a House
  • You Get a Mess When Importing Your Spreadsheet
  • We're Sorry; Your Database File Is Corrupt
  • Chapter 23. Ten Uncommon Tips
  • Document Everything as Though One Day You'll Be
  • Questioned by the FBI
  • 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

Similar Items