Navigation:  Articles >


Previous pageReturn to chapter overviewNext page


Smart Access Article Abstracts








A Classy Interface for Microsoft Excel

Garry Robinson





In this article, Garry Robinson shows you how to use a class to manipulate Microsoft excel. His class provides a software layer


that hides the complexity of dealing with Excel through VBA. You'll see how to use Garry's class to push single pieces of data
into Excel, how to transfer data from queries into Excel, and how to let users navigate between results using bookmarks.
"Note: We are still using this code for many of our Excel reporting projects" says Garry


Data Modeling for the Access Newcomer, Part 2

Glenn Lloyd





Last month Glenn Lloyd started outlining his approach to data modelling. This month he finishes his discussion of the rules that


ensure that your database will actually work after you've built it.


Access Answers: Want Machine Information What marvellous insights!

Doug Steele



Access Answers


This month Doug Steele looks at how to tap into the wealth of information available through windows management


instrumentation (WMI), a component of the Microsoft windows operating system.


Purchase Smart AccessFirst page of this magazine


Find all the PDFs and Downloads

PDFs and Downloads Explained



Product Links



Workbench for Access

Access To SQL Upsizer

FMS Software