Access 2013 All–in–One For Dummies

9 books in 1

Essential Concepts Tables Queries Forms Reports Macros Database Administration Programming in VBA Going Beyond Access

Gain access to Access and discover a great way to store, organize, and share information

Database power to the people and the small businesses! Access 2013 provides that power, so you can manage large amounts of information just like the big guys do but without their staff and budget. These 9 minibooks take you from navigating Access and understanding database concepts all the way to programming with VBA. No matter where you want to take your databases, For Dummies can help!

Database ABCs get a basic education in Access and database functions and learn to plan your database Set the tables learn how to set up tables to store your information correctly Learn from your data see how to formulate queries that get exactly the information you need from your data Form a report create custom forms to work with data on–screen, use the Form Wizard, and turn forms into reports for printing Macro magic tell Access how to automate common tasks and save you time Database housekeeping tidy up and back up your database, safely share it, and keep it secure Get nerdy explore VBA and learn to customize your database by creating your own procedures, recordsets, and more Access interaction see how to use Access with SQL Server and SharePoint

Open the book and find:

How to choose the right data types for your fields What relational database design is all about Tips on creating tables Rules to help you maintain data integrity Different types of queries and what they do Help printing form letters and mailing labels Suggestions for setting up macros Advantages of compacting your database

Introduction  1

Book I: Getting Started with Access 2013  7

Chapter 1: Introducing Access 2013 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: Refi ning Your Table in Design View 105

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 157

Chapter 6: Relating Your Tables and Protecting Your Data 175

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

Chapter 1: Creating Select Queries 189

Chapter 2: Letting Queries Do the Math 221

Chapter 3: Doing Neat Things with Action Queries and Query Wizards 255

Chapter 4: Viewing Your Data from All Angles Using Crosstabs 277

Book IV: Forms for Editing Data  287

Chapter 1: Designing Custom Forms (and Reports) 289

Chapter 2: Jazzing Up Your Forms (and Reports) 313

Chapter 3: Creating Smarter Forms 339

Chapter 4: Doing Calculations in Forms and Subforms (and Reports) 365

Book V: Reporting in Words and Pictures  385

Chapter 1: Creating and Spiffing Up Reports 387

Chapter 2: Printing Beautiful Reports 415

Chapter 3: Creating Charts and Graphs from Your Data 435

Book VI: Automation with Macros  457

Chapter 1: Making Macros Do the Work 459

Chapter 2: Making Macros Smarter 477

Book VII: Database Administration  497

Chapter 1: Database Housekeeping 499

Chapter 2: Sharing the Fun: Managing Multiuser Access 511

Chapter 3: Securing Your Data 523

Book VIII: Programming in VBA  535

Chapter 1: What the Heck Is VBA? 537

Chapter 2: Writing Code 557

Chapter 3: Writing Smarter Code 581

Chapter 4: Controlling Forms with VBA 605

Chapter 5: Using SQL and Recordsets 629

Chapter 6: Debugging Your Code 641

Book IX: Going Beyond Access  651

Chapter 1: Automation with Other Office Programs 653

Chapter 2: Using Access As a Front End to SQL Server 671

Chapter 3: Using Access with SharePoint 685

Appendix: Installing Microsoft Access  709

Index  717

Alison Barrows is the author or coauthor of several books about Access, Windows, and the Internet. Joseph Stockman is an 18–year software designer who has authored or coauthored five Access programming books. Allen Taylor is a 30–year veteran of the computer industry and the author of over 20 books.