+612 9045 4394
Access 2010 All-In-One For Dummies : For Dummies Series - Alison Barrows

Access 2010 All-In-One For Dummies

For Dummies Series


Published: 14th May 2010
Ships: 15 business days
15 business days
RRP $56.95
if ordered within

eBook View Product

Published: 9th April 2010
Format: ePUB

The all-in-one reference to all aspects of Microsoft Access 2010

If you want to learn Microsoft Access inside and out, the nine minibooks in this easy-access reference are exactly what you need. Read the book cover to cover, or jump into any of the minibooks for the instruction and topics you need most. Learn how to connect Access to SQL Server, manipulate your data locally, use nifty new features from Office 2010 such as the enhanced Ribbon, create queries and macros like a champ, and much more. From the basics to advanced functions, it’s what you need to make Access more accesssible.

- Shows you how to store, organize, view, analyze, and share data using Microsoft Access 2010, the database application included with Microsoft Office 2010

- Includes nine minibooks that cover such topics as database design, tables, queries, forms, reports, macros, database administration, securing data, programming with Visual Basic for Applications (VBA), and using Access with the Web

- Helps you build database solutions that integrate with the Web and other enterprise data sources

- Offers plenty of techniques, tips, and tricks to help you get the most out of Access

This all-in-one guide contains everything you need to start power-using Access 2010!



by PowerReviews
Access 2010 All-In-One For Dummies

(based on 1 review)

Ratings Distribution

  • 5 Stars



  • 4 Stars



  • 3 Stars



  • 2 Stars



  • 1 Stars



Reviewed by 1 customer

Displaying review 1

Back to top


Handy ALL-IN-ONE to own


from Melbourne

About Me Casual Reader

Verified Buyer


  • Informative
  • Relevant


    Best Uses

      Comments about Access 2010 All-In-One For Dummies:

      Easy to use and get your mind around.

      Displaying review 1

      Back to top

      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

      ISBN: 9780470532188
      ISBN-10: 0470532181
      Series: For Dummies Series
      Audience: General
      Format: Paperback
      Language: English
      Number Of Pages: 792
      Published: 14th May 2010
      Publisher: John Wiley and Sons Ltd
      Country of Publication: GB
      Dimensions (cm): 23.5 x 19.0  x 4.0
      Edition Number: 1