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

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

by ; ; ; ;
ISBN13: 9780470036495
ISBN10: 0470036494
Format: Paperback
Pub. Date: 2006-12-26
Publisher(s): For Dummies
  • Free Shipping Icon

    This Item Qualifies for Free Shipping!*

    *Excludes marketplace orders.

List Price: $31.49

Rent Book

Select for Price
Add to Cart
There was a problem. Please try again later.

New Book

We're Sorry
Sold Out

Used Book

We're Sorry
Sold Out

eBook

We're Sorry
Not Available

Buy from our Marketplace starting at $3.10

How Marketplace Works:

  • This item is offered by an independent seller and not shipped from our warehouse
  • Item details like edition and cover design may differ from our description; see seller's comments before ordering.
  • Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
  • Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
  • Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.

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

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.