Access 2013 All-in-One For Dummies

Купить бумажную книгу и читать

Название: Access 2013 All-in-One For Dummies

Автор: Barrows A., Stockman and J.C., Taylor A.G.

Издательство: Wiley

Год: 2013

Страниц: 795

ISBN: 978-1-118-51055-1

Формат: PDF

Размер: 27.6 Mб

Язык: английский

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!

Contents

Introduction

Book I: Getting Started with Access 2013

Introducing Access 2013

Getting Started, Getting Around

Designing Your Database the Relational Way

Book II: Tables for Storing Your Data

Creating and Modifying Tables

Refi ning Your Table in Design View

Sorting, Finding, and Filtering Data in a Datasheet

Importing and Exporting Data

Avoiding Garbage In, Garbage Out

Relating Your Tables and Protecting Your Data

Book III: Queries (Or Getting Information from Your Data)

Creating Select Queries

Letting Queries Do the Math

Doing Neat Things with Action Queries and Query Wizards

Viewing Your Data from All Angles Using Crosstabs

Book IV: Forms for Editing Data

Designing Custom Forms (and Reports)

Jazzing Up Your Forms (and Reports)

Creating Smarter Forms

Doing Calculations in Forms and Subforms (and Reports)

Book V: Reporting in Words and Pictures

Creating and Spiffing Up Reports

Printing Beautiful Reports

Creating Charts and Graphs from Your Data

Book VI: Automation with Macros

Making Macros Do the Work

Making Macros Smarter

Book VII: Database Administration

Database Housekeeping

Sharing the Fun: Managing Multiuser Access

Securing Your Data

Book VIII: Programming in VBA

What the Heck Is VBA?

Writing Code

Writing Smarter Code

Controlling Forms with VBA

Using SQL and Recordsets

Debugging Your Code

Book IX: Going Beyond Access

Automation with Other Office Programs

Using Access As a Front End to SQL Server

Using Access with SharePoint

Appendix: Installing Microsoft Access

Index