Microsoft Access Database Table Design

Sort by: Replies Descending

M

Data Primary key vs. Artificial (Autonumber) primary key

M.
Dec 4, 2007

2 3 4

Replies: 78

Views: 4K

Dec 14, 2007

Jamie Collins

J

G

Autonumber Fields

Guest
Sep 22, 2005

2 3

Replies: 59

Views: 2K

Sep 29, 2005

BruceM

B

G

How do you mulitply in a field?

Guest
Aug 15, 2007

2 3

Replies: 56

Views: 2K

Sep 3, 2007

Jamie Collins

J

T

Too MANY entities? Can't create a report that works.

TC
Jan 6, 2004

2 3

Replies: 51

Views: 2K

Feb 2, 2004

Tim Ferguson

T

T

Prospective Client Tracking Database

TGC
Jan 19, 2010

2 3

Replies: 50

Views: 3K

Jan 28, 2010

Gina Whipp

G

G

I think I'm almost there...except for...

Guest
May 23, 2006

2 3

Replies: 47

Views: 2K

May 25, 2006

Jamie Collins

J

F

many to many problem

Frank Cutre
Jul 19, 2005

2 3

Replies: 41

Views: 2K

Jul 27, 2005

tina

T

G

Many-2-many relationships: Can I be told ...

Guest
Nov 9, 2006

2 3

Replies: 40

Views: 1K

Nov 10, 2006

Guest

G

G

PK - To AutoNumber or Not To AutoNumber - That is the Question! :-

Guest
Aug 2, 2007

2 3

Replies: 40

Views: 2K

Aug 9, 2007

Jamie Collins

J

T

Exceeds maximum index number

Todd
Feb 28, 2004

2

Replies: 39

Views: 2K

Jan 31, 2006

mucka

M

J

Question about a default table or method

Joe Cilinceon
Nov 13, 2005

2

Replies: 38

Views: 814

Nov 14, 2005

PC Datasheet

P

G

Hostel Database Setup

Guest
Jul 23, 2006

2

Replies: 36

Views: 2K

Jul 26, 2006

Guest

G

K

confusing relationships

kingnothing via AccessMonster.com
Mar 22, 2006

2

Replies: 36

Views: 1K

Mar 31, 2006

kingnothing via AccessMonster.com

K

B

How to enforce subtypes/supertypes in Access 2000?

Bob
Aug 6, 2006

2

Replies: 35

Views: 4K

Aug 14, 2006

Bob

B

G

Task List with tasks link to daily, day of week or other

Guest
Nov 26, 2005

2

Replies: 35

Views: 1K

Nov 30, 2005

John Marshall, MVP

J

R

No duplicate records problem

Russ
May 14, 2009

2

Replies: 34

Views: 985

May 15, 2009

Russ

R

P

Membership database updates

Pennington
Mar 19, 2008

2

Replies: 33

Views: 1K

Apr 7, 2008

Pennington

P

D

I was told "Fields are expensive, records are cheap"

Dennis
Feb 24, 2010

2

Replies: 32

Views: 2K

Mar 1, 2010

David W. Fenton

D

G

Table Normalization

Guest
Dec 12, 2004

2

Replies: 32

Views: 1K

Feb 22, 2005

Guest

G

J

A2007 - OLE vs. Attachements

Jay Oken
Oct 11, 2009

2

Replies: 31

Views: 1K

Nov 20, 2009

johnlute

J

G

Thank you Steve for all your help

Guest
Aug 17, 2007

2

Replies: 30

Views: 884

Aug 20, 2007

Keith Wilby

K

D

Primary key ContactID not migrating to subforms

Darren Kozey via AccessMonster.com
May 14, 2005

2

Replies: 29

Views: 870

May 21, 2005

tina

T

G

Guest
Mar 29, 2006

2

Replies: 29

Views: 839

Apr 3, 2006

Duane Hookom

D

C

cjgav
Jun 7, 2009

2

Replies: 29

Views: 1K

Jun 17, 2009

cjgav

C

L

creating new database

LTOSH
Feb 6, 2009

2

Replies: 29

Views: 1K

