I'm Seeking DB Design References

Hello, I am looking for some references to help me structure a rather large
project. TOO large for me to just wing it. I would appreciate any
suggestions, Thanks for your help.

Go to Amazon.com and search for Database Design for Mere Mortals

--
Dave Hargis, Microsoft Access MVP


"MVP - WannaB" wrote:

Hello, I am looking for some references to help me structure a rather large
project. TOO large for me to just wing it. I would appreciate any
suggestions, Thanks for your help.

Access Developer Handbook and Access 2007 inside out are my favorites. Mine
are quite dog eared.
"MVP - WannaB" wrote in message
news
Hello, I am looking for some references to help me structure a rather
large
project. TOO large for me to just wing it. I would appreciate any
suggestions, Thanks for your help.

You don't need to look at large tomes on the subject. Break your project
down to manageable sections. For each section, create a table for each
entity and then determine what fields you need for the entity. You will find
some tables to be factual such as name and contact info for customer while
some tables will be descriptive such as domestic or international for a
customer. I suggest you start the name of All tables with "Tbl". When you
get to writing code you'll be able to tell tables from queries because query
names will begin with "Qry". I have helped many customers structure their
database at the beginning for a very modest fee. I provide the design of the
tables as well as a map of the tables to document the structure.

Steve




"MVP - WannaB" wrote in message
news
Hello, I am looking for some references to help me structure a rather
large
project. TOO large for me to just wing it. I would appreciate any
suggestions, Thanks for your help.

"MVP - WannaB" wrote

Hello, I am looking for some references to help me
structure a rather large project. TOO large for me
to just wing it.

"Designing Effective Database Systems", by Rebecca Riordan. Either of the
editions, one from Microsoft, another from a different publisher, will be
just fine. May be out of print, but searching for a copy at half.com or
ebay or ??? would be well-worth the time and trouble.

On Wed, 6 Aug 2008 13:54:01 -0700, MVP - WannaB
wrote:

Hello, I am looking for some references to help me structure a rather large
project. TOO large for me to just wing it. I would appreciate any
suggestions, Thanks for your help.

In addition to the other good suggestions, try:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/acc...resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials
--

John W. Vinson [MVP]

"Steve" wrote in message
m...
I have helped many customers structure their database at the beginning for
a very modest fee. I provide the design of the tables as well as a map of
the tables to document the structure.

Steve

Still trying to solicit work? I guess those you have helped were not
impressed enough for repeat business.

These newsgroups are provided by Microsoft for FREE peer to peer support.
Stevie is the only one over the past few years who does not understand the
concept of FREE support.

John...

I usually offer three "learning curves" you'll want to consider when
building an application (is that what you mean by "a rather large
project"?)...

1. Understanding "normalization" and "relational database design". Many of
the responses you received point this direction.
2. Understanding how Access does things ... this is learning the ins and
outs of how Access works.
3. Understanding what appeals to users and what turns them off -- "graphical
user interface design".

(and I usually throw in a 4th ... experience with development projects!).

Good luck! Feel free to post back in the 'groups with specific questions.
You have a rich resource here.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"MVP - WannaB" wrote in message
news
Hello, I am looking for some references to help me structure a rather
large
project. TOO large for me to just wing it. I would appreciate any
suggestions, Thanks for your help.

"Steve" schreef in bericht m...

I provide the design of the
tables as well as a map of the tables to document the structure.

Steve



IMO you provide nothing but crap, and it's not even free...

ARRRGGGHHHHHHHH !!!!!!!!
The OP did NOT ask for payed help ...

--
Hey Steve !!
Did you get lots of new customers from the groups lately ??
How many developers still work for you ??

This is to inform 'newbees' here about PCD' Steve:
http://home.tiscali.nl/arracom/whoissteve.html (Earthlink and SuperNews kicked him out ?? == updated 'abuse-reporting')
Until now 6300+ pageloads, 4150+ first-time visitors

*********************************
If anyone wants to help us getting rid of Steve ??
(appropriate action will follow when there are enough complaints)
*********************************

Arno R

On Wed, 6 Aug 2008 17:40:43 -0400, "Steve" wrote:

I suggest you start the name of All tables with "Tbl". When you
get to writing code you'll be able to tell tables from queries because query
names will begin with "Qry".

If you are just starting out, I would advise that you to first read the relevant
parts of Joe Celko's SQL Programming Style. Things like starting a table name
with a tbl- prefix, to quote one Access expert, "... makes Access look like a
toy for people who are not to be taken seriously."