Navigation:  Articles >

Oct-2001

Previous pageReturn to chapter overviewNext page

 

Smart Access Article Abstracts

Page

 

 

2001-10

 

---

 

Access Subquery Techniques

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.

 

Smart Search without the Hassles

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.

 

Remote Queries in Access

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   or article in PDF

 

shows you how.

 

Prometheus Unbound

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.

 

 

 

 

 

 

 

 

 

 

 

PivotTables in Access

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

http://www.vb123.com/smart/

---

 

Product Links

Home

News

Workbench for Access

Access To SQL Upsizer

FMS Software