Feb 9, 2009

Gina Whipp

G

G

Table design problem?

Guest
Oct 23, 2005

2

Replies: 29

Views: 958

Nov 18, 2005

Ken Snell [MVP]

K

G

Quotes to Orders to Invoice design - Help!!

Guest
Apr 20, 2006

2

Replies: 28

Views: 3K

May 1, 2006

Allen Browne

A

G

Is this a Sound Database Design?

Guest
Jul 28, 2006

2

Replies: 28

Views: 1K

Aug 3, 2006

strive4peace

S

L

Table design question re duplicates fields

lmcc007
May 7, 2009

2

Replies: 28

Views: 1K

May 13, 2009

Fred

F

L

Relationships, back end

Len B
May 20, 2009

2

Replies: 28

Views: 1K

May 28, 2009

tina

T

A

Pictures/Images in Tables

adrian007uk
Jun 30, 2009

2

Replies: 28

Views: 1K

Jul 18, 2009

adrian007uk

A

A

How to obtain logical combination for query result?

~ angel ~ via AccessMonster.com
Oct 4, 2007

2

Replies: 28

Views: 1K

Oct 8, 2007

Amy Blankenship

A

G

Simple Questionnaire DB

Guest
Aug 17, 2007

2

Replies: 26

Views: 1K

Sep 3, 2007

John W. Vinson

J

O

Avoiding One to One Tables

oldblindpew
Sep 10, 2009

2

Replies: 26

Views: 1K

Sep 17, 2009

Gina Whipp

G

G

Attribute-value approach for table design

Guest
Nov 6, 2006

2

Replies: 26

Views: 1K

Nov 17, 2006

David W. Fenton

D

J

Slow form, again

jenniferspnc
Feb 22, 2010

2

Replies: 26

Views: 1K

Feb 26, 2010

John... Visio MVP

J

R

One to Many and Auto Number Problem

Robert T
Jan 3, 2008

2

Replies: 26

Views: 1K

Jan 24, 2008

David W. Fenton

D

G

How do I set up a small business database using Access??

Guest
Oct 31, 2005

2

Replies: 26

Views: 3K

Nov 2, 2005

George Nicholson

G

G

Design Question

Guest
Jul 13, 2007

2

Replies: 26

Views: 1K

Jul 23, 2007

Michael Gramelspacher

M

G

Training records

Guest
Oct 31, 2006

2

Replies: 26

Views: 1K

Nov 13, 2006

BruceM

B

G

Opening table - query running?

Guest
May 11, 2007

2

Replies: 25

Views: 4K

May 24, 2007

Pat Hartman \(MVP\)

P

D

CREATE TEMPORARY TABLE

David Rigler
May 31, 2006

2

Replies: 25

Views: 4K

Jun 12, 2006

Pat Hartman\(MVP\)

P

C

Multitable searching

CorporateQAinTX
Nov 24, 2008

2

Replies: 25

Views: 795

Dec 8, 2008

John W. Vinson

J

T

data is repeating itself

tboyce
Jan 7, 2009

2

Replies: 25

Views: 1K

Mar 30, 2009

tboyce

T

C

Should I use auto-number for my tables?

CAD Fiend
Oct 29, 2004

2

Replies: 25

Views: 2K

Nov 17, 2004

Brendan Reynolds

B

G

tables not relating properly

Guest
Aug 23, 2007

2

Replies: 25

Views: 1K

Aug 30, 2007

BruceM

B

D

Your Opinion on Design Question

dhstein
Nov 23, 2008

2

Replies: 24

Views: 1K

Nov 27, 2008

Michael Gramelspacher

M

T

New Database - Primary Key

Trini Gal
Jun 5, 2009

2

Replies: 24

Views: 1K

Jun 15, 2009

Tony Toews [MVP]

T

F

Last entry +1 help....Reset when desired.

Fletcher
Jul 26, 2006

2

Replies: 24

Views: 716

Aug 3, 2006

strive4peace

S

B

Database Design Normalization help

Billiam
Jul 23, 2008

2

Replies: 24

Views: 905

Jul 30, 2008

Billiam

B