Summary

In this chapter, you learned various ways to display data programmatically from Access. You looked at several examples, such as creating new reports programmatically and exporting data to various formats. I hope you are beginning to see that there is much more to Access than just tables, forms, and reports. You have seen in this and prior chapters how to work with data in various sources, and to perform many advanced operations using VBA code.

I have talked a lot so far about SQL Server, but you have not seen any examples. The next chapter will focus on building Access solutions that use SQL Server as the database. You will learn that Access has many features that make working with SQL Server databases much easier.