Navigation:  Articles >

Oct-1998

Previous pageReturn to chapter overviewNext page

 

Smart Access Article Abstracts

Page

 

Bronze Collection

1998-10

 

---

 

Consolidating Your Data With Queries

Garry Robinson

1

 

Article

 

From the author of the Graf-FX data mining tool, here's a comprehensive look at how you can use consolidation queries in Access. And we're not just talking about how to use Group By, either.

 

 

 

Building a Better Access Resource

Peter Vogel

3

 

Editorial

 

Peter discusses a Smart Access reader survey

 

Data Modeling For Access Developers

Markus Bosshard

7

 

Article

 

For many Access Developers, data modeling is something that's only used for large database systems - for too technical to be of any practical use. Well, that's not exactly true.

 

The fact that you're using Access and not Excel show that you want your data stored in a structured way in a database. This article shows you how to go about structuring your data using data modeling.

 

Case Study: Configuring Data

Peter Vogel

11

 

Article

 

Sometimes the way that data is stored makes is difficult to realize that a SQL solution is possible. Here's a case where using SQL

 

decreased the size of the program and cut its run time by 12,000 percent.

 

Bar Code Basics : How to Use Electronic Data Capture

David Irvine

15

 

Article

 

It's not a question of using bar codes but of how you're going to use them. Here's what you need to know to understand bar

 

code technology.

 

Say UNC, API Calls, {CAPSLOCK}, and Time

Russell Sinclair

18

 

Access Answers

 

In this month's "Access Answers," Russel looks at some problems with storing Word documents in a database, turning off the

 

CapsLock key, and calculating the time between events.

---

 

Find all the PDFs and Downloads

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

---

 

Product Links

Home

News

Workbench for Access

Access To SQL Upsizer

FMS Software