Microsoft Office Access 2007 All-in-One Desk Reference For Dummies

by Simpson, Alan; Young, Margaret Levine; Barrows, Alison; Wells, April; McCarter, Jim

• ISBN13: 9780470036495
• ISBN10: 0470036494
• Format: Paperback
• Copyright: 2006-12-26
• Publisher: For Dummies

Summary

Updated to cover all the latest features and capabilities of Access 2007, this resource provides new and inexperienced Access users with nine task-oriented minibooks that cover beginning to advanced-level material Each minibook covers a specific aspect of Access, such as database design, tables, queries, forms, reports, and macros Shows how to accomplish specific tasks such as database housekeeping, security data, and using Access with the Web Access is the world's leading desktop database solution and is used by millions of people to store, organize, view, analyze, and share data, as well as to build powerful, custom database solutions that integrate with the Web and enterprise data sources

Author Biography

Alan Simpson is the author of over 115 computer books on all sorts of topics: Windows, databases, Web-site design and development, programming, and network administration. His books are published throughout the world, in over a dozen languages, and have sold millions of copies. Though definitely in the techno-geek category, we let him contribute anyway because sometimes people like that come in handy.

Margaret Levine Young has co-authored several dozen computer books about the Internet, UNIX, WordPerfect, Access, and (stab from the past) PC-File and Javelin, including The Internet For Dummies (Wiley) and Windows XP Home Edition: The Complete Reference (Osborne/McGraw-Hill). She met her future husband Jordan in the R.E.S.I.S.T.O.R.S., a high-school computer club before there were high-school computer clubs. Her other passions are her children, music, Unitarian Universalism (www.uua.org), reading, and anything to do with cooking or eating.

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.

April Wells is a graduate of the University of Pittsburgh and holds an MBA from West Texas A&M. She is a database administrator with expertise in a wide variety of enterprise database software programs, including Oracle, DB2, MySQL, and Access. She is the author of several books and white papers on database software and is a frequent public speaker, trainer, and consultant.

Table of Contents

Introduction	1	(1)
About Access 2007 All-in-One Desk Reference For Dummies	1	(1)
Conventions	2	(1)
Foolish Assumptions	3	(1)
What You Don't Have to Read	4	(1)
Icons	4	(1)
Organization	5	(1)
Where to Go from Here	6	(1)
Book I: Essential Concepts	7	(74)
Introducing Access 2007	9	(8)
The Six Types of Access Objects	10	(4)
Tables for storing your data	10	(1)
Queries for selecting your data	11	(1)
Forms for editing and displaying your data	12	(1)
Reports for printing your data	13	(1)
Macros for saving keystrokes	13	(1)
Modules for writing your own programs	14	(1)
Essential Database Concepts	14	(3)
Getting Started, Getting Around	17	(22)
Running Access	17	(1)
Opening a Database	18	(4)
Opening oldies	20	(1)
I have that open already!	21	(1)
Getting around	22	(1)
Playing with the Access Sample Databases	22	(1)
Taking Northwind for a spin	22	(1)
The Access Navigation Bar, Ribbon, and File menu	23	(5)
The Ribbon	23	(1)
Minimizing the Ribbon	24	(1)
Changing object views	25	(1)
Quick Access toolbar	25	(2)
The Office File menu	27	(1)
Mission Control: The Navigation Pane	28	(6)
Grouping database objects	29	(1)
Filtering the Navigation Pane	30	(1)
Sorting objects in the Navigation Pane	30	(1)
Choosing size and details for Navigation Pane objects	31	(1)
Navigation Pane options	31	(1)
Creating custom groups	32	(1)
Hiding objects	33	(1)
Creating, Deleting, Renaming, Copying, and Printing Objects	34	(1)
Using Wizards	35	(1)
Getting Help	36	(1)
Saving Time with Keyboard Shortcuts	37	(2)
Creating a Database from Templates	39	(16)
Finding Templates	40	(2)
Exploring a Template	42	(4)
Viewing an object's design	43	(1)
Viewing table relationships	44	(2)
Modifying Objects	46	(7)
Modifying tables	46	(1)
Modifying queries	47	(1)
Changing forms	48	(3)
Modifying reports	51	(1)
Exploring buttons	51	(2)
Using a Template Database	53	(2)
Designing Your Database the Relational Way	55	(26)
What Are Tables, Fields, and Keys?	55	(3)
Data types	56	(1)
Primary key fields for your tables	57	(1)
What Are Relationships?	58	(5)
How relationships work	59	(1)
One-to-many relationships	59	(1)
One-to-one relationships	60	(1)
Many-to-many relationships	61	(2)
Designing a Database	63	(9)
Identifying your data	63	(1)
Eliminating redundant fields	63	(1)
Organizing fields into tables	64	(3)
Add tables for codes and abbreviations	67	(1)
Choosing keys for each table	67	(2)
Linking your tables	69	(1)
Refining your links	70	(1)
Cleaning up the design	71	(1)
Tips for Choosing Field Types	72	(3)
Choosing between Text and Yes/No fields	72	(1)
Choosing between Text and Memo fields	72	(1)
Choosing between Text and Number (or Currency) fields	73	(1)
Storing names, money, codes, and other stuff	74	(1)
Storing Single Facts	75	(1)
Creating a Database	76	(5)
Book II: Tables	81	(120)
Creating and Modifying Tables	83	(28)
About Table Views	83	(2)
Datasheet view	84	(1)
Design view	85	(1)
Saving Your Table	85	(1)
Creating Tables for Your Data	86	(8)
Creating a new table using a table template	87	(1)
Creating a new table using Datasheet view	88	(2)
Defining fields	90	(3)
Creating tables using Design view	93	(1)
Refining Your Table Using Design View	94	(7)
Choosing field names	96	(1)
Using the Caption property	96	(1)
Changing a field name	96	(1)
Copying a field	97	(1)
Moving a field	97	(1)
Adding a field	98	(1)
Deleting a field	98	(1)
Choosing a data type	98	(3)
Formatting Fields with Field Properties	101	(5)
Formatting Number and Currency fields	102	(1)
Setting the field size	103	(2)
Formatting Date/Time fields	105	(1)
Formatting Text fields	105	(1)
Defining the Primary Key	106	(1)
Indexing Fields	107	(1)
Printing Table Designs	108	(3)
Entering and Editing Data in Datasheets	111	(26)
Looking at a Datasheet	112	(1)
Navigating the Data	113	(1)
Adding and Editing Records	114	(3)
Keystrokes that enter data	115	(1)
Editing the data you have	115	(2)
Entering and Editing Hyperlinks	117	(3)
Entering hyperlinks	117	(2)
Editing hyperlinks	119	(1)
Using the Attachment Data Type	120	(3)
Deleting records	121	(1)
Entering special characters	122	(1)
Checking Your Spelling	123	(1)
Using AutoCorrect for Faster Data Entry	124	(3)
Formatting a Datasheet	127	(5)
Formatting a field	127	(1)
Changing the font	127	(1)
Taking advantage of rich text	128	(1)
Changing gridlines and background color	129	(1)
Rearranging columns in a datasheet	130	(1)
Changing column width	130	(1)
Changing row height	130	(1)
Inserting and deleting columns	131	(1)
Hiding columns	131	(1)
Freezing columns	132	(1)
Changing default formatting for new tables	132	(1)
Taking Advantage of Subdatasheets	132	(2)
Adding a Totals Row to the Datasheet	134	(3)
Sorting, Finding, and Filtering Data	137	(14)
Sorting the Rows of a Datasheet	137	(2)
Finding (and Replacing) Data	139	(2)
The Find and Replace dialog box and its options	140	(1)
Replacing the data you find	141	(1)
Filtering a Datasheet	141	(7)
Filtering basics	142	(2)
Filtering by selection	144	(1)
Common filters	145	(1)
Filtering using criteria on multiple fields	145	(3)
Filtering Using Advanced Filter/Sort	148	(3)
Importing and Exporting Data	151	(24)
Cutting, Copying, and Pasting	151	(4)
The Office Clipboard	152	(1)
Cutting and pasting small to medium-ish amounts of data	153	(2)
Moving data from Excel to Access	155	(1)
Importing or Linking to Data	155	(12)
What applications are compatible with Access?	156	(1)
To link or to import, that is the question	156	(1)
Getting external data	157	(3)
Importing text or spreadsheet data	160	(3)
The Import Spreadsheet and Link Spreadsheet Wizards	163	(1)
Getting contacts from Outlook into Access	164	(1)
Managing links	165	(1)
Cleaning up your imported data	166	(1)
Running and scheduling saved imports	166	(1)
Getting Data from Another Access Database	167	(1)
Getting Data Out of Access	168	(1)
Collecting Data with Outlook	169	(6)
Avoiding ``Garbage In, Garbage Out''	175	(16)
Finding the Right Tool to Keep Garbage Out	175	(2)
Using Input Masks to Validate and Format Data	177	(4)
Using the Input Mask Wizard	178	(1)
Creating an Input mask manually	179	(2)
Creating a Lookup Field	181	(5)
Using the Lookup Wizard	181	(4)
When to use the Allow Multiple Selections option	185	(1)
Modifying the lookup list	186	(1)
Validating Data As It's Entered	186	(5)
Relating Your Tables and Protecting Your Data	191	(10)
Creating Relationships and Protecting Your Data with Referential Integrity	193	(5)
Deciding on the best path to take	194	(1)
Opening the Relationships window	195	(1)
Adding tables to the Relationships window	195	(1)
Setting referential integrity between two tables	196	(1)
Editing and deleting relationships	197	(1)
Referential Integrity with Many-to-Many Relationships	198	(2)
Printing the Relationships Window	200	(1)
Book III: Queries	201	(112)
Creating Select Queries	203	(30)
Types of Queries	204	(1)
Creating a Query in Design View	205	(3)
Creating a Query with the Simple Query Wizard	208	(3)
Viewing Your Query	211	(1)
Understanding Design View	212	(3)
Design view	212	(2)
Working with tables in Design view	214	(1)
Introducing the query design grid	214	(1)
Navigating Design view	215	(1)
Displaying or hiding table names	215	(1)
Tips for Creating a Query	215	(2)
Adding tables to the query	215	(1)
Inserting fields in a design grid	216	(1)
Editing a Query	217	(3)
Sorting a query	218	(1)
Viewing top values	218	(1)
Hiding fields	219	(1)
Changing the format of a query field	219	(1)
Limiting Records with Criteria Expressions	220	(6)
Querying by example	220	(1)
Using dates, times, text, and values in criteria	221	(1)
Using operators in criteria expressions	222	(1)
Using multiple criteria	223	(1)
Using lookup fields in criteria	224	(1)
Queries with multivalue lookup fields	225	(1)
Working with Multiple Related Tables	226	(3)
Joining tables in Design view	227	(1)
Choosing the type of join and setting join properties	228	(1)
Working with Query Datasheets	229	(2)
Using the query datasheet to edit data	230	(1)
AutoLookup queries to fill in data automagically	230	(1)
Saving Queries	231	(2)
Letting Queries Do the Math	233	(36)
Doing Math in Queries	233	(3)
Writing Expressions in Access	236	(4)
Using operators in expressions	236	(2)
Field names in expressions	238	(1)
Using functions in expressions	239	(1)
Using the Expression Builder	240	(4)
Getting help with functions	242	(2)
About text in < and > brackets	244	(1)
Nesting functions	244	(1)
Going Beyond Basic Arithmetic	244	(6)
Formatting calculated numbers in queries	246	(2)
Avoiding problems with null values	248	(2)
Date and Time Calculations	250	(4)
Using literal dates and times in expressions	251	(1)
Using the Date/Time functions	252	(2)
Manipulating Text with Expressions	254	(2)
Adding spaces to text expressions	254	(1)
Using the Access Text functions	255	(1)
Writing Decision-Making Expressions	256	(4)
Making comparisons in iif0	257	(1)
Combining comparisons	257	(1)
To tax or not to tax?	258	(2)
Testing for Empty Fields	260	(2)
Sort by name or company	260	(2)
Creating Flexible Parameter Queries	262	(2)
Totals, Subtotals, Averages, and Such	264	(5)
Calculating subtotals in a query	266	(1)
Filtering records based on calculated fields	267	(2)
Doing Neat Things with Action Queries and Query Wizards	269	(22)
Creating Action Queries	269	(4)
The dangers of the Run button	270	(1)
Creating action queries safely	271	(2)
Changing Data with Update Queries	273	(4)
Creating New Tables with Make-Table Queries	277	(3)
Moving Data from One Table to Another with Append Queries	280	(2)
Deleting Lots of Records with Delete Queries	282	(3)
Finding Unmatched Records with a Wizard	285	(3)
Finding Duplicate Records	288	(3)
Viewing Your Data from All Angles Using Crosstabs and PivotTables	291	(22)
Aggregating Data in a Crosstab Query	292	(9)
Using the Crosstab Query Wizard	292	(5)
Creating a Crosstab query in Design view	297	(2)
Modifying your Crosstab query	299	(2)
Analyzing Data with PivotTables	301	(12)
Creating a blank PivotTable	301	(1)
Displaying data in your PivotTable	302	(4)
Modifying your PivotTable	306	(1)
Working with PivotTable data	307	(4)
Formatting PivotTables	311	(1)
Filtering the PivotTable data	312	(1)
Book IV: Forms	313	(86)
Designing and Using Forms (and Reports)	315	(20)
Forms and Reports Are Secretly Related	316	(1)
Creating Forms with AutoForms and Wizards	316	(6)
Your form creation options	316	(2)
Using More Forms to create super-speedy forms	318	(1)
Wizard, make me a form!	319	(3)
Viewing a Form	322	(1)
Creating Forms (and Reports) in Design View	323	(3)
Creating a form (or report) from scratch	323	(1)
Changing the layout of an existing form or report	324	(2)
Configuring the Whole Form or Report	326	(4)
Where records come from	327	(1)
Deciding the order of the records	327	(1)
One record or many?	328	(1)
Some other cool form properties	329	(1)
Sizing Forms	330	(1)
Storing Your Forms and Reports	330	(2)
Form and report management	331	(1)
Importing forms and reports from other databases	331	(1)
Editing Data Using Forms	332	(3)
Saving your data	333	(1)
Printing forms	333	(2)
Jazzing Up Your Forms (and Reports)	335	(22)
Taking Control of Your Form or Report	337	(6)
Form control types	338	(2)
Making a new control	340	(1)
Setting control properties	341	(2)
Making Controls That Display Text	343	(3)
Making and editing labels	343	(2)
Putting Text and Memo fields in text boxes	345	(1)
Displaying Number, Currency, and Date Fields	346	(1)
Moving, Renaming, Resizing, Deleting, and Copying Controls	347	(1)
Formatting Your Text	348	(3)
Copying your formatting	350	(1)
Make it red if it's bad news	350	(1)
Creating Check Boxes for Yes/No Fields	351	(1)
Neatening Up Your Controls	352	(2)
Adding Lines, Boxes, and Backgrounds	354	(1)
Controlling Cursor Movement in Your Form	355	(2)
Creating Smarter Forms	357	(28)
Creating and Configuring Combo and List Boxes	357	(6)
Making combo boxes the really easy way	359	(1)
Running the Combo or List Box Wizard	359	(3)
Changing the properties of a combo or list box	362	(1)
Cool Looks for Yes/No Fields	363	(1)
Creating Option Groups	364	(2)
Creating Command Buttons	366	(1)
Making a Close Button	367	(5)
Making a button to display a related form	368	(2)
Making a button to print the current record	370	(1)
Making other cool buttons	370	(1)
Customizing your command button	370	(1)
Making a Find box	371	(1)
Adding and Linking Subforms	372	(5)
Creating a subform	373	(2)
The properties of subform controls	375	(2)
Adding Form Headers and Footers	377	(1)
Creating Tabbed Forms	377	(2)
You Can't Type That Here!	379	(1)
Making Switchboards --- A Friendly Face for Your Database	380	(5)
The secret life of switchboards	380	(1)
Switchboard Manager, boss of the switchboards	381	(2)
The alternative to switchboards	383	(2)
Doing Calculations in Forms (and Reports)	385	(14)
Doing Elementary Calculations	385	(4)
Making a calculated control	386	(2)
Checking your expression	388	(1)
Troubleshooting expressions	388	(1)
Calculating and Formatting Numbers	389	(1)
Calculating and Formatting Dates	390	(1)
Calculating and Formatting Text	390	(1)
Displaying Values That Depend on Conditions	391	(1)
Adding Subtotals and Totals from Subforms	392	(5)
Using aggregate functions	392	(1)
Referring to a control on a subform	393	(1)
Creating the controls to total a subform	394	(3)
Formatting Calculated Controls	397	(2)
Book V: Reports	399	(72)
Creating and Spiffing Up Reports	401	(34)
If You Know Forms, You Already Know Reports	401	(2)
Creating Reports Automagically	403	(9)
Running the Report Wizard	404	(6)
Creating Simple Reports	410	(2)
Editing Reports in Design View	412	(1)
Report Sections and How They Work	413	(9)
Setting report and section properties	415	(1)
Adding page headers, footers, and numbers	416	(2)
Adding sections that group your records	418	(3)
Sorting the records in your report	421	(1)
Calculating group subtotals and report totals	421	(1)
Formatting Tips and Tricks	422	(2)
Copying Forms to Reports	424	(1)
Adding and Formatting Subreports	424	(4)
Making a subreport	426	(2)
Printing information from a subreport on the main report	428	(1)
Displaying Empty or Long Fields	428	(1)
Displaying long text	428	(1)
Displaying fields that may be empty	429	(1)
Creating Mailing Labels	429	(6)
Running the Label Wizard	430	(2)
Behind the scenes in a mailing-label report	432	(1)
Changing the page setup for labels	433	(2)
Printing Beautiful Reports	435	(10)
Viewing Your Report	435	(3)
Adjusting the view	436	(1)
Looking at lots of pages	437	(1)
Previewing reports with parameters	438	(1)
Formatting the Page	438	(4)
Selecting a printer	438	(1)
Setting margins, paper size, and paper orientation	439	(1)
Controlling page breaks	439	(2)
Avoiding blank pages	441	(1)
Printing only the data	442	(1)
Printing the Report	442	(1)
Sending a Report to Another Application	442	(3)
Creating Charts and Graphs from Your Data	445	(26)
Displaying Information with Charts and Graphs	446	(17)
Creating charts with the Chart Wizard	446	(4)
Making bar charts	450	(5)
Making line and area charts	455	(1)
Making pie and doughnut charts	456	(1)
Making bubble and XY scatter plots	457	(1)
Changing your chart	457	(4)
Formatting charts with colors, legends, and titles	461	(1)
Changing how the data is graphed	462	(1)
Changing which data is charted	463	(1)
Analyzing Your Data Graphically with PivotCharts	463	(8)
Creating PivotCharts	464	(2)
Saving and viewing your PivotChart	466	(1)
Sprucing up your PivotCharts	467	(4)
Book VI: Macros: Automating Stuff in Access	471	(38)
Making Macros Do the Work	473	(20)
What Is a Macro?	474	(1)
Creating and Editing Macros	474	(7)
Taking action!	476	(1)
Specifying arguments to actions	477	(2)
Naming, saving, and editing macros	479	(1)
Adding comments	479	(1)
Storing macros in related groups	479	(2)
Running Macros	481	(2)
Running a macro when the database opens	482	(1)
Assigning macros to keys	482	(1)
Opening Databases That Contain Macros	483	(4)
Can a macro be a virus?	484	(1)
Signing your database	484	(2)
Turning down your Access security setting	486	(1)
Attaching Macros to Forms	487	(6)
Creating command buttons on forms	490	(1)
Referring to form controls in macros	490	(1)
Printing matching records from a form	491	(2)
Making Macros Smarter	493	(16)
Only Run This If I Say So	493	(4)
If-then macros	494	(2)
If-then-else macros	496	(1)
Changing the Way Your Form Looks Dynamically	497	(4)
Setting the properties of form controls	497	(3)
Running a macro during data entry	500	(1)
Displaying Forms and Datasheets	501	(1)
Setting Up Your Own Main Menu Form	502	(7)
Creating a form that appears when the database opens	502	(2)
Creating command buttons for your main menu form	504	(5)
Book VII: Database Administration	509	(60)
Database Housekeeping	511	(16)
Compacting and Repairing Your Database	511	(1)
Making Backups	512	(4)
Backing up your database	513	(1)
Backing up specific objects	514	(2)
Converting Databases	516	(1)
Analyzing and Documenting Your Database	516	(5)
Viewing relationships in the Relationships window	516	(1)
Looking at a list of the objects in your database	516	(1)
Viewing object dependenceies	517	(1)
Analyzing database performance	518	(2)
Documenting your database	520	(1)
Loading and Managing Add-Ins	521	(2)
Running the Add-in Manager	522	(1)
Creating add-ins	522	(1)
Locking Up Your Database as an ACCDE File	523	(4)
Creating an ACCDE file	524	(1)
Making updates later	524	(3)
Sharing the Fun --- and the Database: Managing Multiuser Access	527	(16)
Putting Your Database Where They Can See It	528	(2)
Splitting Your Database into a Front End and a Back End	530	(6)
Why split?	530	(2)
Let's split!	532	(1)
Splitting by hand	533	(2)
Handing out front ends	535	(1)
Relinking your tables	535	(1)
Putting Your Favorite Objects into Groups	536	(1)
Making and unmaking new groups	537	(1)
Editing with Multiple Users	537	(6)
Fixing exclusive access	538	(1)
Managing record-locking	539	(4)
Securing Your Access Database	543	(26)
Windows Security	544	(1)
Setting Startup Options	544	(5)
Password-Protecting Your Database	549	(2)
Encrypting your database with a password	549	(1)
Opening a password-protected database	550	(1)
Granting Database Access to Specific Users	551	(18)
How user-level security works	551	(1)
The default workgroup file	552	(1)
Your new workgroup file	553	(1)
Choosing your users and groups	553	(2)
Securing a database	555	(5)
Opening your secure database	560	(1)
Setting passwords	561	(1)
Creating the rest of your users and groups	561	(1)
Setting permissions for groups	562	(5)
Securing your VBA modules	567	(1)
Securing front-end and back-end databases	568	(1)
Book VIII: Programming in VBA	569	(118)
What the Heck Is VBA?	571	(20)
Finding VBA Code	571	(4)
Opening a class module	572	(1)
Creating or opening a standard module	573	(2)
Enabling VBA Code	575	(1)
How code is organized	575	(1)
Using the Visual Basic Editor	576	(11)
Using the Code window	579	(1)
Using the Immediate window	580	(2)
Using the Object Browser	582	(1)
Searching the Object Library	583	(2)
Referring to objects and collections	585	(1)
Choosing object libraries	586	(1)
Closing the Visual Basic Editor	587	(1)
Discovering Code as You Go	587	(4)
Converting macros to VBA code	587	(3)
Cutting and pasting code	590	(1)
Writing Code	591	(24)
How VBA Works	591	(1)
VBA Syntax	592	(5)
Arguing with VBA	594	(2)
Module level versus procedure level	596	(1)
Declaring Module Options	597	(1)
Writing Your Own VBA Procedures	597	(7)
Creating a new standard procedure	597	(2)
Creating a new event procedure	599	(1)
Passing arguments to procedures	600	(3)
Returning a value from a function	603	(1)
Typing and Editing in the Code Window	604	(5)
Shortcut keys used in the Code window	605	(1)
Typing comments	606	(2)
Breaking lines of code	608	(1)
Dealing with compile errors	608	(1)
Testing and Running Your Code	609	(6)
Testing sub procedures	609	(2)
Running sub procedures from Access	611	(2)
Testing function procedures	613	(1)
Using function procedures in Access	614	(1)
Writing Smarter Code	615	(26)
Creating Variables and Constants	615	(8)
Make me a variable	615	(2)
Scope and lifetime of variables	617	(2)
Defining constants	619	(1)
Organizing variables into arrays	620	(1)
Multidimensional arrays	621	(1)
Naming conventions for variables	622	(1)
Making Decisions in VBA Code	623	(7)
Using If...End If statements	624	(2)
Nesting If...End If statements	626	(1)
Using a Select Case block	627	(3)
Executing the Same Code Repeatedly	630	(6)
Using Do...Loop to create a loop	630	(2)
Using While...Wend to create a loop	632	(1)
Using For...Next to create a loop	632	(2)
Looping through an array	634	(1)
Analyzing each character in a string	635	(1)
Using Custom Functions	636	(5)
Controlling Forms with VBA	641	(24)
Displaying Custom Messages	641	(3)
Displaying a message box	641	(2)
Responding to what the user clicks	643	(1)
Opening Forms with DoCmd	644	(4)
Umpteen ways to open a form	645	(2)
Closing a form with DoCmd	647	(1)
Changing Form Controls with VBA	648	(7)
Some cool control properties	648	(2)
Controlling properties example	650	(5)
Understanding Objects and Collections	655	(10)
Properties, methods, and events	656	(1)
Referring to objects and collections	657	(1)
An example: Seeing whether a form is open	658	(3)
Looping through collections	661	(2)
Using With...End With	663	(2)
Using SQL and Recordsets	665	(12)
Recordsets and Object Models	665	(5)
Quick and easy recordsets	666	(1)
ADO recordset properties and methods	667	(1)
Looping through a recordset	667	(1)
Defining a recordset's cursor type	668	(1)
Field names in recordsets	669	(1)
SQL and Recordsets	670	(4)
Breaking up long SQL statements	673	(1)
Running Action Queries from VBA	674	(3)
Cleaning up connections	676	(1)
Debugging Your Code	677	(10)
Considering Types of Program Errors	677	(1)
Fixing Compiler Errors	678	(1)
Trapping Runtime Errors	679	(4)
Fixing the runtime error	682	(1)
Eliminating the runtime error	683	(1)
Dealing with Logical Errors	683	(4)
Watching things happen	684	(1)
Slowing down procedures	685	(1)
Cleaning up	686	(1)
Appendix: Installing Microsoft Access	687	(6)
Activating Access	690	(1)
Repair, Reinstall, or Uninstall Access	691	(2)
Index	693