Microsoft Excel and Access Integration

The premise behind this book is that Access is a powerful relational database and Excel is the world’s most widely used spreadsheet package. By using them together you can create some really powerful and useful applications.

Excel and Access work very well together. Access providing the database capabilities and Excel pivot table reporting and easy of use interface. Not many users are skilled in Access but they are capable in Excel.

Excel can provide the user friendly front end and Access the database back end.

This book takes you through how to take advantage of the best of both Excel and Access to create applications. It includes VBA example which can hep add that professional finish and customisation to a project.

It is aimed at intermediate to advanced users.