A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How do i design a database



 
 
Thread Tools Display Modes
  #1  
Old August 20th, 2007, 08:18 AM posted to microsoft.public.access.tablesdbdesign
Halladan
external usenet poster
 
Posts: 3
Default How do i design a database

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.
  #2  
Old August 20th, 2007, 10:04 AM posted to microsoft.public.access.tablesdbdesign
scubadiver
external usenet poster
 
Posts: 1,673
Default How do i design a database


Normalisation, normalisation, normalisation !!!!!!

What is your database being used for?

--

The 11th day of every month:

http://truthaction.org/forum/index.php


"Halladan" wrote:

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.

  #3  
Old August 20th, 2007, 10:18 AM posted to microsoft.public.access.tablesdbdesign
Keith Wilby
external usenet poster
 
Posts: 812
Default How do i design a database

"Halladan" wrote in message
...
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

  #4  
Old August 20th, 2007, 01:23 PM posted to microsoft.public.access.tablesdbdesign
BruceM[_2_]
external usenet poster
 
Posts: 1,763
Default How do i design a database

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

"Halladan" wrote in message
...
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.



  #5  
Old August 20th, 2007, 04:36 PM posted to microsoft.public.access.tablesdbdesign
mscertified
external usenet poster
 
Posts: 835
Default How do i design a database

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

"Halladan" wrote:

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.

  #6  
Old August 20th, 2007, 07:56 PM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default How do i design a database

On Mon, 20 Aug 2007 00:18:04 -0700, Halladan
wrote:

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/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]
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:18 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.