Log In
Or create an account ->
Imperial Library
Home
About
News
Upload
Forum
Help
Login/SignUp
Index
Cover
Title Page
Table of Contents
Introduction
About This Book
Foolish Assumptions
Icons Used in This Book
Beyond the Book
Where to Go from Here
Part I: Getting Started with Access 2016
Chapter 1: Access 2016 Basic Training
What Is Access Good For, Anyway?
What’s New in Access 2016?
Reach out with SharePoint
How Access Works and How You Work with It
Now What?
Chapter 2: Navigating the Access Workspace
Diving Right In
Working with Onscreen Tools in Access
Customizing the Access Workspace
Mousing Around
Navigating Access with the Alt Key
Chapter 3: Database Basics
Database Lingo
Field Types and Uses
Choosing Between Flat and Relational Databases
Building a Database
Adding and Removing Tables
Chapter 4: Sounds Like a Plan
Planning Your Database Tables
Building Tables in Design View
Part II: Getting It All on the Table
Chapter 5: Table Tune Ups
The Primary Key to Success
Making Tables Get Along
Building Table Relationships
Indexing for Faster Queries
Chapter 6: Remodeling Your Data
Opening a Table for Editing
Inserting Records and Fields
Modifying Field Content
Name-Calling
Turn Uh-Oh! into Yee-Hah!
Chapter 7: Types, Masks, and Triggers
Access Table Settings
Field Data Formats
Gaining Control of Data Entry
Give Your Fingers a Mini Vacation by Default
Part III: Data Management Mania
Chapter 8: A Form for All Reasons
Generating Forms
Customizing Form Parts
Managing Data in Form View
Chapter 9: Importing and Exporting Data
Retrieving Data from Other Sources
Hit the Road, Data
Chapter 10: Automatic Data Editing
Please Read This First!
Creating Consistent Corrections
Using Queries to Automate the Editing Process
Chapter 11: Access and the Web
How Access Works with the Web
Understanding Office 365
Connect Office 365 to Access 2016
Meet the Custom Web App
Click! Using Hyperlinks in Your Desktop Access Database
Part IV: The Power of Questions
Chapter 12: Finding, Filtering, and Sorting Your Data — Fast
Using the Find Command
Sorting from A to Z or Z to A
Fast and Furious Filtering
Chapter 13: I Was Just Asking … for Answers
Simple (Yet Potent) Filter and Sort Tools
Select Queries
Getting Your Feet Wet with Ad Hoc Queries
Chapter 14: I Want These AND Those OR Them
Working with AND and/or 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
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
Hooray for Expression Builder
Chapter 17: Take Charge with Action Queries
Easy Update
Add Records in a Flash
Quick Cleanup
Part V: Simple and Snazzy Reporting
Chapter 18: Fast and Furious Automatic Reporting
Quick and Not-S0-Dirty Automatic Reporting
Previewing Your Report
Beauty Is Only Skin (Report) Deep
Chapter 19: Professionally Designed Reports Made Easy
Report Repairs
Report Organization
Formatting Stuff
Sneaking a Peek
Getting a Themes Makeover
Adding More Design Elements
Chapter 20: Headers and Footers and Groups, Oh My!
A Place for Everything and Everything in Its Place
Customizing Properties
Chapter 21: Magical Mass Mailings
Massive Mailings with the Label Wizard
Part VI: More Power to You
Chapter 22: Analyze This!
From Flat File to Relational Tables with Table Analyzer
Record Database Object Information with the Database Documenter
Improve Database Performance without Steroids
Chapter 23: Steer Users in the Right Direction with Navigation Forms
The Comings and Goings of a Navigation Form
Am I in the Right Place? Testing Navigation Forms
Maintaining the Navigation Form
Displaying the Navigation Form at Startup
Part VII: The Part of Tens
Chapter 24: 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
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 Whale
You Get a Mess When Importing Your Spreadsheet
We’re Sorry; Your Database File Is Corrupt
Chapter 25: 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
Asking Access for Help
Online Help
Who’s Our Next Caller?
About the Authors
Cheat Sheet
Advertisement Page
Connect with Dummies
End User License Agreement
← Prev
Back
Next →
← Prev
Back
Next →