Access 2013 All-in-One For Dummies

Book Description

Get started with the new Access 2013 with this impressive all-in-one reference!

Microsoft Access allows you to store, organize, view, analyze, and share data; the new release enables you to build even more powerful, custom database solutions that integrate with the web and enterprise data sources. This compilation of nine indispensible minibooks is exactly what you need to get up to speed on the latest changes to Access. This easy-to-understand resource provides both new and experienced Access users with invaluable advice for connecting Access to SQL Server, manipulating data locally, getting up to speed on the latest features of Access 2013, creating queries and macros, and much more. From the basics to advanced functions, this book is what you need to make Access more accessible.

  • Shows you how to store, organize, view, analyze, and share data using Access 2013
  • 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 solutions
  • Offers plenty of techniques, tips, and tricks to help you get the most out of Access

This all-in-one guide offers you access to all things Access 2013!

Table of Contents
Book I: Getting Started with Access 2013
Chapter 1. Introducing Access 2013
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

Book IV: Forms for Editing Data
Chapter 1. Designing Custom 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 Spiffing 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 Data

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 Office Programs
Chapter 2. Using Access As a Front End to SQL Server
Chapter 3. Using Access with SharePoint

Book Details

  • Paperback: 792 pages
  • Publisher: For Dummies; 1 edition (April 8, 2013)
  • Language: English
  • ISBN-10: 1118510550
  • ISBN-13: 978-1118510551

Note: There is a file embedded within this post, please visit this post to download the file.

Related Books

  • Microsoft Access 2010 VBA Programming Inside Out (30-07-2011)
  • Microsoft SQL Server 2012 Administration (14-07-2013)
  • Microsoft Excel 2013: Building Data Models with PowerPivot (03-05-2013)
  • Learning SQL Server Reporting Services 2012 (02-10-2013)
  • Excel VBA Programming For Dummies, 3rd Edition (06-03-2013)
  • Access 2013: The Missing Manual (15-05-2013)
  • SQL Server 2012 T-SQL Recipes, 3rd Edition (19-10-2012)
  • Securing SQL Server, 2nd Edition (07-05-2013)
  • Professional Visual Studio 2012 (18-02-2013)
  • Professional SharePoint 2013 Administration (04-05-2013)
  • Professional Microsoft SQL Server Analysis Services 2008 with MDX (19-01-2012)
  • Professional Microsoft SQL Server 2012 Reporting Services (13-06-2012)
  • Professional Microsoft SQL Server 2012 Analysis Services with MDX and DAX (29-11-2012)
  • Professional Microsoft SQL Server 2008 Reporting Services (19-01-2012)
  • Professional Excel Development, 2nd Edition (20-08-2011)
  • Pro T-SQL 2012 Programmer’s Guide, 3rd Edition (25-04-2013)
  • Pro SQL Server 2012 Reporting Services, 3rd Edition (12-09-2012)
  • Pro SQL Database for Windows Azure, 2nd Edition (08-02-2013)
  • PowerShell Deep Dives (17-10-2013)
  • Microsoft Visual Studio LightSwitch Unleashed (02-08-2012)

The post Access 2013 All-in-One For Dummies appeared first on Wow! eBook.

Wow! eBook

This entry was posted in Wowebook and tagged , , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *