Access 2013 All-in-One For Dummies E-Book

Alison Barrows

• Herausgeber: John Wiley & Sons
• Kategorie: Wissenschaft und neue Technologien
• Sprache: Englisch

Seitenzahl: 1092

Veröffentlichungsjahr: 2013

Beschreibung

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!

Leseprobe

Access® 2013 All-in-One For Dummies®

Published byJohn Wiley & Sons, Inc. 111 River Street Hoboken, NJ 07030-5774

www.wiley.com

Copyright © 2013 by John Wiley & Sons, Inc., Hoboken, New Jersey

Published by John Wiley & Sons, Inc., Hoboken, New Jersey

Published simultaneously in Canada

No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, 222 Rosewood Drive, Danvers, MA 01923, [phone], fax [phone]. Requests to the Publisher for permission should be addressed to the Permissions Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030, [phone], fax [phone], or online at http://www.wiley.com/go/permissions.

Trademarks: Wiley, the Wiley logo, For Dummies, the Dummies Man logo, A Reference for the Rest of Us!, The Dummies Way, Dummies Daily, The Fun and Easy Way, Dummies.com, Making Everything Easier, and related trade dress are trademarks or registered trademarks of John Wiley & Sons, Inc. and/or its affiliates in the United States and other countries, and may not be used without written permission. Access is a registered trademark of Microsoft Corporation in the United States and/or other countries. All other trademarks are the property of their respective owners. John Wiley & Sons, Inc. is not associated with any product or vendor mentioned in this book.

Limit of Liability/Disclaimer of Warranty: The publisher and the author make no representations or warranties with respect to the accuracy or completeness of the contents of this work and specifically disclaim all warranties, including without limitation warranties of fitness for a particular purpose. No warranty may be created or extended by sales or promotional materials. The advice and strategies contained herein may not be suitable for every situation. This work is sold with the understanding that the publisher is not engaged in rendering legal, accounting, or other professional services. If professional assistance is required, the services of a competent professional person should be sought. Neither the publisher nor the author shall be liable for damages arising herefrom. The fact that an organization or Website is referred to in this work as a citation and/or a potential source of further information does not mean that the author or the publisher endorses the information the organization or Website may provide or recommendations it may make. Further, readers should be aware that Internet Websites listed in this work may have changed or disappeared between when this work was written and when it is read.

For general information on our other products and services, please contact our Customer Care Department within the U.S. at 877-762-2974, outside the U.S. at 317-572-3993, or fax [phone].

For technical support, please visit www.wiley.com/techsupport.

Wiley publishes in a variety of print and electronic formats and by print-on-demand. Some material included with standard print versions of this book may not be included in e-books or in print-on-demand. If this book refers to media such as a CD or DVD that is not included in the version you purchased, you may download this material at http://booksupport.wiley.com. For more information about Wiley products, visit www.wiley.com.

Library of Congress Control Number: 2013932122

ISBN 978-1-118-51055-1 (pbk); ISBN 978-1-118-63737-1 (ebk); ISBN 978-1-118-52792-4 (ebk); ISBN 978-1-118-63747-0 (ebk)

Manufactured in the United States of America

10 9 8 7 6 5 4 3 2 1

About the Authors

Alison Barrows has authored or co-authored books on Windows, the Internet, Microsoft Access, WordPerfect, Lotus 1-2-3, and other topics. In addition to writing books, Alison writes and edits technical documentation and training material. In real life she hangs out with her “guys” — Parker, 6, and Mason, 4, and Evan, 2 — and tries to carve out some time to practice yoga. Alison lives with her family in central Massachusetts.

Joe Stockman has been using Microsoft Access since its initial release and has authored or co-authored several books on Access. He’s also developed courseware in Access and VBA and has been on the speaker circuit for Microsoft Access seminars. Joe works as a consultant and software designer for Facilities Survey, Inc. in Pittsburgh, Pennsylvania. He also enjoys music, cooking, and anything else that lets him express his creative side.

Allen G. Taylor is a 30-year veteran of the computer industry and the author of over 20 books, including SQL For Dummies, SQL All-in-One For Dummies, and Database Development For Dummies. He lectures nationally on databases, innovation, and entrepreneurship. He also teaches database development through a leading online education provider. Allen is president of Goldfinger Global, LLC and can be reached at [email protected].

Dedication

To Matt, Parker, Mason, and Evan. —Alison Barrows

To Mom, as always. —Joseph C. Stockman

To Marguerite Shelton, who gave me my life’s greatest gift. —Allen G. Taylor

Authors’ Acknowledgments

We would like to acknowledge the care of Kyle Looper, Blair Pottenger, Kathy Simpson, and all the others who shepherded this book through the editing and production process, as well as all the folks listed on the Publisher’s Acknowledgments page who worked on this book. (It takes ALL of these people, not just those of us on the cover.) We’d also like to thank the folks at Microsoft for making Access a wonderful tool to create robust database applications.

Alison thanks Dotty, Christy, and Matt for taking great care of my guys so I can get work done. Matt (also known as Honey) gets special thanks as my hardware guru.

Joe thanks his mom and dad, for always encouraging but never pushing. Also thanks to Robin for her support and understanding of the time it took to finish this project.

Allen thanks all the folks at Wiley who made this book possible, but especially Kathy Simpson and Blair Pottenger, project editors, and Kyle Looper, acquisitions editor.

Publisher’s Acknowledgments

We’re proud of this book; please send us your comments at http://dummies.custhelp.com. For other comments, please contact our Customer Care Department within the U.S. at 877-762-2974, outside the U.S. at 317-572-3993, or fax [phone].

Some of the people who helped bring this book to market include the following:

Acquisitions and Editorial

Project Editors: Kathy Simpson, Blair J. Pottenger

Acquisitions Editor: Kyle Looper

Copy Editor: Kathy Simpson

Technical Editor: Brian Underdahl

Editorial Manager: Kevin Kirschner

Editorial Assistant: Annie Sullivan

Sr. Editorial Assistant: Cherie Case

Cover Photo: © Marcello Bortolino / iStockphoto

Composition Services

Project Coordinator: Katie Crocker

Layout and Graphics: Jennifer Creasey, Joyce Haughey

Proofreader: The Well-Chosen Word

Indexer: BIM Indexing & Proofreading Services

Publishing and Editorial for Technology Dummies

Richard Swadley, Vice President and Executive Group Publisher

Andy Cummings, Vice President and Publisher

Mary Bednarek, Executive Acquisitions Director

Mary C. Corder, Editorial Director

Publishing for Consumer Dummies

Kathleen Nebenhaus, Vice President and Executive Publisher

Composition Services

Debbie Stailey, Director of Composition Services

Access 2013 All-in-One For Dummies®

Visit www.dummies.com/cheatsheet/access2013aio to view this book's cheat sheet.

Table of Contents

Introduction

About Access 2013 All-in-One For Dummies

Foolish Assumptions

How This Book Is Organized

Book I: Getting Started with Access 2013

Book II: Tables for Storing Your Data

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

Book IV: Forms for Editing Data

Book V: Reporting in Words and Pictures

Book VI: Automation with Macros

Book VII: Database Administration

Book VIII: Programming in VBA

Book IX: Going Beyond Access

Appendix: Installing Microsoft Access

What You Don’t Have to Read

Icons Used in This Book

Conventions Used in This Book

Where to Go from Here

Book I: Getting Started with Access 2013

Book I: Chapter 1: Introducing Access 2013

Why Use a Database?

Plan, Plan, Plan

The Six Types of Access Objects

Tables for storing your data

Queries for selecting your data

Forms for editing and displaying your data

Reports for printing your data

Macros for saving keystrokes

Modules for writing your own programs

Essential Database Concepts

Book I: Chapter 2: Getting Started, Getting Around

Running Access

Opening a Database

Opening oldies

Saving in a different version

I have that open already!

Creating a sample database from a template

Making Friends with the Access Window

The Ribbon

The Quick Access toolbar

Introducing Mission Control: The Navigation Pane

Choosing how database objects are grouped

Choosing size and details for Navigation Pane objects

Sorting objects in the Navigation Pane

Searching for an object

Viewing Objects in Your Database

Viewing lots of objects at the same time

Switching views

Creating, Deleting, Renaming, Copying, and Printing Objects

Introducing Backstage View

Using Wizards

Getting Help

Saving Time with Keyboard Shortcuts

Book I: Chapter 3: Designing Your Database the Relational Way

What Are Tables, Fields, and Keys?

Data types

Primary key fields for your tables

What Are Relationships?

How relationships work

One-to-many relationships

One-to-one relationships

Many-to-many relationships

Designing a Database

Identifying your data

Eliminating redundant fields

Organizing fields into tables

Adding tables for codes and abbreviations

Choosing primary keys for each table

Linking your tables

Refining your links

Seeing what’s in a name

Cleaning up the design

Choosing Field Types

Choosing between Text and Yes/No fields

Choosing between Short Text and Long Text fields

Choosing between Text and Number (or Currency) fields

Storing pictures and other files

Storing names, money, codes, and other stuff

Storing Single Facts

Creating a Database

Creating a database from scratch

Creating a new database from a template

Book II: Tables for Storing Your Data

Book II: Chapter 1: Creating and Modifying Tables

Viewing Your Tables

Creating the First Table for Your Data

Creating a new table using Datasheet view

Entering data and creating fields

Choosing field names

Changing a field name

Saving your table

Working with Tables and Fields in Your Database

Finding other ways to create a table

Starting with table templates (aka Application Parts)

Creating Fields

Creating fields by clicking a button

Quick-starting your table with field templates

Working with a Datasheet Full of Data

Looking at a datasheet

Navigating the data

Adding and Editing Records

Using keystrokes to enter data automatically

Editing the data you have

Adding calculated fields to tables

Entering and editing hyperlinks

Using the Attachment data type

Deleting records

Entering special characters

Checking Your Spelling

Using AutoCorrect for Faster Data Entry

Formatting a Datasheet

Formatting a field

Changing the font

Taking advantage of Rich Text

Changing gridlines and background color

Rearranging columns in a datasheet

Changing column width

Changing row height

Inserting and deleting columns

Hiding columns

Freezing columns

Changing default formatting for new tables

Taking Advantage of Subdatasheets

Adding a Total Row to the Datasheet

Book II: Chapter 2: Refining Your Table in Design View

Creating Tables in Design View

Refining Your Table in Design View

Using the Caption property

Adding a field

Copying a field

Moving a field

Deleting a field

Choosing a data type

Formatting Fields with Field Properties

Formatting Number and Currency fields

Setting the field size

Formatting Date/Time fields

Formatting Text fields

Defining the Primary Key

Indexing Fields

Printing Table Designs

Book II: Chapter 3: Sorting, Finding, and Filtering Data in a Datasheet

Sorting the Rows of a Datasheet

Finding (and Replacing) Data

Exploring the Find and Replace dialog box

Replacing the data you find

Filtering a Datasheet

Understanding filtering basics

Using different types of datasheet filters

Filtering with quick filters

Filtering by selection

Filtering multiple fields

Filtering with Advanced Filter/Sort

Book II: Chapter 4: Importing and Exporting Data

Cutting, Copying, and Pasting

Using the Office clipboard

Cutting and pasting small to mediumish amounts of data

Moving data from Excel to Access

Importing or Linking to Data

Making data available

Understanding what applications are compatible with Access

Getting external data

Importing text or spreadsheet data

Importing with the Import Spreadsheet and Link Spreadsheet wizards

Getting contacts from Outlook into Access

Managing links

Cleaning up your imported data

Running and scheduling saved imports

Getting Data from Another Access Database

Getting Data Out of Access

Using Access Data in a Word Mail Merge

Book II: Chapter 5: Avoiding “Garbage In, Garbage Out”

Finding the Right Tool to Keep Garbage Out

Using Input Masks to Validate and Format Data

Using the Input Mask Wizard

Creating an input mask manually

Creating a Lookup Field

Using the Lookup Wizard

Knowing when to allow multiple selections

Modifying the lookup list

Validating Data As It’s Entered

Book II: Chapter 6: Relating Your Tables and Protecting Your Data

Creating Relationships and Protecting Your Data with Referential Integrity

Deciding on the best path to take

Opening the Relationships window

Adding tables to the Relationships window

Setting referential integrity between two tables

Editing and deleting relationships

Creating Referential Integrity with Many-to-Many Relationships

Printing the Relationships Window

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

Book III: 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

Deciphering Design view

Working with tables in Design view

Introducing the query design grid

Navigating Design view

Displaying or hiding table names

Taking Tips on Creating a Query

Adding tables to the query

Inserting fields into a design grid

Editing a Query

Sorting a query

Viewing top values

Hiding fields

Changing the format of a query field

Limiting Records with Criteria Expressions

Querying by example

Using dates, times, text, and values in criteria

Using operators in criteria expressions

Using multiple criteria

Using lookup fields in criteria

Creating queries with multivalue lookup fields

Working with Multiple Related Tables

Joining tables in Design view

Choosing the type of join and setting join properties

Working with Query Datasheets

Using the query datasheet to edit data

Creating AutoLookup queries to fill in data automatically

Saving Queries

Book III: Chapter 2: Letting Queries Do the Math

Doing Calculations in Queries

Writing Expressions in Access

Using operators in expressions

Using field names in expressions

Using functions in expressions

Using Expression Builder

Getting help with functions

Entering text in < and > brackets

Nesting functions

Going beyond Basic Arithmetic

Formatting calculated numbers in queries

Avoiding problems with null values

Performing Date and Time Calculations

Using literal dates and times in expressions

Using the Date/Time functions

Manipulating Text with Expressions

Adding spaces to text expressions

Using the Access Text functions

Writing Decision-Making Expressions

Making comparisons in IIf()

Combining comparisons

To tax or not to tax?

Testing for Empty Fields

Sorting by Name or Company

Creating Flexible Parameter Queries

Working with Totals, Subtotals, Averages, and Such

Calculating subtotals in a query

Filtering records based on calculated fields

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

Creating Action Queries

Recognizing the dangers of the Run button

Creating action queries safely

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

Book III: 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

Using criteria

Using multiple fields for row headings

Adding aggregate columns

Getting data in order

Book IV: Forms for Editing Data

Book IV: Chapter 1: Designing Custom Forms (and Reports)

Seeing How Forms and Reports Are Secretly Related

Understanding Form Basics

Making and Using a Form

Making the easiest possible form with the Form button

Viewing a form

Editing data in Form view

Creating Forms with Wizards

Wizard, make me a form!

More super-speedy forms

Modifying Existing Forms and Reports

Getting Your Fields Lined Up in Layout View

Using a control layout to rearrange fields

Adding and deleting fields

Making a new form from scratch in Layout view

Adding and deleting rows and columns in the control layout

Controlling your control layouts

Trying out your new, improved form

Configuring the Whole Form or Report

Naming the form

Seeing where records come from

Deciding the order of the records

Choosing one record or many

Using some other cool form properties

Applying a theme to a form or report

Storing Your Forms and Reports

Managing forms and reports

Importing forms and reports from other databases

Printing forms

Book IV: Chapter 2: Jazzing Up Your Forms (and Reports)

Creating New Forms Efficiently

Making All Kinds of Changes in Design View

Changing the layout of an existing form or report

Changing the size of a form

Taking Control of Your Form or Report

Understanding types of form controls

Making a new control by dragging a field

Making a new control by choosing a control

Setting control properties

Binding a control to data in the record source

Making Controls That Display Text, Numbers, and Dates

Making and editing labels

Adding hyperlink controls

Putting Short Text and Long Text fields in text boxes

Displaying Number, Currency, and Date fields

Breaking Out of the Control Layout

Removing the control layout

Moving or resizing a control

Neatening your controls

Renaming, Resizing, Deleting, and Copying Controls

Formatting Numbers and Dates

Choosing Fonts, Colors, and Other Decorative Touches

Copying your formatting

Making bad news red

Creating Check Boxes for Yes/No Fields

Adding Lines, Boxes, and Backgrounds

Controlling Cursor Movement in Your Form

Book IV: Chapter 3: Creating Smarter Forms

Creating and Configuring Combo and List Boxes

Making combo boxes the really easy way

Running the Combo Box and List Box wizards

Changing the properties of a combo or list box

Designing Cool Looks for Yes/No Fields

Creating Option Groups

Creating Command Buttons

Making a Close button

Making a button to display a related form

Making a button to print the current record

Making other cool buttons

Customizing your command button

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

Creating a navigation form

Finding an alternative to navigation forms

Opening a form automatically when the database opens

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

Doing Elementary Calculations

Making a calculated control

Checking your expression

Troubleshooting expressions

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

Creating a subform

Viewing the properties of subform controls

Adding Subtotals and Totals from Subforms

Using aggregate functions

Referring to a control on a subform

Creating the controls to total a subform

Book V: Reporting in Words and Pictures

Book V: Chapter 1: Creating and Spiffing Up Reports

Knowing Forms Means That You Already Know Reports

Creating Reports Automatically

Making the easiest possible report

Running the Report Wizard

Editing Reports in Layout and Design View

Creating and Managing Report Sections

Setting report and section properties

Adding page headers, footers, and numbers

Grouping your records

Sorting the records in your report

Calculating group subtotals and report totals

Employing Formatting Tips and Tricks

Copying Forms to Reports

Adding and Formatting Subreports

Making a subreport

Printing information from a subreport on the main report

Displaying Empty or Long Fields

Displaying long text

Displaying fields that may be empty

Viewing Your Reports Onscreen

Book V: Chapter 2: Printing Beautiful Reports

Viewing Your Report

Adjusting the view

Looking at lots of pages

Formatting the Page

Selecting a printer

Setting margins, paper size, and paper orientation

Controlling page breaks

Avoiding blank pages

Printing only the data

Printing the Report

Printing on an actual printer

Creating a PDF, XPS, HTML, or other file of your report

Creating Mailing Labels

Running the Label Wizard

Behind the scenes in a mailing-label report

Changing the page setup for labels

Sending a Report to Another Application

Exporting your report to Microsoft Excel

Exporting your report to Microsoft Word

E-mailing your report in Microsoft Outlook

Exporting your report in other formats

Automating your exports

Book V: Chapter 3: Creating Charts and Graphs from Your Data

Pulling Up a Seat at the Data Bar

Displaying Information with Charts

Creating charts with the Chart Wizard

Making bar charts

Making line and area charts

Making pie and doughnut charts

Making bubble and XY scatter plots

Changing Your Charts

Modifying an existing chart

Formatting charts with colors, legends, and titles

Changing how data is graphed

Changing which data is charted

Book VI: Automation with Macros

Book VI: Chapter 1: Making Macros Do the Work

Introducing Macros

Creating and Editing Stand-Alone Macros

Naming, saving, and editing macros

Taking action

Specifying arguments to actions

Moving your actions around

Adding comments

Creating subroutines in macros: Submacros

Running Stand-Alone Macros and Submacros

Running a macro when the database opens

Assigning macros to keys

Opening Databases That Contain Macros

Keeping a macro from turning into a virus

Putting your database in a safe place

Signing your database

Knowing which actions you can take

Telling Access to “Run This Only If I Say So”

If-Then macros

If-Then-Else macros

Book VI: Chapter 2: Making Macros Smarter

Attaching Macros to Tables

Running data macros

Creating a data macro

Trying cool data-macro tricks

Running Macros in Forms

Running a macro when a form event happens

Creating command buttons on forms

Referring to form controls in macros

Printing matching records from a form

Changing the Way Your Form Looks Dynamically

Setting the properties of form controls

Hiding unneeded controls on a form

Setting Up Your Own Main-Menu Form

Creating a form that appears when the database opens

Creating command buttons for your main-menu form

Using Temporary Variables in Macros

Book VII: Database Administration

Book VII: Chapter 1: Database Housekeeping

Compacting and Repairing Your Database

Making Backups

Backing up a whole database

Backing up part of a database

Converting Databases

Analyzing and Documenting Your Database

Viewing relationships in the Relationships window

Viewing object dependencies

Analyzing database performance

Documenting your database

Loading and Managing Add-Ins

Book VII: 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

Why split?

Let’s split!

Handing out front ends

Relinking your tables

Editing with Multiple Users

Fixing exclusive access

Managing record-locking

Programming locks

Book VII: Chapter 3: Securing Your Data

Observing Basic Windows Security

Controlling What Happens When You Open the Database

Password-Protecting and Encrypting Your Database

Encrypting your database with a password

Opening a password-protected database

Decrypting a database

Locking Up Your Database As an .accde File

Creating an .accde file

Making updates later

Using the Trust Center

Book VIII: Programming in VBA

Book VIII: Chapter 1: What the Heck Is VBA?

Getting Acquainted with VBA Code

Opening a class module

