xxi
Contents
Working with Linked Tables .............................................................................................597
Setting view properties ............................................................................................598
Setting relationships ................................................................................................598
Optimizing linked tables .........................................................................................598
Deleting a linked table reference .............................................................................599
Viewing or changing information for linked tables ..................................................599
Using Code to Link Tables in Access .................................................................................600
The Connect and SourceTableName properties .......................................................600
Checking links ........................................................................................................606
Summary ..........................................................................................................................608Chapter 17: Importing and Exporting Data . . . . . . . . . . . . . . . . . . . . . . . 609
Looking at Your Options for Importing and Exporting......................................................609
Importing External Data ....................................................................................................611
Importing from another Access database .................................................................611
Importing from an Excel spreadsheet ......................................................................614
Importing a SharePoint list ......................................................................................618
Importing data from text files ..................................................................................618
Importing an XML document ..................................................................................623
Importing an HTML document ...............................................................................627
Importing Access objects other than tables ..............................................................628
Importing an Outlook folder ...................................................................................630
Importing dBase tables ............................................................................................631
Troubleshooting import errors ................................................................................633
Exporting to External Formats ..........................................................................................634
Exporting objects to other Access databases ............................................................634
Exporting through ODBC drivers ............................................................................635
Functionality exclusive to exports ...........................................................................636
Summary ..........................................................................................................................636Chapter 18: Advanced Access Query Techniques . . . . . . . . . . . . . . . . . . 637
Using Calculated Fields .....................................................................................................638
Calculated Fields and the Expression Builder ....................................................................640
Counting Records in a Table or Query ..............................................................................642
Finding the Top (n) Records in a Query ............................................................................644
How Queries Save Field Selections ....................................................................................646
Hiding (not showing) fields .....................................................................................647
Renaming fields in queries ......................................................................................647
Query Design Options ......................................................................................................649
Setting Query Properties ...................................................................................................651
Creating Queries That Calculate Totals .............................................................................653
Showing and hiding the Total row in the QBE pane ................................................654
The Total row options .............................................................................................654
Performing totals on all records ...............................................................................657
Performing totals on groups of records ....................................................................65902_475348-ftoc.indd xxi02_475348-ftoc.indd xxi 4/1/10 1:42 PM4/1/10 1:42 PM