Coverart for item
The Resource Access 2019 for dummies, by Laurie Ann Ulrich and Ken Cook

Access 2019 for dummies, by Laurie Ann Ulrich and Ken Cook

Label
Access 2019 for dummies
Title
Access 2019 for dummies
Statement of responsibility
by Laurie Ann Ulrich and Ken Cook
Title variation
  • Microsoft Access 2019 for dummies
  • Access 2019
Creator
Contributor
Author
Subject
Language
eng
Summary
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!
Member of
Cataloging source
YDX
http://library.link/vocab/creatorDate
1961-
http://library.link/vocab/creatorName
Ulrich-Fuller, Laurie
Dewey number
005.7565
Illustrations
illustrations
Index
index present
Literary form
non fiction
http://library.link/vocab/relatedWorkOrContributorDate
1959-
http://library.link/vocab/relatedWorkOrContributorName
Cook, Ken
Series statement
For dummies
http://library.link/vocab/subjectName
Database management
Target audience
adult
Label
Access 2019 for dummies, by Laurie Ann Ulrich and Ken Cook
Instantiates
Publication
Bibliography note
Includes index
Carrier category
volume
Carrier category code
  • nc
Carrier MARC source
rdacarrier
Content category
  • text
  • still image
Content type code
  • txt
  • sti
Content type MARC source
  • rdacontent
  • rdacontent