Creating or opening a standard module

Enabling VBA Code

Sub procedures

Function procedures

Working with Visual Basic Editor

Using the Code window

Using the Immediate window

Using the Object Browser

Searching the Object Library

Referring to objects and collections

Choosing object libraries

Closing Visual Basic Editor

Discovering Code As You Go

Converting macros to VBA code

Copying and pasting code

Book VIII: Chapter 2: Writing Code

Seeing How VBA Works

Understanding VBA Syntax

Arguing with VBA

Knowing module level from procedure level

Declaring module options

Writing Your Own VBA Procedures

Creating a new standard procedure

Creating a new event procedure

Passing arguments to procedures

Returning a value from a function

Typing and Editing in the Code Window

Taking shortcuts in the Code window

Typing comments

Breaking lines of code

Dealing with compile errors

Testing and Running Your Code

Testing sub procedures

Running sub procedures from Access

Testing function procedures

Using function procedures in Access

Book VIII: Chapter 3: Writing Smarter Code

Creating Variables and Constants

Creating variables

Understanding the scope and lifetime of variables

Defining constants

Organizing variables into arrays

Working with multidimensional arrays

Following naming conventions for variables

Making Decisions in VBA Code

Using If...End If statements

Nesting If...End If statements

Using a Select Case block

Executing the Same Code Repeatedly

Using Do...Loop to create a loop

Using While...Wend to create a loop

Using For...Next to create a loop

Looping through an array

Analyzing each character in a string

Using Custom Functions

Book VIII: Chapter 4: Controlling Forms with VBA

Displaying Custom Messages

Displaying a message box

Responding to what the user clicks

Opening Forms with DoCmd

Finding umpteen ways to open a form

Closing a form with DoCmd

Changing Form Controls with VBA

Some cool control properties

Examples of controlling properties

Understanding Objects and Collections

Working with properties, methods, and events

Referring to objects and collections

Seeing whether a form is open

Looping through collections

Using With...End With

Book VIII: Chapter 5: Using SQL and Recordsets

Recordsets and Object Models

Creating quick and easy recordsets

Understanding ADO recordset properties and methods

Looping through a recordset

Defining a recordset’s cursor type

Using field names in recordsets

SQL and Recordsets

Writing SQL statements

Breaking up long SQL statements

Action Queries in VBA

Creating an action query

Turning off warnings

Connection Cleanup

Book VIII: Chapter 6: Debugging Your Code

Recognizing Types of Program Errors

Fixing Compiler Errors

Trapping Runtime Errors

Creating an error handler

Fixing runtime errors

Preventing runtime errors

Dealing with Logical Errors

Watching things happen

Slowing procedures

Cleaning up

Book IX: Going Beyond Access

Book IX: Chapter 1: Automation with Other Office Programs

Understanding Automation

Working with Object Libraries

Exploring object libraries

Using the Application object

Adding Contacts to Outlook

Adding the contact button and code

Examining the contact-form code

Merging Data with a Word Document

Creating a Word template

Viewing and inserting bookmarks

Adding the merge button

Entering the merge code

Examining the merge code

Exporting Data to Excel

Adding the export button and code

Examining the export code

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

What Is SQL Server?

Using ODBC

Connecting to SQL Server with ODBC

Using linked tables in Access

Maintaining linked tables

Using pass-through queries

Finding Alternatives to Access Data Projects

Book IX: Chapter 3: Using Access with SharePoint

What Is SharePoint?

Using a SharePoint List As a Data Source

Creating a new SharePoint list

Linking to an existing SharePoint list

Moving an existing database to SharePoint

Building a Custom Web App

Defining a Custom Web App

Meeting the requirements for a Custom Web App

Creating a Custom Web App

Designing Custom Web Apps

Adding tables

Launching your app

Entering data in your app

Navigating your app

Editing views

Adding actions

Adding queries

Book IX: Appendix: Installing Microsoft Access

Cheat Sheet

Introduction

Whoa! What happened to menu bars, toolbars, and all that other stuff we used to have? Well, in case you haven’t noticed yet, they’re all gone. If you’ve never used Access in your life, you’re starting fresh, of course, so never mind. Even if you’ve never used any version of Microsoft Access before or aren’t even sure what a version is, however, you’ve come to the right book.