I have inherited a flat data base that has something like
50 fields, a heap of queries, forms and reports.  I need
to Normalise the table and fields.  Is it better to start
from fresh and then recreate all the forms, queries,

I am after an opinion as to whether or not it is advisable or necessary to
index a field that is used in a relationship with a field on another table.
I do know that creating a relationship also creates an index, so is there
an advantage or disadvantage to creating a separate index ...

Mr.Vinson, Your advice along with that of others sent me on a refresher
course in the Normalization of a database.  (regarding my post-plea for help-
"Is Data Just Data?", in this discussion group)  I had totally warped the
concept of the Second Normal Form.

I just wanted to post my tables and their relationships to
get some feedback from the pros on whether or not this
database is headed in the right direction. Thanks for the
help in advance.

hello i have a database, well i have a form that writes to a specific middle
table which i am trying to get this table to update the original table how do
i do this?

Hi, I want to create an invoicing system with access but I only have a
limited knowlege of the program.  I have a couple of questions and if anyone
can answer any of them I'd appreciate it very much.  
Q1.  Invoice numbering...

Hi, I have a database design question.  A friend and I were having lunch and
got into a database table discussion. Neither one of us is experienced in
database design or database application development.   I showed my friend the
database application that I am developing for a ...

Hi folks.  I need help conceptually with a problem.  I've recently
constructed database for monitoring signs of feral animals- fourteen tables,
expected to have about 100,000 records in at least 2 of those tables, 100's
to 1000's of records in the others by the end of about 10 ...

A worksheet for pricing the cost of repairing cars....

I have a Many-To-Many relationship between [Main] & [RefMain], using a
junction table [JnxTbl].  It works fine.  The problem I have is that I have
3 fields that point to [RefMain] for reference names.
But evey time that I make an entry, it doesn't add a record to the junction

How do you turn off the sound that you hear when closing unsaved Microsoft
documenets?  The Microsoft online help was good but did not solve the problem?

I have a table containing customer information. The unique value consists of
a customer ID like this, 000000-0000, and it has been set it to Indexed - no
duplicates allowed. This table is related to another table with more specific
information, orders and the like. However, ...

I am doin a automitive database, however i am faced with a problem.
Staffs are not paid hourly. So i need to come up witha function that will
enable me to calculate the total charge for each repair order. the only
fields I have r :

Can I add a date stamp (and or a User stamp) in a Text or Memo Field when a
user updates my notes field (Memo)

How many fields are allowed on an Access table?