Feedback Form
Home Features Mastermind Forums About Advertise Blog Network Contact Be An Author

What I Really Want Is...

What I Really Want Is...

Ensure you get the system
you need by using our
checklist to creating a
comprehensive database
system specification
Start at the very beginning
Work out the process you are
trying to automate with the
database, DO NOT DO ANY
PROGRAMMING UNTIL
YOU CAN SEE WHAT IS
NEEDED!
List the process on paper one
function at a time, in order, e.g.
1. Customer details come in
via application form,
2. The fields on application
form are: xxxxx
3. Therefore all the fields from
the form are to be added to
the database.
Attention to detail
You do not need to know how
to programme in order to
specify a database, but you do
need to be able to put into
words the details you would
like to get out of the database,
such as:
Labels: list sizes and shapes
Letters: standard and freeform
Reports: various types, with
all their field names, sort order,
search criteria, how often you
need the data, etc.
Searches: which types? Do
you need the searches printed,
viewed on screen, or exported?
Maximise your information
1. What information do you
want to analyse?
2. Who needs to get
information from you, and
what information do they
need?
3. In what format do they need
to get it?
4. What other applications do
you need to interface with?
5. Where is the information
coming from that is to be
used to populate your
database?
6. How can this data be gotten
into the database?
Include everything
If you can work out exactly
what information you need to
get out of the database, you
have already told the
programmer what he needs to
put in to the database. You can
not get stuff out that has not
been put in!
When should I use a
database?
Any process that has a logical
approach can be databased.
Database programming only
really gets into a mess when
the person specifying the
system is unsure of the process
they are asking to be
automated, or when the
programmer has not fully
understood the process.
If you cannot easily specify the
data flow that is required, or
need help in untangling
existing systems, consultancy
can enable you to do this.
Get the information right
Every company needs to be
able to designate a person who
is the key decision maker, and
who can confirm the processes.
Make sure both parties agree
the core functionality and key
processes.
A database specification report
should be drawn up, detailed if
possible to the last field name,
and signed off before any
programming starts.
Programming is always costed
on a time basis, “how long will
your spec take to make?”. So
remember that further
questions and amendments
beyond this agreed spec may
be charged for!
If your specification is sound
and logical, then you’ll get the
system you want - it’s as
simple at that!





What I Really Want Is - To learn more about this author, visit Paul Cruse's Website.

Like this article? Share it with your friends

Article Feedback
 Article Feedback No article feedback found.
  Leave Your Feedback
article feedback

Article Feedback

To learn more about the Evan Elite Author Program please contact us.

About The Author


Paul Cruse
(Visit Paul's Website) http://www.crusecontrol.com FileMaker Pro database developer. England. Cruse Control offer a range of services from FileMaker Database Design through to Graphic Design, Microsoft Powerpoint Templates and presentations on Mac and PC, IT Consultancy and Web Design. For further details on these services click to view the Services page. To download DEMO databases just click on Demo Downloads from http://www.crusecontrol.com and choose CONTACTS!, WorkflowPLUS!, or Publish! for PC or Mac. For a full description of each of these customisable database products, go to http://www.crusecontrol.com/product a.htm

Paul Cruse is a Gold author on EvanCarmichael.com
About The Author

View Author Blog
View Author Blog

View Author Video
View Author Video

Free Downloads


Paul Cruse's

Complete
List Of
Technology
Articles

Name
Email
If you enjoyed this article, get Paul Cruse's Complete List of Technology Articles For FREE!

More Paul Cruse
The Training Routine
Digital Printing
Lovely Layouts and Ripping Reports
FIND The power of your database
Presenting Presentations
HELP
Computer Love
Art in the Corporate Environment
What I Really Want Is
Free Downloads


 
 
 


Evan Elite Authors
Jeff Foster  
Dave Kurlan  
Kim Castle  
Evan Elite Authors

Become An Author
Have you written articles that would be of value to entrepreneurs? Become an expert on our site by publishing them! Expose yourself to a wide audience, drive more traffic to your website and get more sales! Click Here for details.
Become An Author

Evan's Latest Video
Modeling the Masters: Learn the true secrets behind Walt Disney's business success factors & grow your company! Video produced by Phanta Media
Evan's Latest Video

Business Opportunities
"Learn straight from Evan how you can Make a Full Time Income (And More) from a Website"

How to Start An Online Business

Click Here To Learn More
Business Opportunities



Evan's Newsletter
Get advice & tips from famous business owners, new articles by entrepreneur experts, my latest website updates, & special sneak peaks at what's to come!
Name:
Email:
Evan`s Newsletter

Free Downloads
Caprino Career Path Assessment Icon Caprino Career Path Assessment
3 Deadly Traps Icon 3 Deadly Traps
How To Get Media Attention Icon How To Get Media Attention
Green Realestate CSS Template Icon Green Realestate CSS Template
Radical Green Business Icon Radical Green Business
Free Downloads - Complete List

Entrepreneur Tools and Guides
Top 50 SEO Posts of the Year
Top 50 SEO Posts - 2008
Top SEO Posts of the Year
 
Top 50 Marketing Blogs To Watch In 2008
Top 50 Marketing Blogs
Top Blogs To Watch In 2008
 
Entrepreneur Tools and Guides

SEO For Africa
SEO For Africa
Edith Amana Agoe, Togo,
Edith Amana
Agoe, Togo
SEO For Africa

If I Were A Startup...
Lisa Shepherd, $335k to $1.1 Mil in 2 years
Lisa Shepherd
$335k to $1.1 Mil in 2 years
Frank Cianciulli, $2.3 to $7.5 Mil in 2 years
Frank Cianciulli
$2.3 to $7.5 Mil in 2 years
If I Were A Startup... - Complete List

Famous Entrepreneurs
Jim Sinegal, Costco
David Ogilvy, Ogilvy & Mather
David Ogilvy
Ogilvy & Mather
Famous Entrepreneurs - Complete List

Entrepreneur Advice
Guy Kawasaki, The Art of the Start
Guy Kawasaki
The Art of the Start
Tom Peters, In Search Of Excellence
Tom Peters
In Search Of Excellence
Entrepreneur Advice - Complete List

Popular Articles
(Premium Authors)

     Surviving Business Travel
By Gretchen Koehler-Swaney
     "Skivvies Are the New Civic Duty"
By Gretchen Koehler-Swaney
     Tips for the Novice Traveler
By Gretchen Koehler-Swaney

Have A Suggestion?
Toronto Salsa Classes / Toronto Salsa Lessons Email us your ideas on how to make our website more valuable! Thank you Sharon from Toronto Salsa Lessons / Classes for your suggestions to make the newsletter look like the website and profile younger entrepreneurs like Jennifer Lopez and Sean Combs!
Have A Suggestion?

More Evan Carmichael
More Information