Access® 2013 All-in-One For Dummies® -- Contents at a Glance -- Table of Contents -- Book I: Getting Started with Access 2013 -- Chapter 1: Introducing Access 2013 -- Why Use a Database? -- Plan, Plan, Plan -- The Six Types of Access Objects -- Essential Database Concepts -- Chapter 2: Getting Started, Getting Around -- Running Access -- Opening a Database -- Making Friends with the Access Window -- Introducing Mission Control: The Navigation Pane -- Viewing Objects in Your Database -- Creating, Deleting, Renaming, Copying, and Printing Objects -- Introducing Backstage View -- Using Wizards -- Getting Help -- Saving Time with Keyboard Shortcuts -- Chapter 3: Designing Your Database the Relational Way -- What Are Tables, Fields, and Keys? -- What Are Relationships? -- Designing a Database -- Choosing Field Types -- Storing Single Facts -- Creating a Database -- Book II: Tables for Storing Your Data -- Chapter 1: Creating and Modifying Tables -- Viewing Your Tables -- Creating the First Table for Your Data -- Working with Tables and Fields in Your Database -- Creating Fields -- Working with a Datasheet Full of Data -- Adding and Editing Records -- Checking Your Spelling -- Using AutoCorrect for Faster Data Entry -- Formatting a Datasheet -- Taking Advantage of Subdatasheets -- Adding a Total Row to the Datasheet -- Chapter 2: Refining Your Table in Design View -- Creating Tables in Design View -- Refining Your Table in Design View -- Formatting Fields with Field Properties -- Defining the Primary Key -- Indexing Fields -- Printing Table Designs -- Chapter 3: Sorting, Finding, and Filtering Data in a Datasheet -- Sorting the Rows of a Datasheet -- Finding (and Replacing) Data -- Filtering a Datasheet -- Chapter 4: Importing and Exporting Data -- Cutting, Copying, and Pasting -- Importing or Linking to Data.

Getting Data from Another Access Database -- Getting Data Out of Access -- Using Access Data in a Word Mail Merge -- Chapter 5: Avoiding "Garbage In, Garbage Out" -- Finding the Right Tool to Keep Garbage Out -- Using Input Masks to Validate and Format Data -- Creating a Lookup Field -- Validating Data As It's Entered -- Chapter 6: Relating Your Tables and Protecting Your Data -- Creating Relationships and Protecting Your Data with Referential Integrity -- Creating Referential Integrity with Many-to-Many Relationships -- Printing the Relationships Window -- Book III: Queries (Or Getting Information from Your Data) -- Chapter 1: Creating Select Queries -- Understanding Types of Queries -- Creating a Query in Design View -- Creating a Query with the Simple Query Wizard -- Viewing Your Query -- Using Query Design View -- Taking Tips on Creating a Query -- Editing a Query -- Limiting Records with Criteria Expressions -- Working with Multiple Related Tables -- Working with Query Datasheets -- Saving Queries -- Chapter 2: Letting Queries Do the Math -- Doing Calculations in Queries -- Writing Expressions in Access -- Using Expression Builder -- Going beyond Basic Arithmetic -- Performing Date and Time Calculations -- Manipulating Text with Expressions -- Writing Decision-Making Expressions -- Testing for Empty Fields -- Sorting by Name or Company -- Creating Flexible Parameter Queries -- Working with Totals, Subtotals, Averages, and Such -- Chapter 3: Doing Neat Things with Action Queries and Query Wizards -- Creating Action Queries -- Changing Data with Update Queries -- Creating New Tables with Make-Table Queries -- Moving Data from One Table to Another with Append Queries -- Deleting Lots of Records with Delete Queries -- Finding Unmatched Records with a Wizard -- Finding Duplicate Records -- Chapter 4: Viewing Your Data from All Angles Using Crosstabs.

Aggregating Data in a Crosstab Query -- Using the Crosstab Query Wizard -- Creating a Crosstab Query in Design View -- Modifying a Crosstab Query -- Book IV: Forms for Editing Data -- Chapter 1: Designing Custom Forms (and Reports) -- Seeing How Forms and Reports Are Secretly Related -- Understanding Form Basics -- Making and Using a Form -- Creating Forms with Wizards -- Modifying Existing Forms and Reports -- Getting Your Fields Lined Up in Layout View -- Configuring the Whole Form or Report -- Storing Your Forms and Reports -- Chapter 2: Jazzing Up Your Forms (and Reports) -- Creating New Forms Efficiently -- Making All Kinds of Changes in Design View -- Taking Control of Your Form or Report -- Making Controls That Display Text, Numbers, and Dates -- Breaking Out of the Control Layout -- Renaming, Resizing, Deleting, and Copying Controls -- Formatting Numbers and Dates -- Choosing Fonts, Colors, and Other Decorative Touches -- Creating Check Boxes for Yes/No Fields -- Adding Lines, Boxes, and Backgrounds -- Controlling Cursor Movement in Your Form -- Chapter 3: Creating Smarter Forms -- Creating and Configuring Combo and List Boxes -- Designing Cool Looks for Yes/No Fields -- Creating Option Groups -- Creating Command Buttons -- Making a Find Box -- Displaying Attachments -- Adding Form Headers and Footers -- Creating Tabbed Forms -- You Can't Type That Here! -- Making a Main Menu for Your Database -- Chapter 4: Doing Calculations in Forms and Subforms (and Reports) -- Doing Elementary Calculations -- Calculating and Formatting Numbers -- Calculating and Formatting Dates -- Calculating and Formatting Text -- Displaying Values That Depend on Conditions -- Formatting Calculated Controls -- Using a Split Form to Display a Datasheet -- Using a Subform to Display Detail Records -- Adding Subtotals and Totals from Subforms.

