Depending on who you're trained by, you will probably get (only) intense
focus on #2, and some focus on #1. I'll be curious (here) to hear about it
afterwards...

Good luck!

Jeff

"Mort" wrote in message
...
Thank you. I can attest to that fact and am proceding very cautiously.

The first was rather simple, four tables and I was given enough time so
that
I could understand what was being written about on the 1NF,2NF, and 3NF.
Customers, Products, Orders, and Shipments tables (no partial shipments so
Primary Keys and Joins were not to hard to figure out).
This one is much more difficult - I am being approached to do it after my
initial success. I have registered for Access training at a Microsoft
certified training company for a three day instructor led class, but it
is 7
weeks into the future.

"Jeff Boyce" wrote:

Mort

I've always heard that it is your SECOND application which is the most
dangerous ... after you learn enough to finish the first ...

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"Mort" wrote in message
news
I am designing my second database, Access 2007.
I need a drop-down list on a form which enters data into the table
tblStats.
I want a combo box and will type in three values,
Complete;Incomplete;Pending. When one of these values is selected for
the
active record, that value should go to the field Status in the table
tblStats.
I can not figure out how to accomplish this. Please help

Mortimer


.