Access+Setting+fields+in+tables

Home / software / microsoft access / Tutorials

> **Automatic number generated by the database engine** > **Date the employee was officially hired**
 * [[image:http://www.functionx.com/images/practical1.gif width="19" height="18"]]Practical Learning: Setting Status Bar Text for Fields ||
 * 1) In the top section of the table, click EmployeeID and press Tab twice
 * 2) In the **Description** field for the **EmployeeID** field, type
 * 1) In the **Description** field for the **EmployeeID** field, type
 * 1) Press the down arrow key. That puts the caret in the Description field for the **DateHired** field. Type
 * 1) In the left section, click **MiddleInitial**, click the box under the Description column that corresponds to MiddleInitial, and type **Middle initial made of one letter**
 * 2) Press Ctrl + S to save the table
 * 3) To switch the table to Datasheet View, right-click its tab and click Datasheet View

> > > || 08/12/2008 || 297-497 || Arlene || P || Bonds || Married || > || 10/25/2010 || 406-153 || Jeremy || H || Kaminski || > || 05/06/2010 || 927-597 || Thomas || Jacobson || Single || > || 07/10/2010 || 759-027 || Christie || A || Aronson || Married || > || 07/10/2006 || 394-759 || Carlton || Huge || Divorced || > || 02/22/2004 || 927-406 || Patricia || D || Thorn || Single || > || 03/02/2009 || 294-759 || Justine || S || Garland || > > > > > > >
 * [[image:http://www.functionx.com/images/practical1.gif width="19" height="18"]]Practical Learning: Setting Objects Captions ||
 * 1) Notice the words in the columns headers (the captions)
 * 1) Notice the words in the columns headers (the captions)
 * 1) Enter the following records:
 * **DateHired** || **EmployeeNumber** || **FirstName** || **MiddleInitial** || **LastName** || **MaritalStatus** ||
 * 1) To switch the table to Design View, right-click the tab of the table and click Design View
 * 2) In the top section of the table, click EmployeeID
 * 3) In the lower section of the view, click **Caption**
 * 4) Type **Empl ID** and press Enter
 * 5) In the top section, click DateHired and press F6
 * 6) Press the arrow keys to put the caret on Caption and type  **Date Hired**
 * 7) Press F6 to up to the upper part
 * 8) User the arrow keys to select FirstName
 * 9) Press F6, select Caption and type **First Name**
 * 10) In the upper section, click LastName
 * 11) In the lower section, click Caption and type **Last Name**
 * 12) In the same way, set the Caption of MaritalStatus to  **Marital Status**
 * 13) To save the table, press Ctrl + S
 * 14) Right-click the tab of the table and click Datasheet View
 * 15) Click a cell under EmployeeNumber
 * 16) On the Ribbon, click Fields
 * 17) In the Properties section, click the Name & Caption button [[image:http://www.functionx.com/access/buttons/namecaption1.gif width="111" height="22" caption="Name and Caption"]]
 * 18) In the Enter Fields Properties dialog box, click Caption and type **Empl #**
 * 19) Click Description and type **A unique number assigned to an employee**
 * 1) Click OK
 * 2) Click a box under MiddleInitial
 * 3) On the Ribbon, click Name & Caption [[image:http://www.functionx.com/access/buttons/namecaption1.gif width="111" height="22" caption="Name and Caption"]]
 * 4) Click Caption and type **MI**
 * 1) Click OK
 * 2) Right-click the column header of each column and click Field Width. Then click Best Fit

> On the Ribbon, click Home if necessary. > In the Text Formatting section, click the arrow of the Font combo box (the top-left combo box of the Text Formatting section) and click Garamond > >
 * [[image:http://www.functionx.com/images/practical1.gif width="19" height="18"]]Practical Learning: Setting the Font of a Table ||
 * 1) The Employees table should still be displaying in Datasheet View.
 * 1) The Employees table should still be displaying in Datasheet View.
 * 1) Press Ctrl + S to save the table

> In the Text Formatting section of the Home tab of the Ribbon, click the arrow of the Font Size combo box (the top-right combo box of the Text Formatting section) and click 12 > >
 * [[image:http://www.functionx.com/images/practical1.gif width="19" height="18"]]Practical Learning: Setting the Font Size of a Table ||
 * 1) The Employees table should still be displaying in Datasheet View.
 * 1) The Employees table should still be displaying in Datasheet View.
 * 1) Press Ctrl + S to save the table

> In the Text Formatting section of the Home tab of the Ribbon, click the Bold button > >
 * [[image:http://www.functionx.com/images/practical1.gif width="19" height="18"]]Practical Learning: Setting the Font Size of a Table ||
 * The Employees table should still be displaying in Datasheet View.
 * The Employees table should still be displaying in Datasheet View.

> In the Text Formatting section of the Home tab of the Ribbon, click the arrow of the **Font Color** button (the button that displays A) and click the More Colors button > || Green: 250 || > || Blue: 135 || > || ||
 * [[image:http://www.functionx.com/images/practical1.gif width="19" height="18"]]Practical Learning: Setting Text Font on a Table ||
 * 1) The Employees table should still be displaying in Datasheet View.
 * 1) The Employees table should still be displaying in Datasheet View.
 * 1) In the Colors dialog box, click Custom
 * 2) Set the color values as follows:
 * Red: 255 ||
 * 1) Click OK