My Access question concerns adding new records:

If you use forms view to add a new record, the star at
the end offers blank fields for data entry.  Is it
possible to offer a drop down list (look-up list) only in
a new record's fields, when the rest of the table is
already populated?

If you create a new record entry form, which could
include all those drop down lists, do you use an append
query to add the new data to the table?  

Do append queries automatically empty out after appending
the new records?  Do they need to be batch processed,
like each day and labeled with the date, and then
manually cleared after the main table is updated?  Or is
there some kind of automatic append update process that
can be run?

Thanks for your help.