Coverart for item
The Resource Access 2010 for dummies, by Laurie Ulrich-Fuller and Ken Cook

Access 2010 for dummies, by Laurie Ulrich-Fuller and Ken Cook

Label
Access 2010 for dummies
Title
Access 2010 for dummies
Statement of responsibility
by Laurie Ulrich-Fuller and Ken Cook
Creator
Contributor
Subject
Language
eng
Summary
Overview: A friendly, step-by-step guide to the Microsoft Office database application. Access may be the least understood and most challenging application in the Microsoft Office suite. This guide is designed to help anyone who lacks experience in creating and managing a database learns to use Access 2010 quickly and easily. In the classic For Dummies tradition, the book provides an education in Access, the interface, and the architecture of a database. It explains the process of building a database, linking information, sharing data, generating reports, and much more. As the Microsoft Office database application, Access may be the least understood and most challenging part of the Office suite; Access 2010 For Dummies walks newcomers through building and using their first database; Covers linking information in a database, setting relationships, modeling data, and building tables; Explores how to extract data from Access and get specific answers, create forms, and export data in reports; A section for more experienced users looks at analyzing errors and creating an interface; Fully updated for the newest version, Access 2010 For Dummies gets new Access users up to speed and helps veterans get the most from the Office database application
Member of
Cataloging source
BTCTA
http://library.link/vocab/creatorDate
1961-
http://library.link/vocab/creatorName
Ulrich-Fuller, Laurie
Dewey number
005.7565
Illustrations
illustrations
Index
index present
LC call number
QA76.9.D3
LC item number
U475 2010
Literary form
non fiction
Nature of contents
bibliography
http://library.link/vocab/relatedWorkOrContributorDate
1959-
http://library.link/vocab/relatedWorkOrContributorName
Cook, Ken
Series statement
--For dummies
http://library.link/vocab/subjectName
Database management
Label
Access 2010 for dummies, by Laurie Ulrich-Fuller and Ken Cook
Instantiates
Publication
Bibliography note
Includes bibliographical references and index
Contents
  • Introduction -- About this book -- Conventions used in this book -- What you don't have to read -- Foolish assumptions -- How this book is organized -- Part 1: Basic Training -- Part 2: Getting It All On The Table -- Part 3: Data Mania And Management -- Part 4: Ask Your Data, And Ye Shall Receive Answers -- Part 5: Plain And Fancy Reporting -- Part 7: Part Of Tens -- Appendix: Getting help -- Icons used in this book -- Where to go from here -- Part 1: Basic Training -- Chapter 1: Getting to know Access 2010 -- What is Access good for, anyway? -- Building big databases -- Creating databases with multiple tables -- Databases with user forms -- Databases that require special reporting -- What's new in Access 2010? -- New and improved features -- Reach out with SharePoint -- How Access works and how you work with it -- Opening Access -- Selecting a starting point -- Now what? -- Chapter 2: Finding your way around access -- Diving right in -- Working with on-screen tools in Access -- Clicking tabs -- Using buttons -- 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 screen tips -- 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 -- 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 -- Part 2: Getting It All On The Table -- Chapter 4: Keys, relationships, and indexes -- Primary key to success -- Lowdown on primary keys -- Creating a primary key -- Making tables get along -- Rules of relationships -- Relationship types -- Building table relationships -- Relationships window -- Table relationships -- Indexing for faster queries -- Create your own index -- Adding and removing indexes -- Chapter 5: 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 6: What's happening under the table? -- Access table settings -- Field data formats -- Text and memo 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 3: Data Mania And Management -- Chapter 7: Creating data forms -- Generating forms -- Keeping it simple: AutoForm -- Granting most wishes: the form wizard -- Customizing form parts -- Taking the layout view -- Theme's the thing -- Managing form controls -- Chapter 8: Importing and exporting data -- Retrieving data from other sources -- Translating file formats -- Importing and linking -- Get this data out of here -- Export formats -- Exporting table or query data -- Chapter 9: Editing data automatically -- 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 10: Gather locally, share globally -- Access and the Web -- Click! Using hyperlinks in your Access databases -- Adding a hyperlink field to your table -- Typing your hyperlinks -- Fine tuning your hyperlinks -- Testing links -- Embedding Web content into your Access forms -- Adding hyperlinks to your form -- Publishing your data to the Web -- Publishing your Access tables -- Part 5: Ask Your Data,
  • Chapter 13: I'll take these and those or them -- Working with AND and /or OR -- Data from here to there -- Using multiple levels and AND -- Establishing criteria with OR -- Combining AND with OR and OR with AND -- Chapter 14: Queries that think faster than you -- Kissing that calculator goodbye via the total row -- Adding the total row to your queries -- Giving the total row a workout -- Organizing things with group by -- Performing sums -- Counting, the easy way -- Narrowing the results with where -- Creating your own top-ten list -- Choosing the right field for the summary instruction -- Chapter 15: Calculating with your data -- Simple calculation -- Complex calculations -- Calculate until you need calculate no more! -- Using one calculation in another -- Using parameter queries to ask for help -- Daisy-chaining your words with text formulas -- Expression builder (somewhat) to the rescue -- Chapter 16: Flying into action queries -- Easy update -- Add records in a flash -- Quick cleanup -- Part 5: Plain And Fancy Reporting -- Chapter 17: Quick and not-so-dirty automatic reporting -- Fast and furious 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 -- Print options tab -- Page tab -- Columns tab -- Chapter 18: Dazzling report design -- Taking your report in for service -- Report organization -- Structural devices -- Page breaks -- Formatting this, that, and the other -- 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 -- Chapter 19: Headers and footers and groups, oh my! -- 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 20: Magical mass mailings -- Massive mailings with the label wizard -- Part 6: More Power To You -- Chapter 21: Making it all better with the analyzer tools -- Convert your flat files to relational tables with analyzer -- Record database object details with the database documenter -- Improve database performance without steroids -- Chapter 22: Hello! Creating an interface to welcome database users -- Comings and goings of navigation form -- Creating 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 7: Parts Of Tens -- Chapter 23: Ten common problems -- That's just not normal -- You type 73-725, but it changes to 74 -- 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 -- Validation that never was -- 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 24: Ten uncommon tips -- Document everything as thought you'll be questioned by the FBI -- Keep your fields as small as possible -- Use number fields for real number -- Validate your data -- Use understandable names to keep things simple -- Delete with great caution -- Back up, back up, back up -- Think, think, and think again -- Get organized and stay organized -- There's no shame in asking for help -- Index
