Whats Next

This chapter presented various examples of getting Excel data into a Microsoft Access database and retrieving data from Microsoft Access into a worksheet. You learned how to control an Access application from an Excel VBA procedure, performing such tasks as opening Access forms and reports, creating new forms, running Select and Parameter queries, and calling Access built-in functions. In addition, this chapter showed you techniques for creating text files, query tables, and charts out of the Access data. You also learned how to place Excel data in an Access database by using linked, imported, and dynamic Access tables.

In the next chapter, you will learn how to use Excel to create, view, and analyze Internet data.

0 0

Post a comment