Microsoft Excel and Access Integration

With Microsoft Office 2007

Although many people rarely go from Excel into Access or vice versa, you should know that Microsoft actually designed these applications to work together. In this book, you’ll discover how Access benefits from Excel’s flexible presentation layer and versatile analysis capabilities, while Access’s relational database structure and robust querying tools enhance Excel. Once you learn to make the two work together, you’ll find that your team’s productivity is the real winner.

Excel is used for spreadsheet analysis and reporting whereas Access is used for
database functions—and that's it. Indeed, most mainstream training courses and
documentation are often dedicated to one application or another, often ...