How do i design a database

[Halladan]

Hi All, Ive never used Access before and i was wondering if there is an
idiots guide out there to creating one? What I am looking to do is create a
form which multiple users can access at the same time and populate a database
from there input, can you help?

Thank you.

 

[scubadiver]

Normalisation, normalisation, normalisation !!!!!!

What is your database being used for?

 

[Keith Wilby]

Hi All, Ive never used Access before and i was wondering if there is an
idiots guide out there to creating one? What I am looking to do is create
a
form which multiple users can access at the same time and populate a
database
from there input, can you help?

Thank you.

Access for Dummies is probably a good place to start, but be aware that
Access is a tool that allows you to *build* an *application*, it isn't a
database straight out of the box in the same way that Excel is a
spreadsheet. There are many pitfalls to be aware of which only research and
experience will reveal.

The main one for multi-user access is to make sure that your database is
split and each user has their own copy of the user-interface.

Feel free to post back when you need help with specific problems as there is
a multitude of talent on here offering *free* advice and guidance.

Good luck.

Keith.
www.keithwilby.com

 

[BruceM]

This link will help introduce you to some of the concepts (look at Table
Design in Tips for Casual Users in particular). Also, check out the Links
link on the right side of the page.
http://allenbrowne.com/tips.html

 

[mscertified]

The most important thing is to fully aware of what the database has to do
before you start designing it. This requires some skills in eliciting this
from the people who will actually use the database. It's also important to
factor in things that may change in the future and so that your design may
can easily cater for them.

-Dorian

 

[John W. Vinson]

Hi All, Ive never used Access before and i was wondering if there is an
idiots guide out there to creating one? What I am looking to do is create a
form which multiple users can access at the same time and populate a database
from there input, can you help?

Thank you.

Here's some links to valuable resources. Check Crystal's tutorial and the
"Database Design 101" links in Jeff's site in particular.

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/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]