Microsoft Access 2010 Bible

Chapter 15: Using Access Data Macros 573 FIGURE 15.17 Dragging an item to a new location Position indicator Shadow box Collapsin ...

Part II: Programming Microsoft Access 574 FIGURE 15.18 Collapsed items help simplify the Macro Designer surface Saving a macro a ...

Chapter 15: Using Access Data Macros 575 FIGURE 15.19 Saving a macro as XML Recognizing the Limitations of Data Macros As powerf ...

Part II: Programming Microsoft Access 576 Access 2010 data macros are not supported on linked tables. If the table in an Access ...

Part III More-Advanced Access Techniques IN THIS PART Chapter 16 Working with External Data Chapter 17 Importing and Exporting D ...

21_475348-pp03.indd 57821_475348-pp03.indd 578 4/1/10 1:51 PM4/1/10 1:51 PM ...

579 CHAPTER Working with External Data IN THIS CHAPTER Looking at the types of external data and methods for working with them L ...

Part III: More-Advanced Access Techniques 580 Table External File Type Filename(s) CONTACTS dBase 5.0 CONTACTS.DBF, CONTACTS.DBT ...

Chapter 16: Working with External Data .................................................................................... 581 ...

Part III: More-Advanced Access Techniques 582 There are distinct differences among the three methods: l Linking uses the data in ...

Working with Data Types ................................................................................................. 583 Ca ...

Part III: More-Advanced Access Techniques 584 Tip If you’ll be importing data from the same source frequently, you can automate ...

Chapter 16: Working with External Data 585 Access can simultaneously link to multiple tables contained within other database sys ...

Part III: More-Advanced Access Techniques 586 FIGURE 16.2 A query using externally linked tables Local Access table Linked Excel ...

Chapter 16: Working with External Data 587 Figure 16.3 illustrates an important concept regarding using linked data in Access. U ...

Part III: More-Advanced Access Techniques 588 l (^) ODBC: ODBC is a data-access technology that uses a driver between an Access ...

Chapter 16: Working with External Data 589 FIGURE 16.4 Use the Get External Data dialog box to select the type of operation you ...

Part III: More-Advanced Access Techniques 590 After you link tblSalesPayments, Access returns to the object list and shows you t ...

Chapter 16: Working with External Data 591 acquiring an Oracle ODBC driver. Not only are vendors supplying drivers for their own ...

Part III: More-Advanced Access Techniques 592 l (^) Excel columns may contain virtually any type of data. Just because you have ...