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

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.

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.

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.