I am trying to make up a Database and it has to be 3NF. Is the example
at the bottom correct?
Ive added EMP_NUM to the Project table so that
projects may have an employee assigned to them. But how would I go

How can I create multiple tables by using the data from one master table?  I
need to pull certain items from a master table and use them in other tables
but I can only do this by copying the information into another table.  This
seems to go against the concept of centralized ...

I am trying to enter criteria that selects names in a column that were
entered more than once.  I appreciate your assistance.

I am having a problem setting the default value for a text box in a form.  I
have 8 forms; each form applies to a certain category name.  I want a text
box in the form to have a default value of the category name, so that the
user does not have to type anything it will just ...

I am using access 2000. I can get into access, but i cannot access my files
as they are password protected and i have lost the password. The user comes
up as "admin " by default. if someone could help me i would be very grateful.
thanks

My autonumber fields properties keep changing to random instead of
sequential. I reset them to sequential but when I open the database again
and add a new record it's back to random. Can anyone give me any clues as to
why this is happening please?

I have a situation where multiple people in a group utilize an Access
2003 database.  Only one user has this issue.  When she attempts to
print to a regular HP LaserJet from the database, her screen goes dark
and her PC reboots.  When she prints to the MS Office Document Image

I am trying to create a report where I can include the field that shows our
clients last assessment date and then dates at 3 months, 6 months, 9 months
and 12 months, for quarterly followups.  I followed the directions in my
"Access 2000 Bible" for Expression Builder and my ...

I have been learning access- at a very slow pace.  As I learn I have been
developing a complex database.  The problem is I frequently get stuck & spend
a lot of time resolving problems/ troubleshooting.  
I have taken a basic , begining class but now am looking for more advanced

This has been bugging me for some time. When I maximize forms I get a blank
window. If I restore the window & use the slide bars to get to the beginning
of the forms & then maximize. I can see all the forms. Tried kb but no
banana. Any ideas? TIA

Hi
On my first form I have a drop-down box and I want if user selects specific
value, access opens my second from, I tried following code but not working:
DoCmd.OpenForm "prc frm", , , , , , Reason_for_visit = [Procedure]

I am trying to set up a database for a class, and it needs to be 3rd
Normal form. Here were my two examples:
BOOK (ISBN_NUM, BOOK_NAME)
AUTHOR (AUTH_NUM, AUTH_NAME, ISBN_NUM)

I have a form "PurchaseOrders", on the purchase order form I have a cmd
button to take me to another form "ItemList". This is used when an item is
not in my database and I would like to add the item without leaving the
"PurchaseOrder". All is working well except after adding the ...

I have an Access db containing about 250 tables.  I need to create a
text file that lists the names of all of the tables.  What is the
easiest way to create such a list?
Thanks

Im trying to manually imput a list of names and addresses to create a
mailing list. I have tried everything but with no luck.
This is the first time I have used Access so please could I hvae a step by
step instructions.