Oct-2001 |
  
|
Oct-2001 |
|
|
Smart Access Article Abstracts |
Page |
|
Silver Collection |
2001-10 |
|
--- |
|
Mike Gunderloy |
1 |
|
Article |
|
Even some experienced Access developers shy away from writing SQL directly. That’s a shame, because, unless you’re willing |
|
to write SQL, you can’t use subqueries, which are a powerful tool for solving some especially thorny data retrieval problems. In |
|
this article, Mike Gunderloy introduces subqueries and shows how you can use them in Access. |
|
Nirmala Sekhar |
6 |
|
Article |
|
No database application is complete without a comprehensive search facility. There are many methods of incorporating search |
|
routines in a form or a query. In this article, Nirmala Sekhar demonstrates a simple method of searching your data based on a |
|
given list of relevant fields. The example can be easily used in your database with very few changes. |
|
Garry Robinson |
9 |
|
Article |
|
If you’ve split your database into two MDB files, there’s a simple way to speed up your application. This month, Garry Robinson |
|
shows you how. |
|
David Moss |
14 |
|
Article |
|
If you’re thinking of moving to a client/sever database, you can do it in Access. However, if you’re going to get the |
|
performance that you need, then you’ll need to change the way that you do things. David Moss shows how to replace the built- |
|
in functionality with some reusable code. |
|
|
|
|
|
|
|
|
|
|
|
Russell Sinclair |
19 |
|
Article |
|
Russell Sinclair introduces an important new feature of Access 2002-the ability to summarize data using PivotTables. |
|
Automating Access 2000 from Visual Basic: Set the UserControl When |
Adina Reeve |
22 |
|
Article |
|
Upgrading |
|
Automating Access 2000 from Visual Basic: Set the UserControl When Upgrading |
--- |
|
Find all the PDFs and Downloads |
--- |
|
Product Links |