Microsoft Office 2000 Access

[Suzanne]

I can't find how to put a new field for Mr., Ms., Mrs.
before my First Name field in my database. I have already
entered in 50 entries. I used the Wizard and I have a
Switchboard. Help...

 

[John Vinson]

I can't find how to put a new field for Mr., Ms., Mrs.
before my First Name field in my database. I have already
entered in 50 entries. I used the Wizard and I have a
Switchboard. Help...

Open the Table in design view; add a new field named Title, Text type,
and reasonably short (12 bytes maybe so you can add military titles,
frex).

If you have a Form that you're using to enter data, you can now open
the form in design view, and add a Combo Box to the form (anywhere on
the form you like, such as before the first name). Set its Row Source
Type to Value List and enter the titles that you want in the Value
List property, e.g.

"Ms.";"Mrs.";"Mr.";"Dr.";"Rev."