how to add Mr and Ms in tables ?

[byenvag11]

hello i already build my table and now they want me to add mr and ms column how to i do that ?

 

[boblarson]

1. Go to the database window

2. Right-Click on the table

3. Select DESIGN VIEW

4. Add a field in the list and select the data type and anything else

5. Save it.

There - you've added a field. If you have queries, forms or reports you will need to go add the field to those as needed.

 

[byenvag11]

thanks actually i was gonna do another post but since you here maybe you can help me that one . I have to add queries
and im having lots of issue i dunno how to which tlb to pu to related to whihc anyway heres the quesiton i need to get answered

• The contacts for the different customers in the tblCustomers table. When you click the plus sign next to a customer, you should be able to view the contacts for that customer.
  
• The customers for each sales rep and the contacts for the displayed customer.
  
• The orders that have been placed for the different products.
  
• The territories with the customers and contacts for each of the territories.

 

[Dennisk]

I would create a seperate table to hold titles and create a combo box lookup on your data entry form. Otherwise if you have a text field you WILL end up with entries such as

Mister, mr. Mr., miter - spelling mistake, not what you want if the title is included on a letter.