Access 2016 for dummies

Access 2016 for dummies

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

Descripción completa

Detalles Bibliográficos
Otros Autores: Cook, Ken, 1959- author (author)
Formato: Libro electrónico
Idioma:Inglés
Publicado: Hoboken, NJ: Wiley c2016.
Hoboken, NJ : [2016]
Edición:1st edition
Colección:--For dummies.
Materias:
Microsoft Access.
Database management.
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009629853306719
Tabla de Contenidos:
  • 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
  • Adding a record
  • 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.

Ejemplares similares