Coverart for item
The Resource Access 2019 for Dummies, (electronic book)

Access 2019 for Dummies, (electronic book)

Label
Access 2019 for Dummies
Title
Access 2019 for Dummies
Creator
Contributor
Subject
Language
eng
Member of
Cataloging source
MiAaPQ
http://library.link/vocab/creatorName
Fuller, Laurie Ulrich
Dewey number
005.7565
LC call number
QA76.9.D3 .L387 2019
Literary form
non fiction
Nature of contents
dictionaries
http://library.link/vocab/relatedWorkOrContributorName
Cook, Ken
http://library.link/vocab/subjectName
  • Microsoft Access-Computer-assisted instruction.
  • Database management
Label
Access 2019 for Dummies, (electronic book)
Instantiates
Publication
Copyright
Carrier category
online resource
Carrier category code
cr
Carrier MARC source
rdacarrier
Color
multicolored
Content category
text
Content type code
txt
Content type MARC source
rdacontent
Contents
  • Intro -- Table of Contents -- 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? -- What's New in Access 2019? -- 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 -- Part 2: Getting It All on the Table -- Chapter 4: Sounds Like a Plan -- Planning Your Database Tables -- Building Tables in Design View -- 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 3: 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: Automatically Editing Data -- 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 2019 -- Part 4: The Power of Questions -- Chapter 12: Finding, Filtering, and Sorting Your Data - Fast -- Using the Find Command -- Sorting Alphabetically and Numerically -- Fast and Furious Filtering -- Chapter 13: I Was Just Asking {u2026} 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 5: 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: Groups and Page Breaks, Headers and Footers -- A Place for Everything and Everything in Its Place -- Customizing Properties -- 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 -- 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 -- About the Author -- Advertisement Page -- Connect with Dummies -- End User License Agreement
Control code
purchEBC5558121
Dimensions
unknown
Extent
1 online resource (461 pages)
Form of item
online
Isbn
9781119513261
Media category
computer
Media MARC source
rdamedia
Media type code
c
Reproduction note
Electronic resource.
Sound
unknown sound
Specific material designation
remote
Label
Access 2019 for Dummies, (electronic book)
Publication
Copyright
Carrier category
online resource
Carrier category code
cr
Carrier MARC source
rdacarrier
Color
multicolored
Content category
text
Content type code
txt
Content type MARC source
rdacontent
Contents
  • Intro -- Table of Contents -- 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? -- What's New in Access 2019? -- 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 -- Part 2: Getting It All on the Table -- Chapter 4: Sounds Like a Plan -- Planning Your Database Tables -- Building Tables in Design View -- 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 3: 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: Automatically Editing Data -- 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 2019 -- Part 4: The Power of Questions -- Chapter 12: Finding, Filtering, and Sorting Your Data - Fast -- Using the Find Command -- Sorting Alphabetically and Numerically -- Fast and Furious Filtering -- Chapter 13: I Was Just Asking {u2026} 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 5: 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: Groups and Page Breaks, Headers and Footers -- A Place for Everything and Everything in Its Place -- Customizing Properties -- 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 -- 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 -- About the Author -- Advertisement Page -- Connect with Dummies -- End User License Agreement
Control code
purchEBC5558121
Dimensions
unknown
Extent
1 online resource (461 pages)
Form of item
online
Isbn
9781119513261
Media category
computer
Media MARC source
rdamedia
Media type code
c
Reproduction note
Electronic resource.
Sound
unknown sound
Specific material designation
remote

Library Locations

Processing Feedback ...