• Access 2010 All-in-One For Dummies See large image

    Access 2010 All-in-One For Dummies (For Dummies) (Paperback) By (author) Alison Barrows, By (author) Margaret Levine Young, By (author) Joseph C. Stockman

    $31.28 - Save $14.11 31% off - RRP $45.39 Free delivery worldwide Available
    Dispatched in 10 business days
    When will my order arrive?
    Add to basket | Add to wishlist |

    DescriptionThe 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!


Other books

Other people who viewed this bought | Other books in this category
Showing items 1 to 10 of 10

 

Reviews | Bibliographic data
  • Full bibliographic data for Access 2010 All-in-One For Dummies

    Title
    Access 2010 All-in-One For Dummies
    Authors and contributors
    By (author) Alison Barrows, By (author) Margaret Levine Young, By (author) Joseph C. Stockman
    Physical properties
    Format: Paperback
    Number of pages: 792
    Width: 187 mm
    Height: 232 mm
    Thickness: 42 mm
    Weight: 1,160 g
    Language
    English
    ISBN
    ISBN 13: 9780470532188
    ISBN 10: 0470532181
    Classifications

    BIC E4L: COM
    Nielsen BookScan Product Class 3: S10.2
    B&T Book Type: NF
    B&T Modifier: Region of Publication: 01
    B&T Modifier: Subject Development: 20
    B&T Modifier: Academic Level: 05
    B&T Modifier: Continuations: 02
    B&T Modifier: Text Format: 01
    LC subject heading:
    B&T Merchandise Category: COM
    Warengruppen-Systematik des deutschen Buchhandels: 26320
    DC22: 005.7565
    LC subject heading:
    BIC subject category V2: UNSC
    Ingram Subject Code: XD
    Libri: I-XD
    B&T Approval Code: A93905500
    BISAC V2.8: COM021000
    B&T General Subject: 228
    DC22: 005.75/65
    BISAC V2.8: COM084010
    B&T Approval Code: A48401631
    LC classification: QA76.9.D3 Y67 2010
    Edition statement
    New ed.
    Illustrations note
    Illustrations
    Publisher
    John Wiley and Sons Ltd
    Imprint name
    John Wiley & Sons Ltd
    Publication date
    14 May 2010
    Publication City/Country
    Chichester
    Author Information
    Alison Barrows has written books on Access, Windows, and the Internet, including Access For Dummies Quick Reference. Margaret Levine Young is coauthor of over two dozen books, including The Internet For Dummies. Joseph C. Stockman is an independent consultant, software designer, and author.
    Back cover copy
    Build powerful custom database solutions to keep your data organized and accessibleWhat kind of golden nuggets are in your data? This reference shows how to take advantage of Microsoft Access 2010's new features and capabilities so you can, well, access the information you need. You'll breeze through everything from tables, queries, and forms to database administration and Visual Basic for Applications as you learn this program.Set the table -- follow easy ways to make new tables, create table templates, and utilize the Table WizardPick and choose your data -- learn how to find the information you want and organize it in a way that's more usefulGet creative with forms -- build your own forms using the Form WizardCut your workload -- find out how to write simple instructions that tell Access how to automate steps instead of doing it yourselfShow it off -- see the best ways to design reports and print form letters, mailing labels, numbers with totals and subtotals, and moreKeep your database clean -- discover what you need to do to ensure that your data is neat and tidyGo beyond Access -- interact with and move data to and from other programs on your computer or computers all over the worldOpen the book and find: How to easily design your relational databaseWays to create select queriesHow to design and use forms for editing dataTechniques for spiffing up reports with charts and graphsMethods for making macros smarterSteps for securing your databaseTips for programming in VBAHow to use Access with SharePoint and SQL Server9 Books in 1Essential ConceptsTablesQueriesFormsReportsMacrosDatabase AdministrationProgramming in VBAGoing Beyond Access
    Table of contents
    Introduction. Book I: Essential Concepts. Chapter 1: Introducing Access 2010. Chapter 2: Getting Started, Getting Around. Chapter 3: Designing Your Database the Relational Way. Book II: Tables for Storing Your Data. Chapter 1: Creating and Modifying Tables. Chapter 2: Refi ning Your Table in Design View. Chapter 3: Sorting, Finding, and Filtering Data in a Datasheet. Chapter 4: Importing and Exporting Data. Chapter 5: Avoiding "Garbage In, Garbage Out". Chapter 6: Relating Your Tables and Protecting Your Data. Book III: Queries (or Getting Information from Your Data). Chapter 1: Creating Select Queries. Chapter 2: Letting Queries Do the Math. Chapter 3: Doing Neat Things with Action Queries and Query Wizards. Chapter 4: Viewing Your Data from All Angles Using Crosstabs and PivotTables. Book IV: Forms for Editing Data. Chapter 1: Designing and Using Forms (and Reports). Chapter 2: Jazzing Up Your Forms (and Reports). Chapter 3: Creating Smarter Forms. Chapter 4: Doing Calculations in Forms and Subforms (and Reports). Book V: Reporting in Words and Pictures. Chapter 1: Creating and Spiffi ng Up Reports. Chapter 2: Printing Beautiful Reports. Chapter 3: Creating Charts and Graphs from Your Data. Book VI: Automation with Macros. Chapter 1: Making Macros Do the Work. Chapter 2: Making Macros Smarter. Book VII: Database Administration. Chapter 1: Database Housekeeping. Chapter 2: Sharing the Fun: Managing Multiuser Access. Chapter 3: Securing Your Access Database. Book VIII: Programming in VBA. Chapter 1: What the Heck Is VBA? Chapter 2: Writing Code. Chapter 3: Writing Smarter Code. Chapter 4: Controlling Forms with VBA. Chapter 5: Using SQL and Recordsets. Chapter 6: Debugging Your Code. Book IX: Going Beyond Access. Chapter 1: Automation with Other Offi ce Programs. Chapter 2: Using Access as a Front-End to SQL Server. Chapter 3: Using Access with SharePoint. Appendix: Installing Microsoft Access. Index.