Contents
  • Building big databases
  • New normal
  • p. 66
  • Understanding normal forms
  • p. 66
  • Normalizing your tables
  • p. 67
  • Building Tables in Design View
  • p. 70
  • Creating fields
  • p. 70
  • p. 8
  • Setting data types
  • p. 72
  • Chapter 5
  • Table Tune Ups
  • p. 75
  • Primary Key to Success
  • p. 76
  • Lowdown on primary keys
  • p. 76
  • Creating a primary key
  • Creating databases with multiple tables
  • p. 77
  • Making Tables Get Along
  • p. 79
  • Rules of relationships
  • p. 79
  • Relationship types
  • p. 80
  • Building Table Relationships
  • p. 82
  • Relationships window
  • p. 9
  • p. 82
  • Table relationships
  • p. 83
  • Indexing for Faster Queries
  • p. 87
  • Creating your own index
  • p. 88
  • Adding and removing indexes
  • p. 91
  • Chapter 6
  • Databases with user forms
  • Remodeling Your Data
  • p. 93
  • Opening a Table for Editing
  • p. 94
  • Inserting Records and Fields
  • p. 97
  • Adding a record
  • p. 97
  • Inserting a field
  • p. 98
  • p. 12
  • Deleting a field
  • p. 101
  • Modifying Field Content
  • p. 102
  • Name-Calling
  • p. 103
  • Renaming fields
  • p. 104
  • Renaming a table
  • p. 106
  • Databases that require special reporting
  • Turn Uh-Oh! into Yee-Hah!
  • p. 108
  • Chapter 7
  • Types, Masks, and Triggers
  • p. 109
  • Access Table Settings
  • p. 110
  • Field Data Formats
  • p. 112
  • Text fields
  • p. 13
  • p. 113
  • Number and currency fields
  • p. 115
  • Date/time fields
  • p. 118
  • Yes/No fields
  • p. 119
  • Gaining Control of Data Entry
  • p. 121
  • You really need to put a mask on those fields
  • What's New in Access 2019?
  • p. 121
  • To require or not to require
  • p. 128
  • Making your data toe the line with validation
  • p. 129
  • Give Your Fingers a Mini Vacation by Default
  • p. 131
  • Part 3
  • Data Management Mania
  • p. 133
  • p. 16
  • Chapter 8
  • A Form For All Reasons
  • p. 135
  • Generating Forms
  • p. 135
  • Keeping it simple: Form tools
  • p. 137
  • Granting most wishes: The Form Wizard
  • p. 139
  • Customizing Form Parts
  • Part 1
  • Reach Out with SharePoint
  • p. 143
  • Taking the Layout view
  • p. 143
  • Theme's the thing
  • p. 145
  • Managing form controls
  • p. 145
  • Managing Data in Form View
  • p. 150
  • Navigating and finding records
  • p. 17
  • p. 150
  • Saving, clearing, and deleting
  • p. 151
  • Chapter 9
  • Importing And Exporting Data
  • p. 153
  • Retrieving Data from Other Sources
  • p. 154
  • Translating data formats
  • p. 154
  • How Access Works and How You Work with It
  • Importing and linking
  • p. 157
  • Hit the Road, Data
  • p. 162
  • Export formats
  • p. 162
  • Exporting table or query data
  • p. 163
  • Exporting a report to PDF
  • p. 165
  • p. 18
  • Chapter 10
  • Automatically Editing Data
  • p. 167
  • Please Read This First!
  • p. 167
  • Creating Consistent Corrections
  • p. 170
  • Using Queries to Automate the Editing Process
  • p. 173
  • Looking for duplicate records
  • Opening Access
  • p. 173
  • Running the Find Duplicates Query Wizard
  • p. 174
  • Chapter 11
  • Access and the Web
  • p. 179
  • How Access Works with the Web
  • p. 179
  • Understanding Office 365
  • p. 180
  • p. 18
  • Connect Office 365 to Access 2019
  • p. 181
  • Your data and the cloud
  • p. 182
  • Upload your Access desktop data to the cloud
  • p. 183
  • Click! Using Hyperlinks in your desktop Access database
  • p. 186
  • Adding a Hyperlink field to your desktop database table
  • p. 187
  • Selecting a starting point
  • Fine-tuning your hyperlinks
  • p. 188
  • Testing links
  • p. 190
  • Part 4
  • Power of Questions
  • p. 191
  • Chapter 12
  • Finding, Filtering, and Sorting Your Data-Fast
  • p. 193
  • p. 19
  • Using the Find Command
  • p. 194
  • Finding anything fast
  • p. 194
  • Shifting Find into high gear
  • p. 196
  • Sorting Alphabetically and Numerically
  • p. 199
  • Sorting by a single field
  • p. 199
  • Chapter 2
  • Sorting on more than one field
  • p. 200
  • Fast and Furious Filtering
  • p. 201
  • Filtering by a field's content
  • p. 202
  • Filter by selection
  • p. 203
  • Filter by Form
  • p. 204
  • Navigating the Access Workspace
  • Unfiltering Filter by Form
  • p. 207
  • Filter by excluding selection
  • p. 207
  • Chapter 13
  • I Was Just Asking ... for Answers
  • p. 209
  • Simple (Yet Potent) Filter and Sort Tools
  • p. 210
  • Filter things first
  • Basic Training
  • p. 25
  • p. 210
  • Fact-finding with fun, fast filtering
  • p. 213
  • Here's the "advanced" part
  • p. 214
  • Select Queries
  • p. 220
  • Solid relationships are the key to getting it all (from your tables)
  • p. 221
  • Running the Query Wizard
  • Diving Right In
  • p. 221
  • Getting Your Feet Wet with Ad Hoc Queries
  • p. 227
  • Adding the finishing touches
  • p. 230
  • Saving the query
  • p. 231
  • Running your query
  • p. 233
  • Chapter 14
  • p. 27
  • I Want These AND Those OR Them
  • p. 235
  • Working with AND and/or OR
  • p. 236
  • Data from here to there
  • p. 237
  • Using multiple levels of AND
  • p. 238
  • Establishing criteria with OR
  • p. 239
  • Working with Onscreen Tools in Access
  • Combining AND with OR and OR with AND
  • p. 240
  • Chapter 15
  • Number Crunching with the Total Row
  • p. 243
  • Say Hello to the Total Row
  • p. 243
  • Adding the Total Row to Your Queries
  • p. 245
  • Working Out the Total Row
  • p. 29
  • p. 246
  • Putting it together with Group By
  • p. 247
  • Well, that certainly sums it up
  • p. 248
  • Counting, the easy way
  • p. 250
  • Narrowing the results with Where
  • p. 251
  • Creating Your Own Top-Ten List
  • Clicking tabs
  • p. 252
  • Choosing the Right Field for the Summary Instruction
  • p. 254
  • Chapter 16
  • Express Yourself with Formulas
  • p. 255
  • A Simple Calculation
  • p. 256
  • Complex Calculations
  • p. 258
  • p. 30
  • Calculate 'til you drop!
  • p. 259
  • Using one calculation in another
  • p. 259
  • Using parameter queries to ask for help
  • p. 261
  • "Adding" words with text formulas
  • p. 262
  • Hooray for Expression Builder
  • p. 264
  • Using buttons
  • Chapter 17
  • Take Charge with Action Queries
  • p. 269
  • Easy Update
  • p. 270
  • Add Records in a Flash
  • p. 274
  • Quick Cleanup
  • p. 277
  • Part 5
  • p. 31
  • Simple And Snazzy Reporting
  • p. 281
  • Chapter 18
  • Fast and Furious Automatic Reporting
  • p. 283
  • Quick and Not-SO-Dirty Automatic Reporting
  • p. 284
  • Creating a quick, one-table report
  • p. 285
  • Starting the Report Wizard
  • File tab and Quick Access tools
  • p. 289
  • Previewing Your Report
  • p. 294
  • Zooming in and out and all around
  • p. 295
  • Pop goes the menu
  • p. 297
  • Beauty Is Only Skin (Report) Deep
  • p. 298
  • Print Options tab
  • p. 5
  • p. 31
  • p. 298
  • Page tab
  • p. 300
  • Columns tab
  • p. 301
  • Chapter 19
  • Professionally Designed Reports Made Easy
  • p. 303
  • Report Repairs
  • p. 304
  • Accessing panes, panels, and context-sensitive tools
  • Report Organization
  • p. 305
  • Structural devices
  • p. 306
  • Page breaks
  • p. 308
  • Formatting Stuff
  • p. 310
  • Adding color
  • p. 313
  • p. 33
  • Relocation, relocation, relocation
  • p. 314
  • One size does not fit all
  • p. 316
  • Spaced-out controls
  • p. 317
  • Borderline beauty
  • p. 318
  • Tweaking your text
  • p. 321
  • Customizing the Access Workspace
  • Sneaking a Peek
  • p. 323
  • Getting a Themes Makeover
  • p. 324
  • Adding More Design Elements
  • p. 325
  • Drawing lines
  • p. 325
  • Pretty as a picture
  • p. 326
  • p. 34
  • Adding a Iogo
  • p. 327
  • Chapter 20
  • Groups and Page Breaks, Headers and Footers
  • p. 329
  • A Place for Everything and Everything in Its Place
  • p. 330
  • Layout basics
  • p. 330
  • Sections
  • Repositioning the Quick Access Toolbar
  • p. 332
  • Grouping your records
  • p. 335
  • So you want more?
  • p. 338
  • Customizing Properties
  • p. 338
  • Controlling report and page headings
  • p. 341
  • Adjusting individual sections
  • p. 34
  • p. 343
  • Itemized adjustments
  • p. 344
  • Chapter 21
  • Mailings to the Masses
  • p. 351
  • Massive Mailings with the Label Wizard
  • p. 351
  • Part 6
  • Parts of Tens
  • Adding buttons to the Quick Access Toolbar
  • p. 359
  • Chapter 22
  • Ten Common Problems
  • p. 361
  • That's Just Not Normal
  • p. 362
  • You Type 73.725, but it Changes to 74
  • p. 363
  • Words They Are A-Changing
  • p. 363
  • p. 35
  • Was There and Now It's Gone
  • p. 364
  • Undo
  • p. 365
  • Search for the missing record
  • p. 365
  • Backup recovery
  • p. 365
  • You Run a Query, but the Results Aren't What You Expect
  • p. 366
  • Removing buttons from the Quick Access Toolbar
  • Dreaded Parameter Dialog Box
  • p. 367
  • Slowest Database in Town
  • p. 368
  • Your Database File Is as Big as a House
  • p. 369
  • You Get a Mess When Importing Your Spreadsheet
  • p. 371
  • We're Sorry; Your Database File Is Corrupt
  • p. 371
  • Chapter 1
  • p. 37
  • Chapter 23
  • Ten Uncommon Tips
  • p. 373
  • Document Everything as Though One Day You'll Be
  • Questioned by the FBI
  • p. 374
  • Keep Your Fields as Small as Possible
  • p. 375
  • Use Number Fields for Real Numbers
  • p. 376
  • Minimizing the Ribbon
  • Validate Your Data
  • p. 376
  • Use Understandable Names to Keep Things Simple
  • p. 377
  • Delete with Great Caution
  • p. 377
  • Backup, Backup, Backup
  • p. 377
  • Think, Think, and Think Again
  • p. 378
  • p. 37
  • Get Organized and Stay Organized
  • p. 378
  • There's No Shame in Asking for Help
  • p. 379
  • Working with ScreenTips
  • p. 38
  • Mousing Around
  • p. 41
  • Navigating Access with the Alt Key
  • p. 41
  • Chapter 3
  • Access 2019 Basic Training
  • Database Basics
  • p. 43
  • Database Lingo
  • p. 43
  • Data, no matter how you pronounce it
  • p. 44
  • Fields of dreams (or data)
  • p. 44
  • Records
  • p. 45
  • p. 7
  • Database
  • p. 45
  • Field Types and Uses
  • p. 45
  • Choosing Between Flat and Relational Databases
  • p. 51
  • Isolationist tables
  • p. 51
  • Tables that mix and mingle
  • p. 52
  • What Is Access Good For, Anyway?
  • Building a Database
  • p. 53
  • Adding and Removing Tables
  • p. 57
  • One more, please
  • p. 57
  • Oops, I didn't mean to do that
  • p. 59
  • Part 2
  • Getting It All On The Table
  • p. 8
  • p. 61
  • Chapter 4
  • Sounds Like A Plan
  • p. 63
  • Planning Your Database Tables
  • p. 63
  • Reviewing fields
  • p. 64
  • Determining data types
  • p. 64