Book V: Reporting in Words and Pictures -- Chapter 1: Creating and Spiffing Up Reports -- Knowing Forms Means That You Already Know Reports -- Creating Reports Automatically -- Editing Reports in Layout and Design View -- Creating and Managing Report Sections -- Employing Formatting Tips and Tricks -- Copying Forms to Reports -- Adding and Formatting Subreports -- Displaying Empty or Long Fields -- Viewing Your Reports Onscreen -- Chapter 2: Printing Beautiful Reports -- Viewing Your Report -- Formatting the Page -- Printing the Report -- Creating Mailing Labels -- Sending a Report to Another Application -- Chapter 3: Creating Charts and Graphs from Your Data -- Pulling Up a Seat at the Data Bar -- Displaying Information with Charts -- Changing Your Charts -- Book VI: Automation with Macros -- Chapter 1: Making Macros Do the Work -- Introducing Macros -- Creating and Editing Stand-Alone Macros -- Running Stand-Alone Macros and Submacros -- Opening Databases That Contain Macros -- Telling Access to "Run This Only If I Say So" -- Chapter 2: Making Macros Smarter -- Attaching Macros to Tables -- Running Macros in Forms -- Changing the Way Your Form Looks Dynamically -- Setting Up Your Own Main-Menu Form -- Using Temporary Variables in Macros -- Book VII: Database Administration -- Chapter 1: Database Housekeeping -- Compacting and Repairing Your Database -- Making Backups -- Converting Databases -- Analyzing and Documenting Your Database -- Loading and Managing Add-Ins -- Chapter 2: Sharing the Fun: Managing Multiuser Access -- Putting Your Database Where People Can See It -- Splitting Your Database into a Front End and a Back End -- Editing with Multiple Users -- Chapter 3: Securing Your Data -- Observing Basic Windows Security -- Controlling What Happens When You Open the Database -- Password-Protecting and Encrypting Your Database.

Locking Up Your Database As an .accde File -- Using the Trust Center -- Book VIII: Programming in VBA -- Chapter 1: What the Heck Is VBA? -- Getting Acquainted with VBA Code -- Enabling VBA Code -- Working with Visual Basic Editor -- Discovering Code As You Go -- Chapter 2: Writing Code -- Seeing How VBA Works -- Understanding VBA Syntax -- Writing Your Own VBA Procedures -- Typing and Editing in the Code Window -- Testing and Running Your Code -- Chapter 3: Writing Smarter Code -- Creating Variables and Constants -- Making Decisions in VBA Code -- Executing the Same Code Repeatedly -- Using Custom Functions -- Chapter 4: Controlling Forms with VBA -- Displaying Custom Messages -- Opening Forms with DoCmd -- Changing Form Controls with VBA -- Understanding Objects and Collections -- Chapter 5: Using SQL and Recordsets -- Recordsets and Object Models -- SQL and Recordsets -- Action Queries in VBA -- Connection Cleanup -- Chapter 6: Debugging Your Code -- Recognizing Types of Program Errors -- Fixing Compiler Errors -- Trapping Runtime Errors -- Dealing with Logical Errors -- Book IX: Going Beyond Access -- Chapter 1: Automation with Other Office Programs -- Understanding Automation -- Working with Object Libraries -- Adding Contacts to Outlook -- Merging Data with a Word Document -- Exporting Data to Excel -- Chapter 2: Using Access As a Front End to SQL Server -- What Is SQL Server? -- Using ODBC -- Finding Alternatives to Access Data Projects -- Chapter 3: Using Access with SharePoint -- What Is SharePoint? -- Using a SharePoint List As a Data Source -- Building a Custom Web App -- Designing Custom Web Apps -- Appendix: Installing Microsoft Access -- Installing Access from a Disc -- Installing Access from Office 365 -- Activating Access -- Repairing, Reinstalling, or Uninstalling Access -- Index.