Access 2016 for dummies / by Laurie Ulrich Fuller and Ken Cook.

Format:

Book

Author/Creator:

Ulrich-Fuller, Laurie, 1961- author.

Cook, Ken, 1959- author.

Series:

--For dummies.

For Dummies

Language:

English

Subjects (All):

Microsoft Access.

Database management.

Physical Description:

1 online resource (xii, 440 pages) : illustrations (some color).

Edition:

1st edition

Other Title:

Microsoft access 2016 for dummies

Place of Publication:

Hoboken, NJ : John Wiley & Sons, Inc., [2016]

System Details:

text file

Summary:

Your all-access guide to all things Access 2016 If you don't know a relational database from an isolationist table—but still need to figure out how to organize and analyze your data— Access 2016 For Dummies is for you. Written in a friendly and accessible manner, it assumes no prior Access or database-building knowledge and walks you through the basics of creating tables to store your data, building forms that ease data entry, writing queries that pull real information from your data, and creating reports that back up your analysis. Add in a dash of humor and fun, and Access 2016 For Dummies is the only resource you'll need to go from data rookie to data pro! This expanded and updated edition of Access For Dummies covers all of the latest information and features to help data newcomers better understand Access' role in the world of data analysis and data science. Inside, you'll get a crash course on how databases work—and how to build one from the ground up. Plus, you'll find step-by-step guidance on how to structure data to make it useful, manipulate, edit, and import data into your database, write and execute queries to gain insight from your data, and report data in elegant ways. Speak the lingo of database builders and create databases that suit your needs Organize your data into tables and build forms that ease data entry Query your data to get answers right Create reports that tell the story of your data findings If you have little to no experience with creating and managing a database of any sort, Access 2016 For Dummies is the perfect starting point for learning the basics of building databases, simplifying data entry and reporting, and improving your overall data skills.

Contents:

Intro

Title Page

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

Building big databases

Building apps

Creating databases with multiple tables

Databases with user forms

Databases that require special reporting

What's New in Access 2016?

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

Chapter 4 Sounds Like a Plan

Planning Your Database Tables

Reviewing fields

Determining data types

Grouping fields into tables

What is normal?

Building Tables in Design View

Creating fields

Setting data types

Part II Getting It All on the Table

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 III 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 file formats

Importing and linking

Hit the Road, Data

Export formats

Exporting table or query data

Exporting a Report to PDF

Chapter 10 Automatic Data Editing

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 2016

Meet the Custom Web App

Adding new tables to your web app

Uploading an existing table to your web app

Web app forms

Launching your web app

Editing a record

Deleting a record

Linking to a web app from an Access desktop database

Click! Using Hyperlinks in Your Desktop Access Database

Adding a Hyperlink field to your desktop database table

Fine-tuning your hyperlinks

Testing links

Part IV 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 from A to Z or Z to A

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 in a 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 V Simple and Snazzy Reporting

Chapter 18 Fast and Furious Automatic Reporting

Quick and Not-S0-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 logo

Chapter 20 Headers and Footers and Groups, Oh My!

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

Edit a Navigation form item

Delete a Navigation Form tab item

Move a Navigation form item

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

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

Installed Help files

Asking the right questions

Online Help

Office.com

Search engines and other sites

Who's Our Next Caller?

Voice calls

TDD/TT calls

Index

EULA.

Notes:

Includes index.

Includes bibliographical references at the end of each chapters and index.

Description based on print version record.

ISBN:

9781119083276

1119083273

OCLC:

952493390