Control code
ocn567008092
Dimensions
24 cm.
Extent
xvi, 438 p.
Isbn
9780470497470
Isbn Type
(pbk.)
Lccn
2010925160
Other physical details
ill.
System control number
(OCoLC)567008092
Label
Access 2010 for dummies, by Laurie Ulrich-Fuller and Ken Cook
Publication
Bibliography note
Includes bibliographical references and index
Contents
  • Introduction -- About this book -- Conventions used in this book -- What you don't have to read -- Foolish assumptions -- How this book is organized -- Part 1: Basic Training -- Part 2: Getting It All On The Table -- Part 3: Data Mania And Management -- Part 4: Ask Your Data, And Ye Shall Receive Answers -- Part 5: Plain And Fancy Reporting -- Part 7: Part Of Tens -- Appendix: Getting help -- Icons used in this book -- Where to go from here -- Part 1: Basic Training -- Chapter 1: Getting to know Access 2010 -- What is Access good for, anyway? -- Building big databases -- Creating databases with multiple tables -- Databases with user forms -- Databases that require special reporting -- What's new in Access 2010? -- New and improved features -- Reach out with SharePoint -- How Access works and how you work with it -- Opening Access -- Selecting a starting point -- Now what? -- Chapter 2: Finding your way around access -- Diving right in -- Working with on-screen tools in Access -- Clicking tabs -- Using buttons -- 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 screen tips -- 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 -- 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 -- Part 2: Getting It All On The Table -- Chapter 4: Keys, relationships, and indexes -- Primary key to success -- Lowdown on primary keys -- Creating a primary key -- Making tables get along -- Rules of relationships -- Relationship types -- Building table relationships -- Relationships window -- Table relationships -- Indexing for faster queries -- Create your own index -- Adding and removing indexes -- Chapter 5: 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 6: What's happening under the table? -- Access table settings -- Field data formats -- Text and memo 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 3: Data Mania And Management -- Chapter 7: Creating data forms -- Generating forms -- Keeping it simple: AutoForm -- Granting most wishes: the form wizard -- Customizing form parts -- Taking the layout view -- Theme's the thing -- Managing form controls -- Chapter 8: Importing and exporting data -- Retrieving data from other sources -- Translating file formats -- Importing and linking -- Get this data out of here -- Export formats -- Exporting table or query data -- Chapter 9: Editing data automatically -- 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 10: Gather locally, share globally -- Access and the Web -- Click! Using hyperlinks in your Access databases -- Adding a hyperlink field to your table -- Typing your hyperlinks -- Fine tuning your hyperlinks -- Testing links -- Embedding Web content into your Access forms -- Adding hyperlinks to your form -- Publishing your data to the Web -- Publishing your Access tables -- Part 5: Ask Your Data,
  • Chapter 13: I'll take these and those or them -- Working with AND and /or OR -- Data from here to there -- Using multiple levels and AND -- Establishing criteria with OR -- Combining AND with OR and OR with AND -- Chapter 14: Queries that think faster than you -- Kissing that calculator goodbye via the total row -- Adding the total row to your queries -- Giving the total row a workout -- Organizing things with group by -- Performing sums -- Counting, the easy way -- Narrowing the results with where -- Creating your own top-ten list -- Choosing the right field for the summary instruction -- Chapter 15: Calculating with your data -- Simple calculation -- Complex calculations -- Calculate until you need calculate no more! -- Using one calculation in another -- Using parameter queries to ask for help -- Daisy-chaining your words with text formulas -- Expression builder (somewhat) to the rescue -- Chapter 16: Flying into action queries -- Easy update -- Add records in a flash -- Quick cleanup -- Part 5: Plain And Fancy Reporting -- Chapter 17: Quick and not-so-dirty automatic reporting -- Fast and furious 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 -- Print options tab -- Page tab -- Columns tab -- Chapter 18: Dazzling report design -- Taking your report in for service -- Report organization -- Structural devices -- Page breaks -- Formatting this, that, and the other -- 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 -- Chapter 19: Headers and footers and groups, oh my! -- 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 20: Magical mass mailings -- Massive mailings with the label wizard -- Part 6: More Power To You -- Chapter 21: Making it all better with the analyzer tools -- Convert your flat files to relational tables with analyzer -- Record database object details with the database documenter -- Improve database performance without steroids -- Chapter 22: Hello! Creating an interface to welcome database users -- Comings and goings of navigation form -- Creating 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 7: Parts Of Tens -- Chapter 23: Ten common problems -- That's just not normal -- You type 73-725, but it changes to 74 -- 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 -- Validation that never was -- 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 24: Ten uncommon tips -- Document everything as thought you'll be questioned by the FBI -- Keep your fields as small as possible -- Use number fields for real number -- Validate your data -- Use understandable names to keep things simple -- Delete with great caution -- Back up, back up, back up -- Think, think, and think again -- Get organized and stay organized -- There's no shame in asking for help -- Index
Control code
ocn567008092
Dimensions
24 cm.
Extent
xvi, 438 p.
Isbn
9780470497470
Isbn Type
(pbk.)
Lccn
2010925160
Other physical details
ill.
System control number
(OCoLC)567008092

Library Locations

    • CRPL-Downtown LibraryBorrow it
      450 5th Avenue SE, Cedar Rapids, IA, 52401, US
      41.976964 -91.6624043
    • Hiawatha Public LibraryBorrow it
      150 West Willman Street, Hiawatha, IA, 52233, US
      42.037121 -91.672304
Processing Feedback ...