Control code
on1042099344
Dimensions
24 cm.
Extent
xiii, 407 pages
Isbn
9781119513261
Lccn
2018954128
Media category
unmediated
Media MARC source
rdamedia
Media type code
  • n
Note
005.7565 UL7 2019 ; XX-N ; [A18BP053, #1, 6@29.99, wjm/CSS ]
Other physical details
illustrations
System control number
  • (Sirsi) 1042099344
  • (OCoLC)1042099344
Label
Access 2019 for dummies, by Laurie Ann Ulrich and Ken Cook
Publication
Bibliography note
Includes index
Carrier category
volume
Carrier category code
  • nc
Carrier MARC source
rdacarrier
Content category
  • text
  • still image
Content type code
  • txt
  • sti
Content type MARC source
  • rdacontent
  • rdacontent
Contents
  • Building big databases
  • New normal
  • p. 66
  • Understanding normal forms
  • p. 66
  • Normalizing your tables
  • p. 67
  • Building Tables in Design View
  • p. 70
  • Creating fields
  • p. 70
  • p. 8
  • Setting data types
  • p. 72
  • Chapter 5
  • Table Tune Ups
  • p. 75
  • Primary Key to Success
  • p. 76
  • Lowdown on primary keys
  • p. 76
  • Creating a primary key
  • Creating databases with multiple tables
  • p. 77
  • Making Tables Get Along
  • p. 79
  • Rules of relationships
  • p. 79
  • Relationship types
  • p. 80
  • Building Table Relationships
  • p. 82
  • Relationships window
  • p. 9
  • p. 82
  • Table relationships
  • p. 83
  • Indexing for Faster Queries
  • p. 87
  • Creating your own index
  • p. 88
  • Adding and removing indexes
  • p. 91
  • Chapter 6
  • Databases with user forms
  • Remodeling Your Data
  • p. 93
  • Opening a Table for Editing
  • p. 94
  • Inserting Records and Fields
  • p. 97
  • Adding a record
  • p. 97
  • Inserting a field
  • p. 98
  • p. 12
  • Deleting a field
  • p. 101
  • Modifying Field Content
  • p. 102
  • Name-Calling
  • p. 103
  • Renaming fields
  • p. 104
  • Renaming a table
  • p. 106
  • Databases that require special reporting
  • Turn Uh-Oh! into Yee-Hah!
  • p. 108
  • Chapter 7
  • Types, Masks, and Triggers
  • p. 109
  • Access Table Settings
  • p. 110
  • Field Data Formats
  • p. 112
  • Text fields
  • p. 13
  • p. 113
  • Number and currency fields
  • p. 115
  • Date/time fields
  • p. 118
  • Yes/No fields
  • p. 119
  • Gaining Control of Data Entry
  • p. 121
  • You really need to put a mask on those fields
  • What's New in Access 2019?
  • p. 121
  • To require or not to require
  • p. 128
  • Making your data toe the line with validation
  • p. 129
  • Give Your Fingers a Mini Vacation by Default
  • p. 131
  • Part 3
  • Data Management Mania
  • p. 133
  • p. 16
  • Chapter 8
  • A Form For All Reasons
  • p. 135
  • Generating Forms
  • p. 135
  • Keeping it simple: Form tools
  • p. 137
  • Granting most wishes: The Form Wizard
  • p. 139
  • Customizing Form Parts
  • Part 1
  • Reach Out with SharePoint
  • p. 143
  • Taking the Layout view
  • p. 143
  • Theme's the thing
  • p. 145
  • Managing form controls
  • p. 145
  • Managing Data in Form View
  • p. 150
  • Navigating and finding records
  • p. 17
  • p. 150
  • Saving, clearing, and deleting
  • p. 151
  • Chapter 9
  • Importing And Exporting Data
  • p. 153
  • Retrieving Data from Other Sources
  • p. 154
  • Translating data formats
  • p. 154
  • How Access Works and How You Work with It
  • Importing and linking
  • p. 157
  • Hit the Road, Data
  • p. 162
  • Export formats
  • p. 162
  • Exporting table or query data
  • p. 163
  • Exporting a report to PDF
  • p. 165
  • p. 18
  • Chapter 10
  • Automatically Editing Data
  • p. 167
  • Please Read This First!
  • p. 167
  • Creating Consistent Corrections
  • p. 170
  • Using Queries to Automate the Editing Process
  • p. 173
  • Looking for duplicate records
  • Opening Access
  • p. 173
  • Running the Find Duplicates Query Wizard
  • p. 174
  • Chapter 11
  • Access and the Web
  • p. 179
  • How Access Works with the Web
  • p. 179
  • Understanding Office 365
  • p. 180
  • p. 18
  • Connect Office 365 to Access 2019
  • p. 181
  • Your data and the cloud
  • p. 182
  • Upload your Access desktop data to the cloud
  • p. 183
  • Click! Using Hyperlinks in your desktop Access database
  • p. 186
  • Adding a Hyperlink field to your desktop database table
  • p. 187
  • Selecting a starting point
  • Fine-tuning your hyperlinks
  • p. 188
  • Testing links
  • p. 190
  • Part 4
  • Power of Questions
  • p. 191
  • Chapter 12
  • Finding, Filtering, and Sorting Your Data-Fast
  • p. 193
  • p. 19
  • Using the Find Command
  • p. 194
  • Finding anything fast
  • p. 194
  • Shifting Find into high gear
  • p. 196
  • Sorting Alphabetically and Numerically
  • p. 199
  • Sorting by a single field
  • p. 199
  • Chapter 2
  • Sorting on more than one field
  • p. 200
  • Fast and Furious Filtering
  • p. 201
  • Filtering by a field's content
  • p. 202
  • Filter by selection
  • p. 203
  • Filter by Form
  • p. 204
  • Navigating the Access Workspace
  • Unfiltering Filter by Form
  • p. 207
  • Filter by excluding selection
  • p. 207
  • Chapter 13
  • I Was Just Asking ... for Answers
  • p. 209
  • Simple (Yet Potent) Filter and Sort Tools
  • p. 210
  • Filter things first
  • Basic Training
  • p. 25
  • p. 210
  • Fact-finding with fun, fast filtering
  • p. 213
  • Here's the "advanced" part
  • p. 214
  • Select Queries
  • p. 220
  • Solid relationships are the key to getting it all (from your tables)
  • p. 221
  • Running the Query Wizard
  • Diving Right In
  • p. 221
  • Getting Your Feet Wet with Ad Hoc Queries
  • p. 227
  • Adding the finishing touches
  • p. 230
  • Saving the query
  • p. 231
  • Running your query
  • p. 233
  • Chapter 14
  • p. 27
  • I Want These AND Those OR Them
  • p. 235
  • Working with AND and/or OR
  • p. 236
  • Data from here to there
  • p. 237
  • Using multiple levels of AND
  • p. 238
  • Establishing criteria with OR
  • p. 239
  • Working with Onscreen Tools in Access
  • Combining AND with OR and OR with AND
  • p. 240
  • Chapter 15
  • Number Crunching with the Total Row
  • p. 243
  • Say Hello to the Total Row
  • p. 243
  • Adding the Total Row to Your Queries
  • p. 245
  • Working Out the Total Row
  • p. 29
  • p. 246
  • Putting it together with Group By
  • p. 247
  • Well, that certainly sums it up
  • p. 248
  • Counting, the easy way
  • p. 250
  • Narrowing the results with Where
  • p. 251
  • Creating Your Own Top-Ten List
  • Clicking tabs
  • p. 252
  • Choosing the Right Field for the Summary Instruction
  • p. 254
  • Chapter 16
  • Express Yourself with Formulas
  • p. 255
  • A Simple Calculation
  • p. 256
  • Complex Calculations
  • p. 258
  • p. 30
  • Calculate 'til you drop!
  • p. 259
  • Using one calculation in another
  • p. 259
  • Using parameter queries to ask for help
  • p. 261
  • "Adding" words with text formulas
  • p. 262
  • Hooray for Expression Builder
  • p. 264
  • Using buttons
  • Chapter 17
  • Take Charge with Action Queries
  • p. 269
  • Easy Update
  • p. 270
  • Add Records in a Flash
  • p. 274
  • Quick Cleanup
  • p. 277
  • Part 5
  • p. 31
  • Simple And Snazzy Reporting
  • p. 281
  • Chapter 18
  • Fast and Furious Automatic Reporting
  • p. 283
  • Quick and Not-SO-Dirty Automatic Reporting
  • p. 284
  • Creating a quick, one-table report
  • p. 285
  • Starting the Report Wizard
  • File tab and Quick Access tools
  • p. 289
  • Previewing Your Report
  • p. 294
  • Zooming in and out and all around
  • p. 295
  • Pop goes the menu
  • p. 297
  • Beauty Is Only Skin (Report) Deep
  • p. 298
  • Print Options tab
  • p. 5
  • p. 31
  • p. 298
  • Page tab
  • p. 300
  • Columns tab
  • p. 301
  • Chapter 19
  • Professionally Designed Reports Made Easy
  • p. 303
  • Report Repairs
  • p. 304
  • Accessing panes, panels, and context-sensitive tools
  • Report Organization
  • p. 305
  • Structural devices
  • p. 306
  • Page breaks
  • p. 308
  • Formatting Stuff
  • p. 310
  • Adding color
  • p. 313
  • p. 33
  • Relocation, relocation, relocation
  • p. 314
  • One size does not fit all
  • p. 316
  • Spaced-out controls
  • p. 317
  • Borderline beauty
  • p. 318
  • Tweaking your text
  • p. 321
  • Customizing the Access Workspace
  • Sneaking a Peek
  • p. 323
  • Getting a Themes Makeover
  • p. 324
  • Adding More Design Elements
  • p. 325
  • Drawing lines
  • p. 325
  • Pretty as a picture
  • p. 326
  • p. 34
  • Adding a Iogo
  • p. 327
  • Chapter 20
  • Groups and Page Breaks, Headers and Footers
  • p. 329
  • A Place for Everything and Everything in Its Place
  • p. 330
  • Layout basics
  • p. 330
  • Sections
  • Repositioning the Quick Access Toolbar
  • p. 332
  • Grouping your records
  • p. 335
  • So you want more?
  • p. 338
  • Customizing Properties
  • p. 338
  • Controlling report and page headings
  • p. 341
  • Adjusting individual sections
  • p. 34
  • p. 343
  • Itemized adjustments
  • p. 344
  • Chapter 21
  • Mailings to the Masses
  • p. 351
  • Massive Mailings with the Label Wizard
  • p. 351
  • Part 6
  • Parts of Tens
  • Adding buttons to the Quick Access Toolbar
  • p. 359
  • Chapter 22
  • Ten Common Problems
  • p. 361
  • That's Just Not Normal
  • p. 362
  • You Type 73.725, but it Changes to 74
  • p. 363
  • Words They Are A-Changing
  • p. 363
  • p. 35
  • Was There and Now It's Gone
  • p. 364
  • Undo
  • p. 365
  • Search for the missing record
  • p. 365
  • Backup recovery
  • p. 365
  • You Run a Query, but the Results Aren't What You Expect
  • p. 366
  • Removing buttons from the Quick Access Toolbar
  • Dreaded Parameter Dialog Box
  • p. 367
  • Slowest Database in Town
  • p. 368
  • Your Database File Is as Big as a House
  • p. 369
  • You Get a Mess When Importing Your Spreadsheet
  • p. 371
  • We're Sorry; Your Database File Is Corrupt
  • p. 371
  • Chapter 1
  • p. 37
  • Chapter 23
  • Ten Uncommon Tips
  • p. 373
  • Document Everything as Though One Day You'll Be
  • Questioned by the FBI
  • p. 374
  • Keep Your Fields as Small as Possible
  • p. 375
  • Use Number Fields for Real Numbers
  • p. 376
  • Minimizing the Ribbon
  • Validate Your Data
  • p. 376
  • Use Understandable Names to Keep Things Simple
  • p. 377
  • Delete with Great Caution
  • p. 377
  • Backup, Backup, Backup
  • p. 377
  • Think, Think, and Think Again
  • p. 378
  • p. 37
  • Get Organized and Stay Organized
  • p. 378
  • There's No Shame in Asking for Help
  • p. 379
  • Working with ScreenTips
  • p. 38
  • Mousing Around
  • p. 41
  • Navigating Access with the Alt Key
  • p. 41
  • Chapter 3
  • Access 2019 Basic Training
  • Database Basics
  • p. 43
  • Database Lingo
  • p. 43
  • Data, no matter how you pronounce it
  • p. 44
  • Fields of dreams (or data)
  • p. 44
  • Records
  • p. 45
  • p. 7
  • Database
  • p. 45
  • Field Types and Uses
  • p. 45
  • Choosing Between Flat and Relational Databases
  • p. 51
  • Isolationist tables
  • p. 51
  • Tables that mix and mingle
  • p. 52
  • What Is Access Good For, Anyway?
  • Building a Database
  • p. 53
  • Adding and Removing Tables
  • p. 57
  • One more, please
  • p. 57
  • Oops, I didn't mean to do that
  • p. 59
  • Part 2
  • Getting It All On The Table
  • p. 8
  • p. 61
  • Chapter 4
  • Sounds Like A Plan
  • p. 63
  • Planning Your Database Tables
  • p. 63
  • Reviewing fields
  • p. 64
  • Determining data types
  • p. 64
Control code
on1042099344
Dimensions
24 cm.
Extent
xiii, 407 pages
Isbn
9781119513261
Lccn
2018954128
Media category
unmediated
Media MARC source
rdamedia
Media type code
  • n
Note
005.7565 UL7 2019 ; XX-N ; [A18BP053, #1, 6@29.99, wjm/CSS ]
Other physical details
illustrations
System control number
  • (Sirsi) 1042099344
  • (OCoLC)1042099344

Library Locations

    • Boardwalk BranchBorrow it
      8656 N. Ambassador Drive, Kansas City, MO, 64154 , US
      39.25022 -94.65048
    • Lee's Summit BranchBorrow it
      150 NW Oldham Pkwy., Lee's Summit, MO, 64081 , US
      38.915628 -94.400799
    • North Oak BranchBorrow it
      8700 N. Oak Street Tfwy., Kansas City, MO, 64155 , US
      39.251581 -94.576666
    • Riverside BranchBorrow it
      2700 N.W. Vivion Road, Riverside, MO, 64150, US
      39.178749 -94.612022
    • South Independence BranchBorrow it
      13700 E. 35th St., Independence, MO, 64055 , US
      39.05803 -94.41822
Processing Feedback ...