Access 2013 All-in-One for Dummies
- 11h 58m
- Alison Barrows, Allen G. Taylor, Joseph C. Stockman
- John Wiley & Sons (US)
- 2013
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!
In this Book
-
Introduction
-
Introducing Access 2013
-
Getting Started, Getting around
-
Designing Your Database the Relational Way
-
Creating and Modifying Tables
-
Refining 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
-
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
-
Designing Custom Forms (and Reports)
-
Jazzing up Your Forms (and Reports)
-
Creating Smarter Forms
-
Doing Calculations in Forms and Subforms (and Reports)
-
Creating and Spiffing up Reports
-
Printing Beautiful Reports
-
Creating Charts and Graphs from Your Data
-
Making Macros Do the Work
-
Making Macros Smarter
-
Database Housekeeping
-
Sharing the Fun—Managing Multiuser Access
-
Securing Your Data
-
What the Heck is VBA?
-
Writing Code
-
Writing Smarter Code
-
Controlling Forms with VBA
-
Using SQL and Recordsets
-
Debugging Your Code
-
Automation with other Office Programs
-
Using Access as a Front End to SQL Server
-
Using Access with SharePoint
