Access 2010 All-in-One For Dummies
Published on 5. May 2010
792 pages
978-0-470-65177-3 (ISBN)
Description
The all-in-one reference to all aspects of Microsoft Access2010
If you want to learn Microsoft Access inside and out, the nineminibooks in this easy-access reference are exactly what you need.Read the book cover to cover, or jump into any of the minibooks forthe instruction and topics you need most. Learn how to connectAccess to SQL Server, manipulate your data locally, use nifty newfeatures from Office 2010 such as the enhanced Ribbon, createqueries and macros like a champ, and much more. From the basics toadvanced functions, it's what you need to make Access moreaccesssible.
* Shows you how to store, organize, view, analyze, and share datausing Microsoft Access 2010, the database application included withMicrosoft Office 2010
* Includes nine minibooks that cover such topics as databasedesign, tables, queries, forms, reports, macros, databaseadministration, securing data, programming with Visual Basic forApplications (VBA), and using Access with the Web
* Helps you build database solutions that integrate with the Weband other enterprise data sources
* Offers plenty of techniques, tips, and tricks to help you getthe most out of Access
This all-in-one guide contains everything you need to startpower-using Access 2010!
More details
Other editions
Additional editions
Alison Barrows | Margaret Levine Young | Joseph C. Stockman
Access 2010 All-in-One For Dummies
Book
05/2010
Wiley
€37.50
Shipment within 10-20 days
Persons
Alison Barrows has written books on Access, Windows, and theInternet, including Access For Dummies Quick Reference.
Margaret Levine Young is coauthor of over two dozenbooks, including The Internet For Dummies.
Joseph C. Stockman is an independent consultant, softwaredesigner, and author.
Content
Introduction 1
Book I: Essential Concepts 7
Chapter 1: Introducing Access 2010 9
Chapter 2: Getting Started, Getting Around 17
Chapter 3: Designing Your Database the Relational Way 37
Book II: Tables for Storing Your Data 65
Chapter 1: Creating and Modifying Tables 67
Chapter 2: Refining Your Table in Design View 103
Chapter 3: Sorting, Finding, and Filtering Data in a Datasheet 121
Chapter 4: Importing and Exporting Data 137
Chapter 5: Avoiding "Garbage In, Garbage Out" 161
Chapter 6: Relating Your Tables and Protecting Your Data 179
Book III: Queries (or Getting Information from Your Data) 189
Chapter 1: Creating Select Queries 191
Chapter 2: Letting Queries Do the Math 223
Chapter 3: Doing Neat Things with Action Queries and Query Wizards 257
Chapter 4: Viewing Your Data from All Angles Using Crosstabs and PivotTables 279
Book IV: Forms for Editing Data 303
Chapter 1: Designing and Using Forms (and Reports) 305
Chapter 2: Jazzing Up Your Forms (and Reports) 329
Chapter 3: Creating Smarter Forms 353
Chapter 4: Doing Calculations in Forms and Subforms (and Reports) 377
Book V: Reporting in Words and Pictures 397
Chapter 1: Creating and Spiffing Up Reports 399
Chapter 2: Printing Beautiful Reports 427
Chapter 3: Creating Charts and Graphs from Your Data 445
Book VI: Automation with Macros 471
Chapter 1: Making Macros Do the Work 473
Chapter 2: Making Macros Smarter 491
Book VII: Database Administration 509
Chapter 1: Database Housekeeping 511
Chapter 2: Sharing the Fun: Managing Multiuser Access 521
Chapter 3: Securing Your Access Database 535
Book VIII: Programming in VBA 547
Chapter 1: What the Heck Is VBA? 549
Chapter 2: Writing Code 569
Chapter 3: Writing Smarter Code 593
Chapter 4: Controlling Forms with VBA 617
Chapter 5: Using SQL and Recordsets 641
Chapter 6: Debugging Your Code 653
Book IX: Going Beyond Access 663
Chapter 1: Automation with Other Office Programs 665
Chapter 2: Using Access as a Front-End to SQL Server 681
Chapter 3: Using Access with SharePoint 697
Appendix: Installing Microsoft Access 719
Index 725
