Wednesday, October 19, 2016

Microsoft Access:How to add a description and set other table properties



How to add a description and set other table properties :

  1. Right-click the table in the Navigation pane, and then click Table Properties. 
  2. Enter a description in the Description box. 
  3. Open the table in Datasheet view. 
  4. On the Table Tools Table tool tab, click Table Properties. 
  5. In the Enter Table Properties dialog box, specify the settings you need.

Materi Microsoft Access : How to Add a Total row to a table and rename table



How to Add a Total row to a table :
  1. In the Navigation pane, double-click the table (or right-click the table, and then click Open). 
  2. On the Home tab, in the Records group, click Totals. 
  3. For each column in the Total row where you want a total to appear, click in the column, and then select the function you want to apply. 
  4. To remove the Total row , click Totals in the Records group.
How To rename a table :

  1. Right-click the table in the Navigation pane. 
  2. Click Rename, and then enter the name you want to use.