Navigation:  Articles >

Nov-2005

Previous pageReturn to chapter overviewNext page

 

Smart Access Article Abstracts

Page

 

 

2005-11

 

---

 

Data modelling for the Access newcomer, Part 1

Glenn Lloyd

1

 

Article

 

Thorough, thoughtful, and accurate data modelling should be the starting point of detailed database design. But a surprising

 

number of developers have little or no understanding of data modelling and shy away from what looks like a non-profitable and

 

time-consuming task. Glenn Lloyd looks at the typical design pitfalls that trap Access beginners and shows the basic techniques that ensure success.

 

Simplifying queries

Russell Sinclair

5

 

Article

 

Rather than define every query that your users might require, why not let your users make up their queries as they need them -

 

Provided that they are not going to be overwhelmed by the options available to them. Russell Sinclair discusses how to create a simplified query interface for Access users.

 

All in the family

Doug Steele

8

 

Access Answers

 

In this article, Access MVP Doug Steele, aims to solve this dilemma and other family issues with just a query or two. "How can you concatenate the names of the family head from one record, the spouse's name from another record plus all of the children records and show them in a single line"

---

Purchase Smart AccessFirst page of this magazine

 

Find all the PDFs and Downloads

PDFs and Downloads Explained

---

 

Product Links

Home

News

Workbench for Access

Access To SQL Upsizer

FMS Software