Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Database design questions

Database design questions

Database design questions

I have a spreadsheet that contains sales order information that I would like to convert over to an access database
and I am looking for suggestions or any tutorials on how to best do this.

The fields on the spreadsheet include customer name, order number, date entered, system type, computer part number,
computer description, software license, Mac address, IP address along with a few more fields.

I want this to be a multi-user database with a front-end user interface (for the forms) and a back-end interface
(for maintaining the tables) but should I set this up as a relationship database or a flat database and what are the
factors in determining this and what fields to create relationships with?

Thanks for any suggestions or pointers to any good documentation that would point me in the right direction...

RE: Database design questions

"set this up as a relationship database or a flat database " - definitely a relational database. Normalized.
"what fields to create relationships with" - Primary Key to Foreign Keys relationship.

If you've never done it, there are a lot of examples on the Web. Google is your best friend.

Just my $0.02 smile

---- Andy

There is a great need for a sarcasm font.

RE: Database design questions

Thanks Andy

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close